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 / "SQL - Get Rows" - pas...
Power Automate
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:
I have the same question (0)
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 274 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 175

#3
Haque Profile Picture

Haque 166

Last 30 days Overall leaderboard