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 III
Super User III

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_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (3,159)