Hello,
I am trying to create/update a collection with the values from a SharePoint List item's multi value column, do you think you can help?
For example, my sharepoint list "Materials" has 3 columns
Name || Type || Date
Car || Metal, Glass || 10/31
House|| Wood, Metal, Glass || 10/22
Bat || Wood || 9/20
How would I create a collection from only the "Type" column specific to the House item so my new collection would be
newCollection = Wood, Metal, Glass
I attempted something like
ClearCollect(
newCollection,
ShowColumns(
'Materials', "House.Type"
)
But no luck. Any help would be appreciated thank you
