SQL Gateway / Flow / SharePoint List

[Anonymous]

Good afternoon! I have a flow that is successfully pulling data into a SharePoint list at midnight every day. I would like to add a feature where it only updates the rows or columns that have actually changed. I would like to do this so that it doesn't have to replace the list every time it runs. Is there such a thing?

NOTE: currently it is not replacing the list, it is duplicates the list on the new run.

Thanks!

Jamie

[v-bacao-msft]

Hi @Anonymous ,

It seems that you want to get the items that were changed the day before. If so, you can refer to the following method:

In other words, you can directly use When an item is created or modified as the trigger to get the new item or the changed item.

You could use condition to determine whether the item has been changed or newly created.

Feel free to let us know if you have any questions.

Best Regards,