Announcements
I have two columns in my SharePoint List 'State_Mandates':Role1 Role2 ID
Apples Grapefruit 1
Bananas Oranges 2
Pears Grapes 3
I would like to create a collection that will stack all of these items into a single Column and return their corresponding ID number as well. Here's an example:Role IDApples 1
Bananas 2
Pears 3
Grapefruit 1
Oranges 2
Grapes 3
Please help and thank you!
Hi @kgiles123,
You could use the following code to achieve this:
ClearCollect( colMerged, Ungroup( ForAll( 'State_Mandates', [ { Role: Role1, ID: ID }, { Role: Role2, ID: ID } ] ), "Value" ) )
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
Thank you!!!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 531 Most Valuable Professional
Haque 261
Kalathiya 221 Super User 2026 Season 1