Unanswered

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

(4) Share

Report

Posted on by flowadmin3

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:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Futumpch1 20 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Steve_Wilmer 16 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No