cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
eenochs
Level: Powered On

Microsoft Flow Date Help

I have a list that includes dates.  I'm looking to create a flow that checks this date field and 90 days from that date do an action.  

 

I have the flow set up to run every day with a Get Items Option to pull data from the SharePoint List. 

 

I have an Apply to each that is using the values from the Get Items with a Condition.  I'm having trouble writing out the expression for it to check a certain column (Termination Date) and 90 days from that date Send an email.  Any assistance would be greatly appreciated.  

6 REPLIES 6
Super User
Super User

Re: Microsoft Flow Date Help

@eenochs :

 

The easiest way to get this accomplished would be use the new "send an email reminder" Flow.  You'll see the "Create an Email Reminder" option from the Flow drop-down menu on any list with a modern interface and a date column.  It will ask how far in advance do you want the email to be sent.  If you use this, it will create a Flow that sends an email on a schedule.

 

You can edit this Flow to take any action you desire and remove the send email action.

 

If that won't work for you, please post here and I'll provide an example of a simple Flow that will meet your needs.

Reminder.jpg

 

If this addresses your issue, please mark your post as Solved.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
v-zhos-msft
Level 10

Re: Microsoft Flow Date Help

Hi @eenochs @

According to your description, what confused you is the expression in the Condition action.

I have made a test on my side, please take a try with the following workaround:

The expression is: addDays(utcNow(),-90,'yyyy-MM-dd')

5.png

Best Regards,

Zhongys

eenochs
Level: Powered On

Re: Microsoft Flow Date Help

I added in the time entry but having a issue with the flow accepting it as a true statement, wasn't sure if my statement was correct.  

 

tsib-flow1.png

v-zhos-msft
Level 10

Re: Microsoft Flow Date Help

Hi @eenochs ,

I think your statement is correct.

Please make sure the format of the 'Termination Date' in your list is 'yyyy-MM-dd', or set the expression format as the 'Termination Date'.

Best Regards,

Zhongys

eenochs
Level: Powered On

Re: Microsoft Flow Date Help

Still having an issue with the statement working.  I reviewed one of the flow runs and the termination date is yyyy-MM-dd which is what I have in my expression.  The statement is still false.  For example in the list, I have the termination date set to 5/28/2019.  So the statement is if the termination date is Today plus 90 days which would be 5/28/2019 it should be true.  That isn't happening and not sure where the issue could be.  

eenochs
Level: Powered On

Re: Microsoft Flow Date Help

Do you think the timezone could be the reason I'm dealing with?  Based on my statement should I account for UTC time zone and maybe convert the timezone to eastern prior to my expression?

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,103)