jszab93
jszab93

Reputation: 5

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

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.

Getting an image collection

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.

Upvotes: 0

Views: 8084

Answers (2)

SeaDude
SeaDude

Reputation: 4405

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"
    )
)

Upvotes: 1

marianr99
marianr99

Reputation: 146

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

Upvotes: 0

Related Questions