Getting issue with flow sending birthday email from sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-310273%22%20slang%3D%22en-US%22%3EGetting%20issue%20with%20flow%20sending%20birthday%20email%20from%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310273%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20list%20with%20column%20Employee%20name%2C%20BirthdayDate%20and%20email%20address.%20Trying%20to%20create%20flow%20to%20send%20birthday%20email%20but%20getting%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Econdition%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EformatDateTime(item%3C%2FSPAN%3E%3CSPAN%3Es%3C%2FSPAN%3E%3CSPAN%3E(%3C%2FSPAN%3E%3CSPAN%3E'Apply_to_each'%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3CSPAN%3E%3F%5B%3C%2FSPAN%3E%3CSPAN%3E'BirthdayDate'%3C%2FSPAN%3E%3CSPAN%3E%5D%2C%20%3C%2FSPAN%3E%3CSPAN%3E'MM%2Fdd%2Fyyyy'%3C%2FSPAN%3E%3CSPAN%3E%3CSPAN%3E)%26nbsp%3B%20%26nbsp%3B----%20is%20equal%20to%20----%3C%2FSPAN%3E%3C%2FSPAN%3E%26nbsp%3B%26nbsp%3B%3CDIV%3E%3CDIV%3E%3CSPAN%3EformatDateTime(utcNow()%3C%2FSPAN%3E%3CSPAN%3E%2C%20%3C%2FSPAN%3E%3CSPAN%3E'MM%2Fdd%2Fyyyy'%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EAdvanced%20mode%3A%26nbsp%3B%40equals(formatDateTime(items('Apply_to_each')%3F%5B'BirthdayDate'%5D%2C%20'MM%2Fdd%2Fyyyy')%2C%20formatDateTime(utcNow()%2C%20'MM%2Fdd%2Fyyyy'))%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-310273%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFLOWS%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-310415%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20issue%20with%20flow%20sending%20birthday%20email%20from%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310415%22%20slang%3D%22en-US%22%3ECompose%20a%20variable%20that%20is%20ticks((items('Apply_to_each')%3F%5B'BirthdayDate'%5D))%20and%20another%20for%20ticks(utcNow())%20then%20create%20your%20condition%20to%20compare%20the%202%20variables.%20Ticks%20function%20creates%20a%20number%20of%20the%20time%20since%20date%20baseline%20so%20comparing%20is%20accurate%20and%20not%20relying%20on%20formats%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-310373%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20issue%20with%20flow%20sending%20birthday%20email%20from%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310373%22%20slang%3D%22en-US%22%3EI%20would%20recommend%20trying%20to%20reach%20out%20on%20the%20official%20flow%20community.%20You%20will%20get%20people%20way%20more%20experienced%20in%20the%20area%20of%20Flow%20paying%20attention%20there%20than%20you%20will%20here!%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Flow-Community%2Fct-p%2FFlowCommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FMicrosoft-Flow-Community%2Fct-p%2FFlowCommunity%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Senior Member

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'))
 
 
2 Replies
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