cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

JSON from Flow into a Collection

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.

 

wsalling_0-1592600335163.png

 

 

 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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.

 

Snipaste_2020-06-22_11-32-27.pngSnipaste_2020-06-22_11-31-28.png

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

View solution in original post

4 REPLIES 4
Super User
Super User

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/



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

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

wsalling_0-1592607996857.png

 

wsalling_1-1592608019622.png

wsalling_2-1592608042539.png

Here is the Power app button

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

 

and i get this in a collection

wsalling_3-1592608094557.png

 

all records in one return.  not parsed

 

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

 

Community Support
Community Support

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.

 

Snipaste_2020-06-22_11-32-27.pngSnipaste_2020-06-22_11-31-28.png

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

View solution in original post

Hi @wsalling ,

I also found this case, did you solve it?

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (103,422)