Unanswered

How to get value of a particular key in json format in power automate desktop

(0) Share

Report

Posted on by Pavibhau_3698

When I use get method to invoke a web service I get the entire page in json format , I want only value using key in json .

How do I filter out value using key in power automate desktop , should I perform loops or condition to retrieve one particular value using key which is in json format

Kindly help me out

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

VJR 7,635 on at

Like (0)

Report

Hello @Pavibhau_3698

Could you take a look at the solution links here.

Was this reply helpful? Yes No
Pavibhau_3698 18 on at

Like (0)

Report

Hi,
This didnt help coz the json didnt get converted to proper list to iterate particular list[0],list[2]
how to convert json object to proper list so I can use index to retrieve particular value

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @Pavibhau_3698

After you converted the JSON to Custom Object in PAD, you can retrieve the value from custom object using index number.
For instance, I created the sample flow like below:

You can use "Count()" function to know how many users in this object:
%Count(JsonAsCustomObject['users'])%

Then iterate the Loop for all users in this object using variable %LoopIndex% to retrieve first name of each users:
%JsonAsCustomObject['users'][LoopIndex]['firstName']%

Please try it.
Thank you.

Was this reply helpful? Yes No