Forum Discussion
Getting issue with flow sending birthday email from sharepoint list
I created a list with column Employee name, BirthdayDate and email address. Trying to create flow to send birthday email but getting error
condition
formatDateTime(items('Apply_to_each')?['BirthdayDate'], 'MM/dd/yyyy') ---- is equal to ----
formatDateTime(utcNow(), 'MM/dd/yyyy')
Advanced mode: @equals(formatDateTime(items('Apply_to_each')?['BirthdayDate'], 'MM/dd/yyyy'), formatDateTime(utcNow(), 'MM/dd/yyyy'))
- I would recommend trying to reach out on the official flow community. You will get people way more experienced in the area of Flow paying attention there than you will here!
https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity - Compose a variable that is ticks((items('Apply_to_each')?['BirthdayDate'])) and another for ticks(utcNow()) then create your condition to compare the 2 variables. Ticks function creates a number of the time since date baseline so comparing is accurate and not relying on formats
