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 / SQL Server Get Row (V2...
Power Automate
Unanswered

SQL Server Get Row (V2) doesn't return all columns

(4) ShareShare
ReportReport
Posted on by 31

I have a flow with a connection to an on-premises SQL Server database though an on-premises data gateway.

When I use a SQL Server Get Row (V2) action it only returns part of the columns of the table. If I enter the missing column names in the Select Query field, it doesn't return them either.

When I use a SQL Server Update Row (V2) action on the same table, it does show me all the columns.

 

I've tried making a new connection to the same database for the Get Row step, but that didn't solve the problem.

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    on at

    I am having exactly the same issue.  @flowadmin3 did you manage to solve this in the end?

  • Futumpch1 Profile Picture
    20 on at

    Does anyone else find this or get a fix I am having the same issue.

  • Steve_Wilmer Profile Picture
    16 on at

    I have found that my Column is missing if the field in SQL server is NULL, but is returned if blank. 

     

    I have found nothing works even creating new connectors.

     

    If you have the same behaviour the workaround might be to ensure the column in sql you need is empty not null.

     

    You can still refer to the column even if it doesn't exist in the run using a expression if(empty(columnname,......

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard