web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Queries in a HTTP action
Power Automate
Unanswered

Queries in a HTTP action

(0) ShareShare
ReportReport
Posted on by 19

I have an API endpoint: https://api.test.com/people which returns hundreds of people in the below format (each person is a separate object in an array named data. I'm wondering how I can set up my HTTP request in Power Automate to pull only John's record, by just using his name (or email). 

 

I tried putting name in the key field and John Doe in the value field, but it didn't work. I'm assuming because it's inside the data array. Any suggestions on how I can pull John's record by using his name or email?

 

Here is a sample of data returned when I make a HTTP get request (I apologize in advance for not formatting this code but my last couple of posts got marked as spam, so I'm going to try it this way)

 

{
"data": [
{
"id": "123456-abcd-98765",
"name": "John Doe",
"emails": [
"johndoe@gmail.com"
]
},
{
"id": "654321-dcba-56789",
"name": "Jane Doe",
"emails": [
"janedoe@gmail.com"
]
}
]
}

Categories:
I have the same question (0)
  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    Here is one possible solution.

    Using the shared json data to Compose then filter data based on email(you can use name as well).

    Kaif_Siddique_0-1662407740782.png

    Kaif_Siddique_2-1662408563503.png

    outputs('Compose')['data']@contains(item()['emails'], 'johndoe@gmail.com')

     

    Let me know if any queries.


    If you like my response, please give it a Thumbs Up.
    If this helps, please Accept as solution.


    Regards
    Kaif

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard