cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mtagliaferri
Helper III
Helper III

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
Helper III
Helper III

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.

View solution in original post

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
Helper III
Helper III

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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (68,343)