Find specific value in JSON Object

(0) Share

Report

Posted on by D3xter

Hi, I have trouble to create a specific flow, since I am really new to REST and JSON.

My JSON Object looks this:

{

"users": [

{

"email": "",

"id": "",

}

]

}

My flow starts, if a new item is created in a sharepoint list. In this entry I get a String value of a specific email. I now need to look up this JSON Object and find the value of the id, where the email matches the String of the SP list entry.

I hope it is understandable!

All responses (2)

Answers (1)

abm abm 32,506 Most Valuable Professional on at

Like (1)

Report

Re: Find specific value in JSON Object

Hi @D3xter

Also watch my YouTube video how to iterate JSON data

https://www.youtube.com/watch?v=cBI-Iz2K4d4&t=86s

Thanks
Verified answer

abm abm 32,506 Most Valuable Professional on at

Like (1)

Report

Re: Find specific value in JSON Object

Hi @D3xter

Follow the below steps:

1. Add a Parse JSON action step

2. Under the content map your JSON data which is from your previous step

3. Click generate from sample

4. Paste the JSON data

5. click ok

6. Next step add a compose and check the dynamic values such as id, email, etc.

Thanks