long running flows alternatives say for 1-3 years time

[westerdaled]

Hi

I  was asked today about triggering the sending of emails to spefic users ( approvers)  based on a ' resissue date' in a SharePoint online document library.  the approvers aren't particapting in a workflow in this case but just being prewarned. This got me thinking about the best way to implement this.

1. Do I scan through the documents in the library and create a flow per document item set to the reissue date. The resissue date are between 1-3 years tome.
2. If the user later checks in the document with a differerent reissue date I want to remove the old flow and create a new one
3. Should I use another technology such as SharePoint designer workflows.

Be interested to hear if anyone has implemented such a requirement

Daniel

[Jaden · Accepted solution]

We currently support Flows running up to 30 days only.

However, this does not mean you cannot use a workflow that accomplishes what you seek to accomplish.

Regardless of the source of your data (SharePoint, an Excel sheet, a SQL database, etc.) you can always have a flow that runs, say, once a day (using the "Recurrence" trigger), queries your data source, and then checks to see if the date of an entry (e.g. the date the item was created, or maybe the value of the item or entry is the date of last issue), and if the value is a certain amount of days/months back (computed with a conditional) decide whether to trigger a reissue email or not (the check could be for 1 year old, 2 year old, etc. items).

I hope this helps.

Please do post if you would like more help with this.

[westerdaled]

---

@Jaden wrote:

We currently support Flows running up to 30 days only.

However, this does not mean you cannot use a workflow that accomplishes what you seek to accomplish.

Regardless of the source of your data (SharePoint, an Excel sheet, a SQL database, etc.) you can always have a flow that runs, say, once a day (using the "Recurrence" trigger), queries your data source, and then checks to see if the date of an entry (e.g. the date the item was created, or maybe the value of the item or entry is the date of last issue), and if the value is a certain amount of days/months back (computed with a conditional) decide whether to trigger a reissue email or not (the check could be for 1 year old, 2 year old, etc. items).

I hope this helps.

Please do post if you would like more help with this.

---

Hi 

Yes I like that option.  I am comparing with  a SPD workflow the does a similar sort of thing. My client is keen on SPD workfows so that is likely to be my direction of travel. Thanks as it always good to have an altnerative.

Daniel