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

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Users Online
Currently online: 152 members 3,190 guests
Please welcome our newest community members: