cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
westerdaled
Post Patron
Post Patron

long running flows alternatives say for 1-3 years time

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

1 ACCEPTED SOLUTION

Accepted Solutions
Jaden
Microsoft
Microsoft

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.

View solution in original post

2 REPLIES 2
Jaden
Microsoft
Microsoft

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.


@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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,720)