cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wsalling
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
v-siky-msft
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

6 REPLIES 6
Jeff_Thorpe
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.

 

v-siky-msft
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

Anonymous
Not applicable

Hi @wsalling ,

I also found this case, did you solve it?

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

hemrhk
Post Patron
Post Patron

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

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,608)