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 / How to read output of ...
Power Automate
Unanswered

How to read output of custom connector inside apply to each second action

(0) ShareShare
ReportReport
Posted on by 6

Hello

I have implemented a custom connector which calls a REST API and generated json output.

I am using the connector in apply to each section and want to get the fields returned in the response API in second section of the action. But I am not able get the values in the field.

DataFetch.PNG

 

But in output I am receiving null value

excel.PNG

Categories:
I have the same question (0)
  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Harmanpreet,

     

    Could you please share a bit more about your custom connector?

    Could you please show more details about the response your custom connector returned?

    Further, do you want to insert the output of the custom connector into your Google sheet?

     

    Please check if you have specified proper File and Worksheet in your "Insert row" action. Please also check if the output your custom connector returned is proper. 

     

    You could consider view the run history of your flow, then expand the "DataFetch" action (your custom connector) to see the output the custom connector returned. Check if the Dynamic contents the custom connector returned contains proper values.

     

    In addition, please check if you have specified proper "x-ms-dynamic-values" OpenAPI extension within the OpenAPI for your custom connector. More details about the "x-ms-dynamic-values" OpenAPI extension, please check the following article:

    "x-ms-dynamic-values"  OpenAPI extension

     

    More details about customizing connector in Microsoft Flow, please check the following article:

    Custom connector in Microsoft Flow 

     

     

    Best regards,

    Kris

  • Harmanpreet Profile Picture
    6 on at

    Hello

     

    The response of custom connector is in json form as shown in attached image

    Capture.PNG

     

    Now I want to read and send this data on specified fields of google sheet such as Contact_FirstName.

    The custom connector which I have created is using an already defined API.  I have used creating custom connector from scratch and didnot uploaded any extension file.

    If any changes are required further please specify.

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
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard