web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collect certain column...

Power Apps

Answered

Collect certain columns with complex values

(0) Share

Report

Report

Posted on by shamwoox

5

I want to store specific columns with complex values from a SharePoint list into a collection. I know I can do:

Collect(ListName, ShowColumns("Title", "Description"))

to store specific column items to a collection; however, with complex column types like Choices and Person/Group, it's stored as an object. How can I get the values of those complex fields and store them in a collection?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@shamwoox

You really don't need to convert the records to only their Value values. Doing so will cause you more work later on if you expect to write them back to the datasource in any way.

However, the following can do it - there are several ways.

Collect(yourCollection, ForAll(yourDataSource, {Title: Title, ChoiceValue: ChoiceColumnName.Value, LookupValue: LookupColumnName.Value, PersonValue: personColumnName.Email } ) )

I hope this is helpful for you.

Was this reply helpful? Yes No

Join the conversation