Home >Tips >Power Automate >Event reminder kalmstrom.com site map icon Site map  

Event Reminder Flow

A SharePoint Flows tutorial by Peter Kalmström

Flow iconSometimes you want to get a reminder when a contract has to be re-negotiated, an important event needs to be remembered or a subscription needs to be renewed. All such reminders can be automated through Microsoft Flow.

SharePoint calendar lists have an alert feature that sends an e-mail reminder, but it gives no link to the event. In this tutorial, Peter Kalmström, CEO and Systems Designer of kalmstrom.com Business Solutions, shows how a flow can send reminders with a event links.

In Power Automate, times are automatically converted to Coordinated Universal Time (UTC). Therefore, Peter needs to set the local time in two places in the flow, for the calendar and for Outlook. This is often the same time zone, but it is not always so.

Reminder message


Steps to create a Reminder flow:

  1. Start with a 'Scheduled from blank' flow.
  2. Set the frequency and time for when the flow should run.
  3. Set the time zone in the trigger
  4. Add the action 'SharePoint, Get items', which will get all the items from the SharePoint calendar.
  5. Add the action 'Apply to each' which will run through each item in the calendar list.
  6. Insert the output 'value'.
  7. Add a condition to discern the items that have the appropriate date.
  8. In the first condition field, add the expression substring(item()?['EventDate'], 0, 10)

    Here ‘item()’ refers to the current item of the list and ‘[‘EventDate’]’ is the column that should be checked. The condition will be true for “Today’s Date”.
  9. Keep the 'is equal to' and add a new expression in the second condition field: utcnow('yyyy-MM-dd').
  10. To send an e-mail when the condition is true, add the action 'Send an email (V2)'.
  11. In the 'To' field, enter the user(s) who will get a reminder e-mail when the condition is true.
  12. For the e-mail subject, type some general text and add the dynamic content 'Title'.
  13. Insert the e-mail body text. You can make it dynamic by using the available parameters of the flow.
  14. Save and test the flow.





back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved