How can I define custom columns for collect function in Power Apps?

Question

I would like to create a collection from a Sharepoint list in Power Apps. The list contains specific columns which I defined before. But when I add the Collect(mycollection, mySPlist) function as OnStart action I receive a lot of useless column as can be seen in the linked picture. For example "Created date", "ID" even some "table value" like Author.

Of course I cannot process a collection like this because I can't ignore the irrelevant columns when I'm adding a record via some TextInput field. My intention is to update my Sharepoint list with my collection gaining the added records.

The main question: How can I define a collection with custom columns on starting my app?
Thanks for your advices.

SeaDude · Accepted Answer · 2021-07-30 04:13:31Z

1

Investigate using the ShowColumns(), DropColumns() and AddColumns() Functions.

Example:

To remove the useless columns in the Sharepoint list try:

ClearCollect(colTest, 
    ShowColumns(mySPlist,
        "ID",
        "ImportantColumn1",
        "ImportantColumn2"
    )
)

answered Jul 30, 2021 at 4:13

SeaDude

4,4869 gold badges50 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marianr99 · Accepted Answer · 2021-07-26 07:24:43Z

0

ForAll('source' As item,
   Collect(collection,{
     col1: item.Column,
     col2: item.Column2
     })
  )

answered Jul 26, 2021 at 7:24

marianr99

1461 silver badge5 bronze badges

Collectives™ on Stack Overflow

How can I define custom columns for collect function in Power Apps?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related