Unanswered

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

(0) Share

Report

Posted on by devinvalenciano Microsoft Employee

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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Jcook 7,781 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
devinvalenciano Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

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!

Was this reply helpful? Yes No