Send birthday reminder flow

[Bodemi]

I'm trying to send a birthday reminder to my team 1 day before someone's birthday except for the birthday celebrant. I don't want him/her to be reminded of his/her own birthday. Names, birthdays and email addresses are stored in a SharePoint list and the flow is working fine.

@AlanPs1 

[ChristianAbata]

hi @ what you need to do is get your date colum item and the use the expression adddays see

addays('YOUR DATE COLUM OUTPUT HERE', -1 'yyyy-MM-dd')

[Bodemi]

Hi ChristianAbata, thank you for your help. I am new to flow. How do I get my date colum item and the use the expression adddays? 

@ChristianAbata 

[ChristianAbata]

@Bodemi  see my friend.

[v-bacao-msft]

Hi @Bodemi ,

Please try the following configuration:

Best Regards,

[rsaikrishna · Accepted solution]

@Bodemi 

Here is the sample flow:

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[Bodemi]

@rsaikrishna thanks for your contribution, the flow is working as desired. 

[sajarac]

Hi @rsaikrishna , would you mind to see my post and advice? I have a similar issue

https://powerusers.microsoft.com/t5/General-Power-Automate/Sending-an-Email-Reminder/m-p/776574#M625...

[Paciu06]

Hello @rsaikrishna,

Related to your sample flow. My biggest problem for now is to manage how to send email to the non birthday recipient list. Could you please be so kind and decribe steps related to this a little more specific? 

Regards,
PK.