
Announcements
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?
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.