Can I use the Sliding Window trigger in Power Automate, as described here - https://docs.microsoft.com/en-us/azure/connectors/connectors-native-sliding-window
If not - is there another good way to backfill data using Power Automate (i.e. schedule a daily job, but on first run, run jobs all the way back to a set StartDate)? Like if the Recurrence trigger allowed a StartDate in the past?
Thanks for the response!
Do you have any example Flows using the logic you describe? I'm having trouble envisioning, but would be happy to use SharePoint or SQL as a workaround.
after reading your post again, I don’t know if my prof idea will work. Before I post an example, I will explain further what I am talking about.
So I have this integration where an excel file will be read with customers. And last updated fields
now there are over 100K records. And the team only wants an initial load of all customers from now until 2010, than moving forward, they want only customers that have been last updated until now and 35 days back.
In that scenario we want to do a initial load of the data. Than only check for updates to customers 35 days old moving forward.
for example this was done with SharePoint list where a value can be put into a certain list let’s say 60.
the integration runs every Monday and will now minus 60 days from an expression utcNow() using the addDays() and than a filter array will be used to only get records 60days old and newer.
sorry if this is not what you are looking for.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
If you are a small business ISV/Reseller, share your thoughts with our research team.