cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jendy
Helper II
Helper II

SQL data into Sharepoint list

Hello,

 

I want to create Sharepoint list which will take actual data from SQL server and update it inside Sharepoint list BUT without remove all data inside Sharepoint list. I need to check if data in SQL and data in SP list are same and add/remove only data which are different.

I tried to filter data with something like (PersonNumber eq 'PersonNumber'(Dynamic content)) over Get items in SQL connector but honestly it doesnt work. 

 

sql.png

Do you have some tip, how to create actual SP list without long time process in flow and no remove all data in list and create again?

 

 

1 REPLY 1
peter-wxin
Regular Visitor

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,561)