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"));