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.
Be interested to hear if anyone has implemented such a requirement
Daniel
Solved! Go to 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.
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