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? 



New Member

@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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (5,497)