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

All responses (5)

Answers (0)

Sort by

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Hey. Can you share a screenshot of the cloud flow in the designer, especially where these fields are being set, please?
CU24101024-0 6 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @Keith for your replay

This is the flow that I have worked with
CU24101024-0 6 on at

Like
a
(1)

Report
Copy link

Link copied!

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

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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?
Suggested answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
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.