Answered

Creating a Flow to get a notification 30 days before a date is reached

(0) Share

Report

Posted on by AlexKoCe

Hey,

I'm trying to create a Flow that notifies me 30 days before a date is reached (from an excel Table).
For example i need a notification before a guarantee runs out and need to buy new stuff.

Does someone already got a solution for it or can help me with it, i'm completely new to Flow.

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

AlexKoCe 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @murshed ,

thank you very much 🙂

Was this reply helpful? Yes No
Verified answer

murshed Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AlexKoCe
Thanks for explaining the task. Here is a way to do it:

Create an Excel document with two columns Expiration Data and Reminder Added. The Expiration Date lists a date of expiration.
In Excel select Insert > Table and create a table from these two columns.
Add a sample date in the Excel.
Start with a Schedule trigger to schedule the flow 2-4 times a day. This will check the excel document for update 2-4 times a day.
Use the List Row operation from the Excel connector to get the rows.
Use the conditional connector to operate on each row.
For each row from the table, if the reminder added is not set to TRUE, create an event on the outlook calendar with a reminder option set to on.
Mark the excel with Reminder Added column to TRUE.
To demonstrate this I added few components to a flow. Note that the following flow is incomplete, since I didn't added the check for Reminder Added. You will also need to figure out when to add the calendar event. Also please explore Outlook Tasks connector, which may be a better fit for your application. Let me know if you have any question.

Was this reply helpful? Yes No
AlexKoCe 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @murshed ,

I have to collect all the expiation dates of our Laptops and fill them into an excel sheet. (that's no problem)

In the next step i have to create a Flow that sends me an e-mail 30 days before these dates are reached.
So i just can fill in the new dates and don't have to create reminders for 100+ Laptop manually.

Kind Regards.

Was this reply helpful? Yes No
murshed Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @AlexKoCe
Can you please tell us more about what are trying to build? Simple speaking you can create a recurring calendar event for the reminder and get a reminder from there. You can also any task oriented application to do the same. All of these apps can be connected from Flow as well, using connectors such as Outlook, Google Calendar, Google Tasks and many more. Once you connect to flow you can tie it to subsequent operations.

Best Regards.

Was this reply helpful? Yes No