Ungroup A Table Stored In A Cell [object, Object]

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/ungroup-a-table-stored-in-a-cell-object-object/. Author: Matthew Devaney.

Ungroup A Table Stored In A Cell [object, Object] Input collection: myMeetingRooms47 Info value This is a list of meeting rooms [object Object], [object Object]…

Note: [object Object], [object Object]… refers to a table stored in a cell. This is how PowerApps displays a table as text. Output collection: mySolution47 NickName People Building Redwood 10 Building A Oak 25 Building A Pinetree 8 Building B Cedar 15 Building B Solution code: //Create a collection

ClearCollect( myTable47, { NickName : "Redwood" , People : 10 , Building : "Building A" }, { NickName : "Oak" , People : 25 , Building : "Building A" }, { NickName : "Pinetree" , People : 8 , Building : "Building B" }, { NickName : "Cedar" , People : 15 , Building : "Building B" } );

ClearCollect(myMeetingRooms47, { info : "This is a list of meeting rooms" , value : myTable47}); //Get a table stored in a cell code

ClearCollect(mySolution47,Ungroup(myMeetingRooms47, "value" )); Code language: JavaScript ( javascript )