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

Notifications

Announcements

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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard