Multiple Column Collection

[Anonymous]

In PowerApps, I can create a collection of an entire Sharepoint list (all columns) as below:

Collect(colWhatever, TheListName)

But I cannot figure out how to specify just the 2-columns that I need in from the list, like:

Collect(colWhatever, TheListName.Column1, TheListName.Column1)

Thanks for your help in advance.

--Chris

[Meneghino · Accepted solution]

Use the ShowColumns function:

https://powerapps.microsoft.com/en-us/tutorials/function-table-shaping/

PS To be clear:

ClearCollect(ColWhatever, ShowColumns(TheListName, "ColumnName1", "ColumnName2"))

[Anonymous]

Meneghino you are the man....works like a champ!

Thanks.

--Chris

[rahulvartak]

Thanks Meneghino !!

[Anonymous]

hello Meneghino i have a problem and maybe you can help me, im triying to create a link between a table column and another page inside the same app, the trick is that when i press the link in the column i would like to be taken to the page in question showing the data from that column, help please!!!!

[Anonymous]

here, pics for further understanding, thank you

[APM]

Thanks, Meneghino!

---

@Meneghino wrote:

Use the ShowColumns function:

https://powerapps.microsoft.com/en-us/tutorials/function-table-shaping/

PS To be clear:

ClearCollect(ColWhatever, ShowColumns(TheListName, "ColumnName1", "ColumnName2"))

---