Unanswered

Error in SQL Server On premise Update Row

(1) Share

Report

Posted on by CU24101024-0

Hi everyone,

I've noticed an issue with the Update Row V2 action. I have an SQL Server table with over 100 columns, but when I try to update rows using Update Row V2, some columns—specifically the key columns—aren’t appearing.

Any ideas on how to resolve this?

Categories:

Error handling

Automate Error.PNG

I have the same question (0)

All responses (5)

Answers (0)

KeithAtherton 3,705 Most Valuable Professional on at

Like (2)

Report

Hey. Can you share a screenshot of the cloud flow in the designer, especially where these fields are being set, please?

Was this reply helpful? Yes No
CU24101024-0 6 on at

Like (1)

Report

Thanks @Keith for your replay

This is the flow that I have worked with

Was this reply helpful? Yes No
CU24101024-0 6 on at

Like (1)

Report

As shown on the screenshoot, the action in Power Automate displays only 97 columns, even though the table contains a total of 100 columns.

Was this reply helpful? Yes No
Suggested answer

KeithAtherton 3,705 Most Valuable Professional on at

Like (1)

Report

Hey. Thanks for the screenshots. I suspect that the key columns may not be displayed if they're auto-generated (e.g. an identity column) so it may be that Power Automate is trying to be helpful as we cannot explicitly set values for them.

Is that the case? Or can we set explicit values for the 3 missing columns?

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (1)

Report
Check out the following:

Verify Primary Key: Ensure the table has a properly defined primary key.

Reduce Columns: Use a view to limit the number of columns in the table.

Refresh Metadata: Disconnect and reconnect the SQL Server action in Power Automate.

Use Supported Data Types: Check key column data types.

Custom Query: Use parameterized SQL queries if the issue persists.

Was this reply helpful? Yes No