Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Connectors
Unanswered

"SQL - Get Rows" - passing data to other steps?

(0) ShareShare
ReportReport
Posted on by 5

I'm trying to get data from our SQL server (I have connected this correctly) and pass this data to other steps.

One example would be sending it to Excel using 'insert rows'.

 

When the flow runs however, i just get random data added to the table.

e.g.

__PowerAppsId__
WXYTGHbwEVk

 

Is there a method to passing data to Excel 'mapping' the sql column names to the Excel column names? Or is this not supported yet?

 

Many thanks

 

 

Edit - just realised this is in the wrong place... it's a problem with Flow rather than PowerApps - could someone move it there for me?

Categories:
  • v-yamao-msft Profile Picture
    on at
    Re: "SQL - Get Rows" - passing data to other steps?

    Hi Aerowork,

     

    I created a flow which was triggered by a Recurrence, followed by an action “Get rows” from an Excel table in OneDrive, then insert a row into a Google sheet. When the flow ran, I got similar data with you.  When we configure the flow, it seems that there is no output about which column to be selected. Below is a screenshot of the data inserted to my Google sheet.

    insert rows.PNG

     

    To get mapping column names, I suggest you to submit an idea at “Flow Ideas”. The link of the “Flow Ideas” is:

    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

    PS: This thread has been moved to Flow Forum.

     

    Best regards,

    Mabel Mao

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Featured topics