1

I have created a flow for sending mails using below condition.

BirthDay(list column) values is equal to convertTimeZone(utcnow(), 'UTC', 'W. Europe Standard Time', 'dd/MM')

enter image description here

while running the flow i'm getting below one.

enter image description here

Mailing format is below one.

enter image description here

please help.

Thanks in advance

  • 1
    I think its because, "Expression result" in your 1st image is "false". So it will not execute "If yes" block. instead it will execute "If no" block. – Ganesh Sanap Nov 28 '18 at 9:26
  • yes , in "If no" block it is working fine but it need to satisfy the condition. If you have any knowledge on date comparisons in flows please help. condition for send mail is : (If Birthday column value = today date then we need to send mail) Currently i'm using this : BirthDay is equal to convertTimeZone(utcnow(), 'UTC', 'W. Europe Standard Time', 'dd/MM') – user23 Nov 28 '18 at 10:09
  • 1
    See exapmle given here and here. – Ganesh Sanap Nov 28 '18 at 10:24
  • Welcome. What is the final formula you used? – Ganesh Sanap Nov 28 '18 at 12:09
  • 1
    @equals(formatDateTime(items('Apply_to_each')?['BirthDay'], 'YYYY-MM-dd'), formatDateTime(utcNow(), 'YYYY-MM-dd')) – user23 Nov 28 '18 at 12:20
0

I think you are getting this exception because, "Expression result" in your 1st image is "false". So it will not execute "If yes" block. instead it will execute "If no" block.

In Order to make it execute your "If yes" block and send email to respective user, you need to make the condition from your 1st image to true.

Please follow below links to make your condition correct:

  1. Compare dates - Sharepoint Calendar.

  2. Is there an expression in Flow like =TODAY().

Update(as you corrected formula):

Use below formula for your condtion to check if today is the BirthDay of user.

@equals(formatDateTime(items('Apply_to_each')?['BirthDay'], 'YYYY-MM-dd'), formatDateTime(utcNow(), 'YYYY-MM-dd'))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.