Answered

Issue with Conditions

(0) Share

Report

Posted on by mrichards1371

I'm having users submit a Microsoft Form to initiate a Power Automate flow. I then take the Responders E-mail address from the Form and plug it into a "Get AD Info of Users".

I am then using the e-mail address from Get AD Info of User and putting a condition on it.

If the users e-mail is equal to *a specific email address*, then do this.

If the users e-mail is not equal to *a specific email address, then do this.

This is the condition that is returning FALSE even though the email address of the requestor DOES EQUAL THIS. Any idea what I am doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Expiscornovus 33,828 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @mrichards1371,

Can you remove the quotes around the email value and try again?

Strings are case sensitive, make sure you use the right casing as well.

Was this reply helpful? Yes No
mrichards1371 57 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus I removed the single quotes but I ran into another problem. When I submit a form using my email address (in this example, my email is myemailtest.com), both of these conditions are returning true and I am receiving both emails. How is this possible?

Was this reply helpful? Yes No
Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @mrichards1371,

Yes, I would have expected that outcome because of your setup. You are use the myemail check in both conditions, so both conditions will return true.

In condition one the mail needs to be myemail or othermail which is true. In condition 2 the mail needs to be myemail or othermail which is also true.

Can you only use one row per condition action?

Condition

Mail is equal to myemail

Condition 2

Mail is equal to otheremail

Was this reply helpful? Yes No
Micky 365 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello,

Try using toLower() expression for both variables that is being used for the condition, this is to make sure that the condition parameters are converted to lower case and avoid case mismatch.

Regards,

MMPoweR

Was this reply helpful? Yes No
mrichards1371 57 on at

Like (0)

Report
Copy link

Link copied!

It's pretty crazy that I would have to create a condition for each individual e-mail.

All I want to do is: If the person submitting the form has an email address DOES equal Email1 or Email2, then do this. If the persons email does DOES NOT equal Email1 or Email2, then do this.

Sounds so simple but power automate is driving me nuts trying to figure this out. The flow is very complex as it is so I feel like making a separate condition for each email will bog it down even more.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think your last reply clarified your requirements.

With the latest logic you shared you only need one condition and place the actions you want to execute if it does not equal to either of the values in the If No section.

Was this reply helpful? Yes No