JSON from Flow into a Collection

[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.

[Jeff_Thorpe]

You can also use the Power Apps action "Respond to a PowerApp or flow".

Return data to PowerApps from a flow, build lists in a flow, and test a flow with previous run data
https://flow.microsoft.com/en-us/blog/return-data-to-powerapps/

Interacting with Power Automate Flows from Power Apps – Canvas Apps
https://www.inogic.com/blog/2019/12/interacting-with-power-automate-flows/

[wsalling]

Thank you for the leads. but i can get a return from my Flow but it is not parsed out of JSON.  here is by flow below

Here is the Power app button

ClearCollect(Testing,
'PowerApp->Findfilesinfolderbypath'.Run("\"))

and i get this in a collection

all records in one return.  not parsed

i need them parsed out so i can call the file names out.

[v-siky-msft · Accepted solution]

Hi @wsalling .

The Response Body JSON Schema is required if you want to pass the Array/Object to PowerApps.

Try to Copy the Output of Parse JSON action in the previous Flow running result, and paste it as a sample in response action, then JSON Schema is generated.

When this is done, re-add the flow to the App, and try again to see if the issue is fixed.

Hope this helps.

Sik

[lusoftware]

Hi @wsalling ,

I also found this case, did you solve it?

[BegeNCSU]

If you're still looking for an answer, this view was made for SharePoint data but the foundation is still the same.