cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xhermoso
Level: Power Up

REMINDER FLOW

I've to set a reminder flow based on a sharepoint element. I've set a column with a final date and i want to receive an email notificatión when the date set in this column arrives. Thanks for your help

1 REPLY 1
Highlighted
Super User
Super User

Re: REMINDER FLOW

Hi @xhermoso , see the images of the flow below. In this example I've got a SharePoint document library with a NextReview column:

  • In Flow use a recurrence schedule as your trigger and set it to 1 day at whatever time you want.
  • Then add a SharePoint Get items action and select your site and list (if you ar eusing a document library you'll need to type in the same as a custom value).
  • Using a Compose action I've then grabbed today's date and stripped out the hours and minutes leaving just the date.
  • Then add an Apply to each, and for each value add a condition control to check if the NextReview date is equal to the output from the Compose Today action.
  • If it is I've then made sure the date in the email will be in my preferred format by using a Convert Timezone (you might not need to do that).
  • Finally add a Send an Email(V2) with the output from the Convert time zone used as the NextReview date.

You don't need anything in the If no red channel.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

 

0-SPList.png0-SharePoint list1-FlowTrigger-GetItems.png1-Trigger and Get items2-Compose-ApplytoEach-Condition.png2-Compose and Condition3-ConvertTimeZone-SendEmail.png3-Convert TimeZone and Send an Email (V2)4-EmailResult.png4-Email Result

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 190 members 4,679 guests
Please welcome our newest community members: