Unanswered

Update Sharepoint List by comparing value to SQL

(0) Share

Report

Posted on by rashantha

I have a SharePoint list with Item# and I need to go thru each Sharepoint Record and compare the Item# with the SQL db and then get the Item Description from the SQL db and update the sharepoint record.

Manual Trigger

Get Sharepoint List (Get Items)

Appl To each > Value

Get row of SQL db where Item# matches Item#SQL

Update Sharepoint record with Item Description from SQL

I can't seem to get this to work.

Thanks for any assistance.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are you getting any errors or is the change just not being made?

Was this reply helpful? Yes No
rashantha 65 on at

Like (0)

Report
Copy link

Link copied!

There was a warning and no changes get made.
I saw an automate that had
Get Sharepoint List followed by
Get Rows in SQL
I am going to give that a try.

Was this reply helpful? Yes No
rashantha 65 on at

Like (0)

Report
Copy link

Link copied!

I was able to get this to work but running into the issue of seeing fields that I don't want updated/changed.
I want to only change 'Item Description'
'Item/OrderPlaced/Value keeps showing up even though I have created a view that shows only ID and 'Item Description'

Was this reply helpful? Yes No
rashantha 65 on at

Like (0)

Report
Copy link

Link copied!

I was able to get this to work but running into the issue of seeing fields that I don't want updated/changed.
I want to only change 'Item Description'
'Item/OrderPlaced/Value keeps showing up even though I have created a view that shows only ID and 'Item Description'

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (1)

Report
Copy link

Link copied!

Yeah power automate doesn't seem to really care about what you put into views, in your case you might consider following the instructions on the site below, basically replace the update item with a send HTTP to sharepoint. This will be your key to running API commands to update only the columns/fields you want and nothing else.

REST API to Create and Update SharePoint List Items from Power Automate (annajhaveri.com)

Was this reply helpful? Yes No