Unanswered

How to Compare strings in IF condition in power automate desktop

(0) Share

Report

Posted on by Sivapriya

I am trying to compare the variable containing string value with a static text using the expression mentioned in the screenshot but it is throwing error. Could anyone help on how to compare strings in if condition?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Sivapriya - Hope you are doing well.
We can achieve those two different ways. Please refer the below reference and code:
Method1 If condition:
Method2 If condition:

Code:
SET CompanyData TO $'''AMA'''
# #Method1
IF Contains(CompanyData, $'''AMA''', False) THEN
Display.ShowMessageDialog.ShowMessage Title: $'''tes''' Message: $'''true''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
END
# #Method2
IF (Contains(CompanyData, $'''AMA''', False)) = $'''TRUE''' THEN
Display.ShowMessageDialog.ShowMessage Title: $'''tes''' Message: $'''true''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
END

Thanks,
Deenu
------------------------------------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up. Thank you.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Sivapriya,
Any updates? Did you tried the above suggested workaround?

Thanks,
Deenu
------------------------------------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up. Thank you.

Was this reply helpful? Yes No
Sivapriya 9 on at

Like (0)

Report
Copy link

Link copied!

First of all, I dont see first operand, second operand and operator options in my IF condition. i tried the code you had mentioned but that also din work. I am getting error "Expression must contain a boolean value"

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Sivapriya
Hope you are doing well!!

If I grasp your concerns accurately, it seems that you created your flow by activating "Power Fx", which is why the operand isn't displaying in the if condition.

Thus, kindly recreate a new flow by deactivating the Power Fx option and then copy and paste the above mentioned code. This should resolve the issue.

Best regards,
Deenuji Loganathan
Follow me on LinkedIn - Deenuji Loganathan

If I've successfully resolved your queries, please consider accepting this as the solution and giving it a thumbs up. Your feedback is greatly appreciated!

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If you want to continue using Power Fx in your flow, the correct way to do a condition like that is as follows:

You need to use the 'in' operator to check if a substring is present in a string. If the substring or the string is a literal value and not a variable, you need to encapsulate it in double quotes.

Please note, that 'in' is case insensitive (it will ignore the case of the strings). If you want a case-sensitive check, use 'exactin' instead.

See the following article for reference on the logical operators available in Power Fx: https://learn.microsoft.com/en-us/power-platform/power-fx/operators

Was this reply helpful? Yes No