cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

SQL row gets modified - Update SharePoint list item with new data

I have a table in a SQL server. I have currently created a flow that will create a new SharePoint list item whenever a new row is added to the SQL table.

 

How do I create a flow that will modify the SharePoint list item when that row is modified in the SQL table?

3 REPLIES 3
Community Support Team
Community Support Team

Re: SQL row gets modified - Update SharePoint list item with new data

Hi @Anonymous,

 

If you want to sync the modify item from SQL table to SharePoint list, please make sure there is column has the same value SQL table item with column value in the SharePoint list item.

 

For example, the SQL table and the SharePoint list would all have a Title column and will always has the same value, you could refer to screenshot below to create the flow:

Capture.PNG

 

Best regards,

Alice

Anonymous
Not applicable

Re: SQL row gets modified - Update SharePoint list item with new data

@v-yuazh-msft Hello Alice, unfortunately, it did not work. Here is what I did.  Nothing happened.SQLSharePoint.jpg

HenryADNewComm
Level: Powered On

Re: SQL row gets modified - Update SharePoint list item with new data

Hi, I had the same challenge and solved it within flow by updating all entrys ones a day. when an item is changed Flow will update the item in SharePoint, when there is a new item Flow will create it. For my purpose one run a day is okay. the downside of this is that one run takes an hour for only 50 rows. The SQL get Items is getting the items from a SQL view I created with "SQL Server Management Studio". For create I created another view (right part of the flow). I can't get the SQL triggers working due to the database is not in Azure, that's why i don't use it.

 

Flow.png

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,006)