Parsing json data in Power Automate Desktop

[Unknown123]

Hello everyone.

I am running a web api in Power Automate Desktop. I am getting a json result from it.

I know how to parse json data in a cloud flow but how to do it in PAD.

The data I am getting is:

{"Info":{"Mode":"Email","Value":"abc@gmail.com"},"Success":true,"Message":""}

How can I get the Email and abc@gmail.com in two different variables.

And then store it in the excel.

I was able to penetrate inside Info but how to get the data inside it.

Can anyone show all the steps in a PAD flow?

@VJR 

@Henrik_M 

@MichaelAnnis 

@Ankesh_49 

@ryule 

[VJR]

Are you able to read the desired value from the Convert JSON to custom object action?

[Unknown123]

Yes. I am able to.

After clicking on More.

I have also used set variable after that to get the values inside info separately.

[Unknown123]

So, I was able to get the Email and abc@gmail.com values, with the help of that index thing I tried above. Now I am adding an array of it. So, lets say, I have something like this now:

{"Info":[{"Mode":"Email","Value":"abc@gmail.com"},{"Mode":"Email","Value":"def@gmail.com"}],"Success":true,"Message":""}

So, now how can I handle this?

Do, I have to apply a loop here?

Can you guide me here?

[VJR · Accepted solution]

Hope this is what you are looking for.

- Iterate using loop as below

- Below will give the desired values

Since this is inside a loop, the 2nd iteration will show its own values

[Unknown123]

@VJR 

Yes I was looking for that only. But now I have added one more complexity to it, can you check the above message.

So, I was able to get the values with the help of loop. But, currently I have given static value in loop. So, how can I find the total number of iterations to do?

[VJR]

Did you take a look at the loop in my screenshot above which iterates only as per the number of items?

Please do not keep modifying the old post as members won't be able to relate to your question and the answer to it.

[Unknown123]

@VJR 

My bad, I didnt look at that for each loop. Thanks for the help.