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

Community site session details

Session Id : YZSKbVlnNRuvILETLl4vIJ
Power Automate - Using Connectors
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 24 Aug 2016 14:23:57 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 02 Sep 2016 at 08:37:39
    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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Loading complete