Parse JSON One Drive Error

[RTS1234]

Hello,

Struggling with this.

I have a flow to extract documents uploaded and send them to a specific OneDriver folder. However it is not working at the Parse JSON stage. Any ideas?

The Flow:

[Expiscornovus]

Hi @RTS1234,

Instead of the Parse Json I would use an expression to turn the answer into an array which you can loop through. To retrieve the content you can use the id of file, this way you don't have to hard-code the path.

Below is an example of that approach.

[grantjenkins · Accepted solution]

Your Parse JSON schema is a single object but needs to be an array.

I'd suggest the following:

1. Add a Compose directly after your Get response details and pass in your Question (same one you're currently passing into the Parse JSON).
2. Run the flow (you will still get the error on the Parse JSON, but we will fix that shortly)
3. Copy the Output from the Compose action.
4. Got back to Edit mode and for your Parse JSON action click on Generate from sample and paste in the Output you just copied to generate the expected schema.
5. Remove your Compose action as you don't need it anymore.
6. Run your flow and hopefully it now works.

[RTS1234]

@grantjenkins 

Amazing thank you. Simply changes. It now indeed works.

k 

The next challenge is to work out how to save it as the correct file format!

[grantjenkins]

I'm not sure what file content you're getting, but you should just be able to add the extension to the end of your File Name in Create file. If it was a PDF, then you'd just add .pdf