Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Get Array from Json

Hi, I have a json file in onedrive and I wish to get an array of values from it. The json file has an array of objects contained in it.


  { "First": "" 
      "Last": ""
       "Address" : "" 
  { "First": "" 
      "Last": ""
       "Address" : "" 





  • get the file from onedrive using "Get file content using path"
  • convert the base64 to a json object
  • Parse JSON
  • Initialize variable
  • Apply to each & Append to variable array


at this point I get the error

"ActionFailed. An action failed. No dependent actions succeeded." Anyway this seems like a lot of work to just get a bunch of values which could easily be done if I were using something like jsonPath.


Maybe my approach is incorrect. Any help here would be appreciated. Tks

Community Support
Community Support

Hi @ld,


Please check the following blogs for a reference:


A Thesis on the Parse JSON action in Microsoft Flow


Best regards,


Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

thanks @v-yamao-msft I've looked at both of those and cannot see anything thats going to help. 

Do advanced examples of flows exist using expressions and json. May someone could point be to those? 



@ld i have the same questions, did you get any solution for this?

@jho This seems to work: 


split(replace(replace(string(body('YOUR ACTION NAME')),'{',''),'}',''),',')


from this post

Frequent Visitor

Hi ID,


Could you please help opening the json file from sharepoint / onedrive and convert the base 64 to a json object, Parse JSON... please

Frequent Visitor

Can anyone, please help me to open a json file from sharepoint, convert the base 64 to json object, so I can parse JSON and then use the json data in my flow..

Please, help me !!!

Advocate IV
Advocate IV

@apc_and_rod, perhaps this thread would be helpful to you.


Do you have a flow already created that is erroring out?  You'll need to be a bit more specific as to what trouble you're having in the process.

All good now, the problem was null values in some fields, replaced them for "".

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,830)