Hello experts,
I`m trying to parse JSON object from Power Automate to Powerapps.
(Need to store JSON data in powerapps collection)
A JSON from API is like this.
{ "total":863, "data":[ { "id":6154616, "categories":{ "total":0, "data":[ ] }, "isAnonymized":false, "jobOrders":{ "total":0, "data":[ ] }, "jobSubmissions":{ "total":0, "data":[ ] }, "lastName":"u engineering", "leads":{ "total":0, "data":[ ] }, "timeZoneOffsetEST":10 },{ "id":85456552, "categories":{ "total":0, "data":[ ] }, "isAnonymized":false, "jobOrders":{ "total":0, "data":[ ] }, "jobSubmissions":{ "total":0, "data":[ ] }, "lastName":"Engineering", "leads":{ "total":0, "data":[ ] }, "timeZoneOffsetEST":10 } ] }
As you can see JSON data contains multiple nested arrays, and data property will have multiple employee data.
So, to store this JSON data in powerapps collection, i have created power automate which has below steps.
The flow of the Flow is like this. If the button on powerapps was clicked, it will call the API and get the result of JSON.
To store that json in collection i have used below formula's.
But all four collection shows only property name of JSON, not showing data.
How can I get items from this type of JSON?
Any help is greatly appreciated.
