cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mtagliaferri
Resolver I
Resolver I

Delay until 180 days alternative

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?

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-yiwenxie-msft
Microsoft
Microsoft

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.

 

1.15-4.PNG

 

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:

1.15-1.PNG

 

The functions which do not appear as dynamic content are below:

empty(items('Apply_to_each')?['WarningExpire'])
utcNow('yyyy-MM-dd')
null

 

1.15-2.PNG

 

1.15-3.PNG

 

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.

View solution in original post

mtagliaferri
Resolver I
Resolver I

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

Untitled.jpg

 

View solution in original post

3 REPLIES 3
v-yiwenxie-msft
Microsoft
Microsoft

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.

 

1.15-4.PNG

 

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:

1.15-1.PNG

 

The functions which do not appear as dynamic content are below:

empty(items('Apply_to_each')?['WarningExpire'])
utcNow('yyyy-MM-dd')
null

 

1.15-2.PNG

 

1.15-3.PNG

 

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.

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

Capture1.jpg

 

In your example the first condition refers to false

Capture2.JPG

 

Is it correct to presume is Null? And the functions I entered are

Capture3.jpg

 

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

Capture4.JPG

 

Any thoughts?

Thanks

mtagliaferri
Resolver I
Resolver I

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

Untitled.jpg

 

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!

Top Solution Authors
Users online (2,349)