Parse JSON back to Powerapps

[wsalling]

I have created a Flow that gives me a listing of all files in a OneDrive folder.  It is in Json format.  I created an action to Parse Json, but now how do i get it back to PowerApps.  I have tried Response and setting Body to Body put it will not load in powerapps.

is there a different way? i need this in a collection so user can select a file from the list.

[rsaikrishna]

@wsalling 

Whats your Power App data source?  I am assuming it is SharePoint or CDS or SQL. 

If it is so, write your file information into SharePoint list or CDS entity or SQL table as individual entries. From here you can easily show it in Power App. While showing in the Power App, you can load the content into a collection easily.

(OR)

Are you calling this flow from Power App to load the files information? If so, you can pass the information back to Power App by using "Respond to Power Apps" action.

Blog for reference: https://flow.microsoft.com/en-us/blog/return-data-to-powerapps/

Give a try both the options and let me know if you have any questions.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[wsalling]

The Source is OneDrive.  

From here i have tried a respond to power apps with a string, a compose trigger and a response but i cannot get either of them to return something usable.

what i get in return is this

i need to parse it out to make a usable collection.  i have tried using ParseJson in flow. but i cannot get it to respond with anything.

[rsaikrishna · Accepted solution]

@wsalling 

You have a JSON object. 

Below Parse JSON action, you can place Apply to each action and loop thru each object. Create a string of values from each object and use "Append to string variable" action to consolidate all the values. Pass it into Power App as a string.

I found a video which explains in detail how to pass an object collection to Power Apps from Power Automate and convert it back to collection.

https://www.youtube.com/watch?v=8oAB2RTO3TE

Let me know if you have further questions.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[TedBabcock]

Mr Dang has addressed this issue. He provides a clear explanation and, even better, an app that will create the complicated formula you need to parse JSON in PowerApps:

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-a-sql-stored-procedure-to-powerapps-...

[hemrhk]

Using the Respond action this can be achieved and with help of formulas we can construct back to the collection again in PowerApps.

Send JSON to Canvas App from Flow

Subscribe to 365 Stack for instant updates