Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Updating SQL rows based from Excel file from SharePoint site



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.




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.





Need help on this one.


Thank you!


Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (95,571)