cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
b00weck
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 ?

 

 

3 REPLIES 3
b00weck
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 ?

Thomas
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).

b00weck
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

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 (4,171)