cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisInTexas
Frequent Visitor

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
Meneghino Community Champion
Community Champion

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
Meneghino Community Champion
Community Champion

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
Frequent Visitor

Re: Multiple Column Collection

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

 

Thanks.

--Chris

rahulvartak
Frequent Visitor

Re: Multiple Column Collection

Thanks Meneghino !!

rfenix1984
Frequent Visitor

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

Highlighted
rfenix1984
Frequent Visitor

Re: Multiple Column Collection

here, pics for further understanding, thank you

APM
Regular Visitor

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,293)