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 / Updating SQL rows base...
Power Automate
Unanswered

Updating SQL rows based from Excel file from SharePoint site

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I am having a problem with my flow. It is suppose to update rows in an SQL table based from entries in excel which is located in a SharePoint document library. All steps have green checks on them which means it worked but on the Update row (V2) action, there was an error saying "Invalid column name".  I tried all I know but still can't get that update row action to work.

 

nlandichotech_0-1616633532717.png

 

Here is the error details: the rec_id is the column name and 3380 is the value.  They came from the query action Get rec id.

 

nlandichotech_1-1616633621086.png

 

 

Need help on this one.

 

Thank you!

Categories:
I have the same question (0)

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 248 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 207 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 101 Super User 2026 Season 1

Last 30 days Overall leaderboard