cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisInTexas
Level: Powered On

Multiple Column Collection

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Meneghino
Level 10

Re: Multiple Column Collection

Use the ShowColumns function:

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

 

PS To be clear:

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

View solution in original post

6 REPLIES 6
Highlighted
Meneghino
Level 10

Re: Multiple Column Collection

Use the ShowColumns function:

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

 

PS To be clear:

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

View solution in original post

ChrisInTexas
Level: Powered On

Re: Multiple Column Collection

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

 

Thanks.

--Chris

rahulvartak
Level: Powered On

Re: Multiple Column Collection

Thanks Meneghino !!

rfenix1984
Level: Powered On

Re: Multiple Column Collection

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!!!!

rfenix1984
Level: Powered On

Re: Multiple Column Collection

here, pics for further understanding, thank you

APM
Level: Powered On

Re: Multiple Column Collection

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

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,296)