Unanswered

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

Like (0) Share

Report

Posted on 30 Sep 2021 11:54:31 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

All responses (3)

Answers (0)

Community Power Pla... on 02 Oct 2021 at 05:22:40

Like (0)

Report

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

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.
Pavibhau_3698 18 on 30 Sep 2021 at 12:36:30

Like (0)

Report

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

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
VJR 7,635 on 30 Sep 2021 at 12:01:06

Like (0)

Report

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

Hello @Pavibhau_3698

Could you take a look at the solution links here.