Send Email based on Choice Column

Like (0) Share

Report

Posted on 5 Aug 2020 13:32:21 by ClaireAllen

762

Hello Community,

I am building a workflow to send an email based on conditions of a SharePoint Choice Column, but for some reason the expression result comes back as false, and I can't figure out why.

It's based on an item in a SP List being created / modified.

The first condition I want is when the Employee Confirmation is equal to true (yes), the flow runs no problems. BUT when a add another condition i.e (SP Choice Column) Country is equal to UK & Ireland the Yes options to send an email returns the expression as false, even though this is what I have selected in my SP List.

I would like to be able to repeat the conditions for each different country options that I have,

I've tried adding a switch, that did not work.

Choice Column.JPG

Any suggestions / help to send an email based on a choice column to send an email for each separate choice within the Column.

Thank you & regards

Claire

I have the same question (0)

All responses (9)

Answers (1)

PrasadAthalye on 05 Aug 2020 at 17:59:49

Like (0)

Report

Re: Send Email based on Choice Column

Can you add Employee Confirmation column in the view and attach screen shot? Is yes no column?

Was this reply helpful? Yes No
ClaireAllen 762 on 06 Aug 2020 at 08:08:16

Like (0)

Report

Re: Send Email based on Choice Column

Hello @PrasadAthalye

As requested, please see the screen shot of the Employee Confirmation Column,

I'm using a Yes / No column, defaulted to No, I think the issue might be as the flow is running on created and modified, would I be better adding a Do until into the flow? so on created it's No which is false.

Any suggestions would be gratefully received,

Kind regards

Claire

Was this reply helpful? Yes No
PrasadAthalye on 06 Aug 2020 at 13:04:11

Like (0)

Report

Re: Send Email based on Choice Column

I see that in your comparison, you are using some sort of expression to check true or false...
Instead can you try just simple text true like below...

Was this reply helpful? Yes No
ClaireAllen 762 on 06 Aug 2020 at 13:14:35

Like (0)

Report

Re: Send Email based on Choice Column

Hello @PrasadAthalye ,

The expression I am using is just a true expression,

I will remove it and type true and see how I get on.

Thank you
Claire

Was this reply helpful? Yes No
ClaireAllen 762 on 06 Aug 2020 at 13:28:56

Like (0)

Report

Re: Send Email based on Choice Column

Hello @PrasadAthalye ,

I updated the expression and just put in true, the workflow run, but it did not send the email as it showed the result as being false even the the SP List Column is now a Yes so it should be true????

I've tried adding Do until, but that did not work, the flow ran and skipped the step

Is there anything else I can try?

Kind regards

Claire

Was this reply helpful? Yes No
PrasadAthalye on 06 Aug 2020 at 13:46:15

Like (0)

Report
Re: Send Email based on Choice Column

Can you split the 2 conditions in 2 If condition blocks?

Remove Country condition from the current block.
Put the country condition inside If yes section.
then within Country Condition, send email.
Now this way, we will know exactly which condition is not matching. I suspect that there might be trailing spaces somewhere within the word 'UK & Ireland'. Other option is to change 2nd condition logical operator to Contains and see if that makes difference...

Was this reply helpful? Yes No
ClaireAllen 762 on 06 Aug 2020 at 14:34:44

Like (0)

Report

Re: Send Email based on Choice Column

Hello @PrasadAthalye

I have done as you suggested and split the 2 conditions
condition 1 - if employee confirmation is equal to true is working correctly
condition 2 - if country code is equal to ***** is not working, I have tried UK & Ireland, and another one Denmark and this is the message, it's showing it skipped as not being equal to, I have copied the text from the choice options in the SP List to make sure I got the correct text, no spaces etc.

I have also tried contains and receive the same message.

Regards

Claire

Was this reply helpful? Yes No
Verified answer

PrasadAthalye on 06 Aug 2020 at 16:10:49

Like (2)

Report

Re: Send Email based on Choice Column

Ok. that helped to isolate the issue.

Instead of using Country, can you find and use 'Country Value'. It should be there in the list of fields. For example, I have RequestStatus as Choice field and below is how it shows me...

Was this reply helpful? Yes No
ClaireAllen 762 on 07 Aug 2020 at 08:47:41

Like (0)

Report

Re: Send Email based on Choice Column

Hello @PrasadAthalye

Thank you do much, adding the Country Value has worked and the flow triggered and sent the email

Thanks again for your help,

Kind regards

Claire

Was this reply helpful? Yes No