Sunday, 27 January 2019

Send Birthday Email from SharePoint online using Flow


Below are steps to configure the flow to send the birthday email from SharePoint List.


1.Configure the Recurrence like in below screen

2.Get items from SharePoint List



3.Use foreach activity on every item to check the condition and send the email


4.Configure Condition Activity like below code
Left Condition

if(equals(items('Apply_to_each')?['DateOfBirth'],null),'',formatDateTime(items('Apply_to_each')?['DateOfBirth'], 'MM/dd'))

is equal to
Right Condition
formatDateTime(utcNow(), 'MM/dd')

4.Send Email if condition is true