Unanswered

Need to comapare multiple conditions in the If loop in Power Automate Desktop

(0) Share

Report

Posted on by nk4

I need to compare the Name and the status of employee are matching or not using IF loop how to compare multiple conditions in the If loop using "AND" and "OR" Operators

Categories:

Power Automate Desktop

I have the same question (0)

All responses (15)

Answers (0)

PetrosF-MSFT on at

Like (0)

Report

Hi @nk4

I hope that helps: https://docs.microsoft.com/en-us/power-automate/ui-flows/desktop/variable-manipulation#logical-operators

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

Like (0)

Report

Hi,

I need to multiple conditions in the If statement.
I have many files of the same pattern, out of it I do not want to delete certain files starting with specific name followed by number ex. 'ABC-1234'.
I tried the following, but it is not working. Please help for the solution.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report

I would approach this completely differently.

set up a temp folder
get files in folder ABC-1234*
move files to temp
get files in folder RES-1564*
move files to temp
get files in folder FED-1234*
move files to temp
get all files in folder
delete files
get all files in temp
move files back to folder

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

Like (0)

Report

Thanks for your reply and it works.
I posted this to know whether multiple conditions are possible in a single if statement for my scenario.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Here are some ideas you can try, but the solution I know will work is below the dotted line.

Here: https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-manipulation

It says you can do this:

I personally don't think this would work, because the operator is built into IF, and it doesn't give an And/Or option.

On the other hand, you can do nested If's to accomplish AND functions:
If name is
If status is
Do something
EndIF
EndIF
So in this example, it would only "Do something" If both statements were true.
--------------------------------------------------------------------------------------------------
Solution that will definitely work:

You can use Switch & Case to handle all possibilities of AND/OR Functions, but this gets complicated. You have to set each If Statement to True (1) or False (0), so that looks like this:
If Name is True
Set Variable %NameIF% to (1)
Else
Set Variable %NameIF% to (0)
EndIF
IF Status is True
Set Variable %StatusIF% to (1)
Else
Set Variable %StatusIF% to (0)
EndIF
Set Variable %Result% to 'Name%NameIF%,Status%StatusIF%'
#I used text other than just numbers in %Result% so it didn't mistake it for a number and turn "01" into "1".

Now that you have the result variable, which is 1 of 4 options, you can use Switch Case to "do something" based on your result:
Switch %Result%
Case Name0,Status0
Do something for 0,0
Case Name0,Status1
Do something for 0,1
Case Name1,Status0
Do something for 1,0
Case Name1,Status1
Do something for 1,1
Best of luck!

Was this reply helpful? Yes No
PAG 154 on at

Like (0)

Report

Here is another approach with OR conditions, using a list and looping items:
https://power.automate.gallery/LIhE73Pp1sy4

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

Like (0)

Report

Hello @Anonymous

You can use multiple conditions in IF statement. 🙂

You would better to check the solution posted by @Anonymous in the thread below:
Solved: If condition logic - Power Platform Community (microsoft.com)

Also yet another thread discussing the same issue you should read through:
How to include the logical AND/OR operators in con... - Power Platform Community (microsoft.com)

Thank you.

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on at

Like (1)

Report

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on at

Like (0)

Report

And/Or is working just fine
Try This example

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

Like (0)

Report

Hi,
Thank you for your response!
Actually the match starts with 'ABC-1234' and after that it contains some text (ABC-1234 ttttccvvfilename.pdf). So, I cannot give Match = ABC-1234, I have to give it like Match does not start with 'ABC-1234'. Any idea how to implement?

Was this reply helpful? Yes No