How to iterate through JsonAsCustomObject?

(0) Share

Report

Posted on by Sanket1

357

Spoiler (Highlight to read)

Hi Team,
I want to iterate through Json file to access specific json data
please help me how I will.

this my json data

I want to access specific data by using their number n

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report

@Sanket1

Please follow the below approach using specify number or even you can for each as well

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report

If you open the Custom object and select More

You can see that the indexing is like that JsonAsCustomObject['1']. So its a string number

Then you use the Name value of which row you want. So in my pic example if I want the firstname: %JsonAsCustomObject['1'].FirstName%

And if you want to loop through it:

Was this reply helpful? Yes No
Sanket1 357 on at

Like (0)

Report

I tried your approach but I am getting this error

Was this reply helpful? Yes No
Sanket1 357 on at

Like (0)

Report

I want to make it dynamic

some has data, some has tables and key-value

Was this reply helpful? Yes No
eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report

So the CustomObject is not structured so that all the items are similar structure but some are strings and some tables? Could you maybe show how it looks? Would be easier to help out. If there is sensitive data just change it to something else.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report

@Sanket1

Please share screenshot like below to understand your custom object format (After hiding all sensitive info).

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Verified answer

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Sanket1 ,

Why do you want to loop the JsonAsCustomObject.
You can directly call which ever Item you want and where ever you want or its required as shown in below image.

ConfigorJsonasCustomObject Image:

How to call CustomObject in the flow image;

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No