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

Setting up reminder in a flow

Dear all

 

I'm looking for a way to setting up reminder in a flow. I'm extracting information from pdf document with AI Builder in Excel table. One of information is deadline response. I want to set up a reminder by teams or email notification when deadline is coming. For example Deadline is December 30, 2021, and i want to get notification on december 26 (four days before). How can i do it?

 

Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions

Here's the basic flow

image.png

1) make sure the date coming from Excel is set to format as ISO 8601.

2) Compare it using the following formula 

formatdatetime(adddays(utcnow(),4),'yyyy-MM-dd')


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

View solution in original post

12 REPLIES 12
Pstork1
Dual Super User
Dual Super User

If you are storing the due date in the Excel table then you can do a reminder by creating a recurrence triggered flow that runs daily at a particular time.  Have that flow get all the rows in the table and send emails for any row where today is more than 4 days and less than 5 days from the due date.



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

Thank you.

Is there possible to show me any example of flow?

Here's the basic flow

image.png

1) make sure the date coming from Excel is set to format as ISO 8601.

2) Compare it using the following formula 

formatdatetime(adddays(utcnow(),4),'yyyy-MM-dd')


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

Thank you. It's working for me.

Hi,

It's not working at all. Have a look on below pictures. I think, i'm having troubles with the date. How can i fix this?

 

Thank you

 

Lagloire_0-1637959566981.pngLagloire_1-1637959646495.png

 

 

 

 

A couple issues I see in your List Rows query.

1) The date column you are using should have no spaces in the name

2) you need some kind of comparison operator like 'eq' for equals

3) The date you are comparing in your filter needs to be inside single quotes. '<date to compare>'.  Take a closer look at my sample.



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

Hi

Thak you for this. It works. Now The last problem is, i'm not getting any message in teams as expected. Viewing my flow, am'i doing anything wrong?

Lagloire_0-1638123647331.pngLagloire_1-1638123672909.png

 

 

Is the flow triggering at all?  If it is what does a regular run result look like?



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

Dear,

 

I think, i'm not getting any message, because of the filter function, where it was using "eq" instead of "less than". This is because i'm looking for duedate less than date in my colunm and then get reminder. 

Can you tell me how to write "less than" in the function ?

Condition in red below is suposed to make the filter, but it's not working. Do you know why?

 

Lagloire_0-1638141540622.png

 

Less than is available in the dropdown along with equals if the field is a date time formatted field.  If its not showing up then the field in the left hand side is being read as a string not a date.



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

Hi, It's showing up "less than". My question is the function i wrote in the right field is that correct? Because it's not working at all. It's reading and reminder message on all colunm instead of some which fill the condition.

I think your problem is that you just typed the formula into the right hand side instead of using the expressions tab to enter the formula.  If entered correctly you'll see an object, not the text of the formula



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

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.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,691)