Parsing json data in Power Automate Desktop

(0) Share

Report

Posted on by Unknown123

115

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?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Unknown123 115 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes. I am able to.

After clicking on More.

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

Was this reply helpful? Yes No
Unknown123 115 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like
a
(2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Unknown123 115 on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Unknown123 115 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No