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

6
  • 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. Nov 28, 2018 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, 2018 at 10:09
  • 1
    See exapmle given here and here. Nov 28, 2018 at 10:24
  • Welcome. What is the final formula you used? Nov 28, 2018 at 12:09
  • 1
    @equals(formatDateTime(items('Apply_to_each')?['BirthDay'], 'YYYY-MM-dd'), formatDateTime(utcNow(), 'YYYY-MM-dd'))
    – user23
    Nov 28, 2018 at 12:20

1 Answer 1

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 and acknowledge you have read our privacy policy.

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