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 / Would it be possible t...
Power Automate
Answered

Would it be possible to parse an API response? To get specific fields only.

(2) ShareShare
ReportReport
Posted on by Microsoft Employee

I am using GET from an API link and I only need 4 fields. Would it be possible to identify specific fields from an API response?

Categories:
  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

     

    Could you please share a screenshot of your flow's configuration?

    Do you want to parse an HTTP response and get specific fields within your flow?

     

    If you want to get specific fields from your API response, you should parse your API response into a JSON format firstly and then

    get the specific fields from the JSON data.

     

    If you want to parse an HTTP response into JSON format within your flow, I think the "Parse JSON" action could achieve your needs. More details about parsing HTTP response into a JSON data using the "Parse JSON" action, please check the following blog:

    https://sergeluca.wordpress.com/2017/09/22/extend-microsoft-flow-with-the-microsoft-graph-and-0-code/

     

    More details about the "Parse JSON" action, please check the following article:

    https://flow.microsoft.com/en-us/blog/five-services-json-http/

     

    If you want to get specific fields from the JSON data, I think the "Select" action could achieve your needs. I have made a test on my side, please take a try with the following workaround:8.JPG

    Within "Select" action, From field set to following formula:

    array(body('Parse_JSON'))

    WIthin Map entry, type these fields (specific fields) that you want to get from above JSON data. The key set to field name and the value set to corresponding dynamic content from the "Parse JSON" action.

     

    The flow works successfully as below:9.JPG

     

     

    Best regards,

    Kris

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Here is my Flow.

     

    flow 1st part.pngflow 2nd part.png

     

    Here is the result.

     

    flow result.png

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

     

    The fields I needed are inside an array. How can the fields inside an array be parsed? Thank you so much for the response. I really appreciate your help.

     

    After parsing the fields. I will use a POST method to transfer the result to a table in a system.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 263

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard