cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Majingcth
Level: Powered On

Access to JSON object and append to Array

I have a JSON return from HTTP as below:

There is multiple text under different lines of different pages, eg 0-20 in the result.

How can I loop through all the text in all object and append all the text return in an Text array?

 

Many thanks.

Image 2.png

1 REPLY 1
Super User
Super User

Re: Access to JSON object and append to Array

Hey @Majingcth 

Use the 'Parse JSON' action to provide you with a dynamic object in Flow, useful reference: https://spmaestro.com/handling-json-in-microsoft-flow/

Once parsed, you can iterate the collection in a 'For each' loop and use the 'Append to String Variable' action to concatenate the string values.

HTH

Jay

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,107)