Unanswered

Condition returning false between two equal fields

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am creating a flow that compares an email from "get user profile" and an email located in an excel file, but the condition always returns false, even thought the email is the same.

I tried several ways, but it keeps returning false.

I don't seem to be able to add prints here.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Pstork1 69,383 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Add a compose just prior to the Condition action. put the two values there and see what values are actually coming through and being compared. I suspect the one from Excel is coming in formatted as a hyperlink to send email. If that's the case you'll need to strip out the HTML before doing the compare. But looking at the actual values involved should help figure out why they aren't being considered equal.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I did add the compose and the information was the same, but I think you might be right about the hyperlink. Thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Pstork1 I did strip out the html in the excel, but it still doesn't work. Is there anyway I can do this via Power Automate?

Was this reply helpful? Yes No
Pstork1 69,383 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you show me a screenshot of the input section of the two Compose actions from a sample run?

Was this reply helpful? Yes No