cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
devinvalenciano
Microsoft
Microsoft

Does Power Automate support use of the Sliding Window trigger found in Azure Logic Apps?

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,

 

Devin

3 REPLIES 3
Jcook
Super User
Super User

Hello @devinvalenciano

Unfortunately it looks like sliding window is only in Logic Apps at this time.

A way I have done what you are looking for is:
- you can store the value of your date in another system that flow can call. For example SharePoint, or SQL using a stored procedure.

That way you only need to modify the value in SharePoint for the first run.

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





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.

 

best,

 

Devin

Hi @devinvalenciano 

 

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.

 

stay safe!


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,237)