Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

GetRows from SQL - loading only new rows

Hi Folks,


What I'm trying to do is to load only new rows from an SQL table into a SP list.


Loading the rows works fine but everytime the flow runs it basically adds the same items to the list.


I was hoping that would be able to include a condition that would only add rows that don't already exist in the SP list however the dynamic data doesn't seem to allow me to do that.


Any ideas ?



Level: Powered On

Re: GetRows from SQL - loading only new rows

Ok so - so far the only way I can think of doing it by updating the source table to mark that the row was fetched. 


1. Getrows SQL

2. Condition (if fetched then do nothing, if not fetched then insert into sharepoint list and update the source SQL table with status fetched) 


Is there an easier way of doing it ?

Level 8

Re: GetRows from SQL - loading only new rows

You can filter the SQL rows, based on your execution interval.
F.e.: The Flow is executed once a day, filter data on last modified date greater yesterday.

Or select your last SP entry and filter the SQL data based on that last insert date (time).

Level: Powered On

Re: GetRows from SQL - loading only new rows

Thanks Thomas that would actually make a lot of sense 


how would the syntax for odata filter look in this instance?

Helpful resources


New & Improved Power Automate Community Cookbook

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


Power Automate Community User Group Member Badge

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


Incoming: New and improved badges!

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


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,171)