Skip to main content

Notifications

Power Automate - Using Connectors
Answered

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

(0) ShareShare
ReportReport
Posted on by 6

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.

  • AlexKoCe Profile Picture
    AlexKoCe 6 on at
    Re: Creating a Flow to get a notification 30 days before a date is reached

    Hi @murshed ,

     

    thank you very much 🙂

  • Verified answer
    murshed Profile Picture
    murshed on at
    Re: Creating a Flow to get a notification 30 days before a date is reached

    Hi @AlexKoCe

    Thanks for explaining the task. Here is a way to do it:

     

    1. Create an Excel document with two columns Expiration Data and Reminder Added. The Expiration Date lists a date of expiration.
    2. In Excel select Insert > Table and create a table from these two columns.
    3. Add a sample date in the Excel.
    4. 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.
    5. Use the List Row operation from the Excel connector to get the rows.
    6. Use the conditional connector to operate on each row.
    7. 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.
    8. 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.

     

    murshed_0-1604685978724.png

     

  • AlexKoCe Profile Picture
    AlexKoCe 6 on at
    Re: Creating a Flow to get a notification 30 days before a date is reached

    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.

  • murshed Profile Picture
    murshed on at
    Re: Creating a Flow to get a notification 30 days before a date is reached

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics