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
Users Online
Currently online: 103 members 4,276 guests
Please welcome our newest community members: