Delay until 180 days alternative

[mtagliaferri]

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?

[v-yiwenxie-msft · Accepted solution]

Hi @mtagliaferri 

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.

[mtagliaferri]

Hi @v-yiwenxie-msft 

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

[mtagliaferri · Accepted solution]

Hi @v-yiwenxie-msft 

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