cancel
Showing results for 
Search instead for 
Did you mean: 

Flows longer than 500 days

Hi, A client has an asset list with a future date (up to 2 years in the future) to email people reminders. This is replacing SP on-premises workflows that use to run forever (Where Flow is limited to 500 days).

 

MS recommends a solution for 17 months (500 days) using a scheduled recurrence flow, but what if we want to have a flow monitor a list for 2 years for expiring items, etc?

 

17 month flow

I created a twitter thread where MS requested I create this ticket: https://twitter.com/eschraderMB/status/1100119786057388032 

Status: New
Comments
Level: Powered On

Here is a diagram of the issue as well. The issue is I cannot pass item data in Flow vars when calling subsequent flows that run for 500 days or less to be able to email someone up to 2 years in the futre on a specific date column in the item.SP 500 day flow issue.PNG

Level: Powered On

Mike Neill on twitter helped me out with this link: https://docs.microsoft.com/en-us/flow/apply-to-each

 

Basically, I just created a scheduled flow that loops through the entire list each day, filtering on items due today. Then, for each item, I email the user with a link to the item, etc. However, I had to hardcode todays date which should be utcNow() but I could not format it correctly in my POC. If anyone knows how to match today in a var to SP date format (01/01/2001 for example) please let me know

works but no dynamic today.PNG

Flow Staff

You can use formatDateTime() function to format the timestamp. As an example 

formatDateTime(utcNow(),'MM-dd-yyyy') returns '03/06/2019'.  Please see here for additional reference on date time functions : https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#d...