By moving my old flows from SharePoint Designer 20130/13 I just discovered that I cannot create a reminder 6 months down the road with with Delay until as the maximum is 30 days.
I need a flow to clear a date when it is reached e.g. if WarningExpire is 15/07/21 when we reach that day it will clear the date set a specific column to a status and send an email.
Is it possible to run a flow every day to look into a library where the WarningExpire is not null and if the date of WarningExpire equals to Today() clear the date send an email and update a column to Expired?
How can I get this?
Solved! Go to Solution.
First, you need to get the values in the column ‘WarningExpire’ in the SharePoint library.
Secondly, set a condition to check if each value in the column ‘WarningExpire’ isn’t null and if the date of ‘WarningExpire’ equals to Today().
Ps. Make sure the ‘WarningExpire’ column in SharePoint is ‘date and time’ type not using friendly format, not including time.
Finally, if the condition is met, flow will clear the date, send an email and update a column to Expired.
The whole flow is as below:
The functions which do not appear as dynamic content are below:
empty(items('Apply_to_each')?['WarningExpire'])
utcNow('yyyy-MM-dd')
null
Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I believe I have found the solution on a daily Recurrence by using the Get Items and applying a Filter Query for all those items which contain a date, followed by the Condition step to limit the entries to those items that WarningExpire equals to today via the utcNow expression and finally update the item to Null and send email notification.
Thanks for your help
Warning_x0020_Expire ne null
First, you need to get the values in the column ‘WarningExpire’ in the SharePoint library.
Secondly, set a condition to check if each value in the column ‘WarningExpire’ isn’t null and if the date of ‘WarningExpire’ equals to Today().
Ps. Make sure the ‘WarningExpire’ column in SharePoint is ‘date and time’ type not using friendly format, not including time.
Finally, if the condition is met, flow will clear the date, send an email and update a column to Expired.
The whole flow is as below:
The functions which do not appear as dynamic content are below:
empty(items('Apply_to_each')?['WarningExpire'])
utcNow('yyyy-MM-dd')
null
Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the post, I have followed the detailed step to step guide but I am having a few issues.
Although I have found the correct library in List folder, I don't seem to find the list in library name in the Get file (properties only) step unless I copy and paste it from the previous step which then allows me to find the library in Limit Entries to Folder
In your example the first condition refers to false
Is it correct to presume is Null? And the functions I entered are
Under the Update file properties, I encountered the same problem as the Get files (properties only) the library name is not present; if I try to paste the name from the List folder I get an error
Any thoughts?
Thanks
I believe I have found the solution on a daily Recurrence by using the Get Items and applying a Filter Query for all those items which contain a date, followed by the Condition step to limit the entries to those items that WarningExpire equals to today via the utcNow expression and finally update the item to Null and send email notification.
Thanks for your help
Warning_x0020_Expire ne null
User | Count |
---|---|
89 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
38 | |
24 | |
21 |