Power Automate Multiple Conditions [With 19 useful examples]

In this Power Automate Tutorial, we will discuss how to use multiple conditions on a flow in Power Automate. Apart from this, we will discuss below topics such as:

  • Power Automate multiple conditions
  • Power Automate multiple trigger conditions
  • Power Automate multiple if conditions
  • Power Automate OData filter multiple conditions
  • Filter array multiple conditions power automate
  • Microsoft flow condition if yes continue
  • power automate switch case multiple values
  • power automate multiple conditions and or
  • power automate multiple condition person field
  • Power Automate desktop multiple conditions
  • Power Automate subject filter multiple conditions
  • power automate condition multiple values
  • power automate nested conditions limit
  • power automate condition contains multiple values
  • power automate multiple conditions email recipients
  • power automate multiple condition HTML table
  • power automate multiple condition parallel branch
  • power automate multiple condition person field is empty
  • Power Automate multiple conditions email attachments

In our previous topic, we discussed how to use a condition in Power Automate. But now in this topic, we will discuss how to use multiple conditions in Power Automate.

Power Automate multiple conditions

In a flow, we can insert conditions in 2 ways. One is by inserting a ‘condition control’ action and another is by using an expression in a ‘compose’ action. Before creating a flow make sure to log in the Power Automate with your Microsoft 365 user ID or Office tenant address.

Let us create a simple flow where we will use multiple conditions within a ‘condition control’ action. For example, we are going to compare 2 dynamic numbers using multiple conditions. If the first number is greater than or equal to the second number then the conditions got satisfied; otherwise, it will show the text that the condition did not satisfy.

On Power Automate, click on + Create > Instant Cloud Flow > select the trigger ‘Manually trigger a flow> Create. Give a name to the flow.

Power Automate Multiple conditions
Power Automate Multiple conditions

It will start the flow. Next, we will add 2 number inputs by clicking on +Add an input (inside the trigger) > Number.

Multiple conditions on Power Automate
Multiple conditions on Power Automate

Under this trigger, we will add a ‘condition control’ action that will check the multiple conditions that we will apply. Here, we will insert 2 conditions, these are:

  • The first number is equal to the second number ‘or’
  • The first number is greater than the second number

To add these conditions, under the trigger click on + New step > Search and select ‘condition‘ control action. Select the value from the dynamic content. You can change the operator to ‘And‘, ‘or‘. To add more conditions click on + Add.

Power Automate using multiple conditions
Power Automate using multiple conditions

If the condition satisfies then it will go to the ‘If yes’ section; otherwise, it will move to the ‘If no’ section. Inside the ‘If yes’ section, click on +Add an action > Compose. Add the below expression or you can insert the true value.

Conditions satisfied. 
@{triggerBody()['number']} is greater or equal to @{triggerBody()['number_1']}

similarly, we will add the false value inside the ‘If no‘ section.

Conditions did not satisfy. 
@{triggerBody()['number']} is neither greater nor equal to @{triggerBody()['number_1']}
Create a flow using multiple conditions in Power Automate
Create a flow using multiple conditions in Power Automate

Now, the flow is ready to run. Click on save > test > Manually > Give two numbers > Runflow. For example, we will give two numbers such as 20,30.

We can see it will execute the false value according to conditions:

How to use multiple conditions in Power Automate
How to use multiple conditions in Power Automate

Similarly, we can add multiple conditions within an expression via composing. Remove the if condition, under the trigger click on + New step > search and select ‘Compose’ > expression > Insert the below expression.

if(or(equals(triggerBody()['number'],triggerBody()['number_1']),greater(triggerBody()['number'],triggerBody()['number_1'])),'Condition satisfied','Condition did not satisfy')
Using multiple conditions within a flow
Using multiple conditions within a flow

Now, save the flow and test it. We can see the flow will run successfully. This is how to add multiple conditions within a flow.

Read Power Automate Parallel Branch with Examples

Power Automate multiple trigger conditions

A trigger condition specifies one or more expressions that must be true for the trigger to fire. If the condition executes true then it will trigger the flow to run; otherwise, it will ignore the trigger’s event.

The trigger condition is mostly used to control the infinite loop. For example, there is a flow that will trigger when an item is created or modified. In this case, the flow will update the item each time, but this is not the actual thing that we want. To avoid such a thing, we need to add trigger conditions.

There is a specific location to add the trigger conditions to the flow. On a trigger, go to ellipses (…) > settings.

Power Automate trigger conditions
Power Automate trigger conditions

Then you can find the place, where it allows you to insert the conditions.

Power Automate Multiple trigger conditions
Power Automate Multiple trigger conditions

To work with the trigger conditions, we have created a SharePoint list having columns such as:

Columns Name Type
Technology choice
Topic name A single line of text
Employee Person or Group
Start Date Date and Time
End Date Date and Time
Status Choice
Power Automate using Multiple trigger conditions
Power Automate using Multiple trigger conditions

Now, we will create a flow that will trigger when an item is created or modified, as per the condition the flow will trigger only when the technology is equal to SharePoint, and the status is equal to ‘Not started’. Then it will send an email notification to that employee to complete the task.

On Power Automate, go to + Create > Automated Cloud Flow > select the trigger ‘When an item is created or modified> create. Set the SharePoint site address and the list name.

Using multiple trigger conditions on Power Automate
Using multiple trigger conditions on Power Automate

To add the trigger conditions, click on the ellipses (…) > Settings > trigger conditions. Insert the below expressions:

@equals(triggerBody()?['Status']?['Value'], 'Not started')
@contains(triggerBody()?['Technology']?['Value'], 'SharePoint')
trigger conditions in power automate
Trigger conditions in power automate

Also, we can merge these conditions using ‘or’ & ‘and’ operators. If we use the ‘or’ operator, then the flow will trigger when one of the conditions is true. But, in the case of the ‘and’ operator, the flow will trigger when both the conditions are true.

Let’s merge these conditions using ‘and’, then the expression will look like the below:

@and(contains(triggerBody()?['Technology']?['Value'], 'SharePoint'), equals(triggerBody()?['Status']?['Value'], 'Not started'))
Microsoft Power Automate Trigger condition
Microsoft Power Automate Trigger condition

Then click on ‘Done‘. Next, add an action that will send an email notification to that employee. Click on + New step > search and select the action ‘Send an email‘.

Microsoft Power Automate Flow Multiple Trigger Conditions
Microsoft Power Automate Flow Multiple Trigger Conditions

Now save the flow. Click on the test > manually. Let’s modify an item in that SharePoint list.

Power Automate Multiple Trigger Conditions in a flow
Power Automate Multiple Trigger Conditions in a flow

As per our conditions, the flow will trigger when a new item is created or modified and when the conditions are satisfied. So it will send an email notification to that employee i.e. User3.

Multiple Trigger Conditions in a Power Automate flow
Multiple Trigger Conditions in a Power Automate flow

This is how to work with Power Automate multiple trigger conditions.

Read Power Automate email body formatting

Power Automate multiple if conditions

In this example, we will see how to use multiple if conditions within a flow. For example, we have a Sharepoint list named ‘Office expenses’ having columns such as:

Columns Types
Expenses Choice(Laptop, Desktop, Tablet, Paper, Keyboard, Mouse)
Units Number
Apply Date Date and Time
Delivery Status Single Line of Text

Now we will create a flow that will trigger when an employee inserts data in the ‘Office expenses’ list. Then it will automatically update the delivery status according to expenses and notify the employee about the delivery status via outlook.

To create the automated flow, the following steps are:

  • On Power Automate, go to My flows > +New flow > Automated Cloud Flow.
Multiple if conditions in Power Automate
Multiple if conditions in Power Automate
  • Select the trigger ‘When an item is created’ > Create. Provide the SharePoint site address and the list name to fetch the data. Now the flow is started.
Power Automate multiple if conditions
Power Automate multiple if conditions
  • Under the trigger, add an action to get the user profile. Click on +New step > Get user profile. Set the user as ‘Created by email’.
  • Next, add a compose action to insert the below expression that will update the delivery status according to the expenses.
if(equals(triggerOutputs()?['body/Expenses/Value'],'Laptop'),'With in 15 days',if(equals(triggerOutputs()?['body/Expenses/Value'],'Desktop'),'With in 20-25 days',if(equals(triggerOutputs()?['body/Expenses/Value'],'Tablet'),'With in 7 days','by Next 1-2 working days')))
Power Automate using multiple if conditions
Power Automate using multiple if conditions
  • Next, add an action to send an email notification to the employee who created that item. Click on +New step > Send an email. Set the properties such as:
    • To- select ‘mail’ from the dynamic content.
    • Subject- Give a subject to the email.
    • Body- Specify the body of the email with the output.
  • Finally, we will add another action that will update the delver status in the Sharepoint list. Click on +New step > Update Item. Provide the SharePoint site address, list name, and ID, and set the compose’s output in the delivery status.
Multiple IF Statements in Microsoft Flow
Multiple IF Statements in Microsoft Flow

Now the flow is ready. To test the flow, click on Save > Test > Manually > Runflow. Insert data inside the list and we can see it will automatically update the delivery status.

How to use multiple if conditions in Power Automate
How to use multiple if conditions in Power Automate

Also, we can see it will notify the applicant via outlook:

Power Automate how to use multiple if expressions
Power Automate how to use multiple if expressions

Similarly, if we insert the expenses as ‘Keyboard’ then it will update the deliver status as ‘Next 1-2 working days.’ This is how to work with multiple if statements in Power Automate.

Read Power Automate Do until

Power Automate filter array multiple conditions

In this section, we will see how to apply multiple conditions within the ‘filter array’ action in Power Automate. For example, we have a SharePoint list based on ‘Products’ having some sample data such as:

Power Automate filter multiple conditions
Power Automate filter multiple conditions

Now we will create a flow that will filter the data for those having title as ‘Desktop’ and city as ‘California’. To create the flow, the following steps are:

  • On Power Automate, create an instant cloud flow that triggers the flow manually. (We have mentioned in the upper example how to create an instant cloud flow).
  • Next, add an action that will get all the items from the specified Sharepoint list. Under the trigger, click on +New step > Search and select the action ‘Get items‘. Provide the SharePoint site address and the list name.
filter array multiple conditions on Power Automate
Filter array multiple conditions on Power Automate
  • Next, add a ‘Filter array’ action that will filter the data according to the condition i.e. only filter the item those having title ‘Desktop’. Click on + New step > Select the ‘Filter array’ action. Set the value as:
    • From– Value
    • Set the conditional value as Title (from dynamic content) is equal to Desktop
  • Similarly, add another ‘Filter array’ action that will again filter and extract the data from those having the city ‘California’.

Note- As a filter array has the fields only a single condition, we can not insert multiple conditions in a single filter array action. So for multiple conditions, we need to add multiple filter array actions.

Multiple Conditions in Filter Array Power Automate
Multiple Conditions in Filter Array Power Automate
  • Next, add a compose action and insert the ‘items’ as inputs to see the outputs. Click on +New step > Compose.
Power Automate Multiple Conditions in Filter Array
Power Automate Multiple Conditions in Filter Array

Now the flow is ready. Click on Save > test > Manually > Runflow. We can see it will extract only those data having the title as ‘Desktop’ and the city as ‘California’. As there are only 2 data that satisfy both the conditions, it will show those data.

Microsoft Power Automate filter array multiple conditions
Microsoft Power Automate filter array multiple conditions

Instead of using multiple filter array actions, we can merge both the condition and insert them into a single filter array action. For this, click on the first filter array and go to ‘edit in advanced mode’. Then insert the below expression:

@and(equals(item()?['Title'], 'Desktop'),equals(item()?['City'], 'California'))
How to apply multiple conditions in the 'Filter array' Power Automate
How to apply multiple conditions in the ‘Filter array’ Power Automate

Note- You need to insert a @ at the beginning of the expression. Similarly, we can use the ‘or‘ operator instead of the ‘and‘.

Read Power Automate create a task in Microsoft Planner

Power Automate OData filter multiple conditions

Now we will another example where we will use multiple OData filter conditions. To implement this, we are going to use the previous SharePoint list as the sample data.

Let’s create the flow where we will insert multiple OData filter queries to filter the data that will extract the data those having the title ‘Desktop’ or the city ‘Chicago’.

  • To create the flow, create an instant cloud flow that triggers the flow manually. Then add an action that will get all the items from the SharePoint list.
  • Under the trigger, click on + New step > Get items. Provide the site address and the list name. In the Filter query, insert the below expression:
Title eq 'Desktop' or City eq 'Chicago' 
  • Next, add a compose action to see the filter data. Click on + New step > Compose. In the Input, add the title and the city from the dynamic contents.
Power Automate odata filter multiple conditions
Power Automate OData filter multiple conditions

Now save the flow and test it manually. We can see it will retrieve only those items whose Title and City are equal to Desktop and Chicago respectively.

Flow with multiple OData conditions
Flow with multiple OData conditions

As 6 items satisfied the conditions so it is showing 6. This is how to use multiple OData filter queries in the Power Automate.

Read Power Automate Copy Folders

Microsoft flow condition if yes continue

Here we will see how to work with multiple conditions and if the conditions satisfy then it will continue the if yes part. To implement this, we are going to use the previous SharePoint list.

For example, we will create a flow that will check if the title is ‘Laptop’ and the quantity is greater than 10 then it will remove the delivery charges. Also, update that delivery charges to 0.

To create the flow, the following steps are:

  • On Power Automate, create an instant cloud flow. Then add the get items action to retrieve all the items from the SharePoint list.
  • Then add a condition control action where we will add the multiple conditions. Such as:
    • The title is equal to Laptop
    • Quantity is greater than 10
microsoft flow condition if yes continue
Microsoft flow condition if yes continue
  • If the conditions satisfy, then the flow will continue. That means the delivery charges will be updated to 0. Go to the If yes, click on +Add an action > update item. Provide the SharePoint Site address and the list name. In the delivery charges, type 0.
microsoft flow multiple condition if yes continue
Microsoft flow multiple conditions if yes continue

Let’s save the flow. Test it manually and run the flow. We can see the flow will run successfully and the list is updated where the conditions are satisfied.

Microsoft flow using multiple conditions if yes continue
Microsoft flow using multiple conditions if yes continue

This is how to use multiple conditions if yes continue in the Power Automate.

Read Power Automate Copy Files

Power Automate switch case multiple values

In this example, we will see how to work with multiple values using switch cases in Power Automate. For example, we have a SharePoint list named ‘Faculties’ having columns such as:

Columns Types
Title Default
Department Choice(IT, Finance, Management, Marketing)
Date Date and Time
Faculty Incharge People or group

When we select a department, it will automatically update the faculty in charge in the SharePoint list as per the multiple conditions. To create the flow, the following steps are:

  • On Power Automate, click on + Create > Automated cloud flow > Select the trigger ‘When an item is created > Create. Provide the SharePoint site address and the list name.
  • Next, add the switch control to update the item (i.e. Faculty Incharge) for each department. Under the trigger, click on + New step > Switch control > Select it. Select the ‘Department values’ for ‘On’.
power automate switch case multiple values
Power Automate switch case multiple values
  • Now we will add cases for each department’s value. In case 1, set a department value (i.e. IT) in equals. Then add an action inside case 1 to update the ‘faculty in charge in the SharePoint list.
  • Click on + Add an action > Update item. Provide the SharePoint site address, list name, ID, and Title. In the ‘Faculty Incharge’ set a user’s email.

Note- Make sure to set the email id as hardcoded. It will convert that email id into that user name in the list.

Power Automate Switch case using multiple values
Power Automate Switch case using multiple values
  • Similarly, add another case for Management. Also, add an action to update the item in the SharePoint list. For Management, let’s set another faculty in charge.
  • If we select other departments’ values (except IT and Management), then it will go with the default case where we will set the default faculty in charge.
Flow switch condition case with multiple values
Flow switch condition case with multiple values

Now save the flow. Click on test > Manually > Run flow. For a sample test, insert data inside the specified SharePoint list.

We can see it will automatically set the specified email in the ‘Faculty in charge’ column:

how to use multiple cases of Switch case in Flow
How to use multiple cases of Switch case in Flow

This is how to use multiple cases of Switch case in a Flow.

Read Power Automate Create PDF

Power Automate multiple condition person field

Here, we will see how to use multiple conditions in the person field. For example, we have a SharePoint list based on ‘Task list’ having some columns such as:

Columns Types
Title Default
Description Single line of text
Assigned To Person or group
Start Date Date and time
End Date Date and time
Status Choice (Blog post, YouTube)
power automate multiple condition person field
power automate multiple condition person field

Now we will create a flow using multiple conditions for the people column that will set the status column whether the assignee works for a blog post or youTube videos. To create the flow, the following steps are:

  • On Power Automate, create an instant cloud flow. Under that flow, add an action to get all the data from the SharePoint list.
  • Click on + New step > Get items. Give the Sharepoint Site address and the list name.
Power Automate multiple conditions on person field
Power Automate multiple conditions on person field
  • Now, add a condition control, that will check if the ‘assigned to’ field is equal to ‘Roselin’ or ‘Sonam subhadarsini’, then it will update their status to ‘Blog Post’; otherwise it will update the status as ‘YouTube’ for rest assignee.
  • Click on + New step > Condition control. Set the values, compare values and the operator such as:
    • ‘Assigned To display name’ is equal to ‘Roselin’
    • ‘Assigned To display name’ is equal to ‘Sonam Subhadarsini’
  • Inside both the ‘If yes’ and ‘If no’ sections, click on +Add an action > Update Item. Set the status as per the scenario. Such as:
Flow multiple conditions on SharePoint person column
Flow multiple conditions on SharePoint person column

Now save the flow and test it manually. Then click on the run flow. It will update the status according to conditions like below:

Multiple flow conditions on SharePoint people column
Multiple flow conditions on the SharePoint people column

This is how to use multiple flow conditions on the SharePoint people column.

Read Power Automate dynamic content

Power Automate multiple conditions and or

Here we will see how to work with multiple conditions using both the ‘And’ and ‘Or’ operators in a flow.

For example, we have a Sharepoint list based on ‘Bike sales’ having columns such as Title, quantity (number), color (Choice), payment mode (Choice), Applicable for discount(yes/no column), and having some sample data as below:

power automate multiple conditions and or
power automate multiple conditions and or

Let us create a flow using multiple conditions that will check if the title is equal to ‘Harley-Davidson’ and the quantity is greater than 15 or the payment mode is equal to ‘Instant Payment’, then the bike is applied for the discount.

Note– As per the scenario, first, it will check both the title and the quantity, if both the conditions satisfy, it will move to the payment mode options.

To create the flow, the following steps are:

  • On Power Automate, create an instant cloud flow that triggers the flow manually. Then add the ‘Get items’ action to retrieve all the items from the Sharepoint list.
  • Under the trigger, click on +New step > Get items. Supply the Sharepoint site address and the list name.
  • Next, add a condition control where we will apply the multiple conditions. Click on the + New step > Condition. Set the values, operators, and the compare value like below:
    • Title is equal to ‘Harley-Davidson
    • Click on +Add > Add row.
    • And (change the operator from the dropdown)
    • Quantityis greater than 15.
    • Click on +Add > Add group.
    • Or (change the operator from the dropdown)
    • Payment method values’ is equal to ‘Advance Payment’

Now the whole condition block will look like the below:

Microsoft power automate multiple conditions and or
Microsoft power automates multiple conditions and or
  • If the condition satisfies then it will allow it to apply for a discount and update the data in the SharePoint list. Inside the ‘If yes’ section, click on + Add an action > Update item. Provide the SharePoint site address, list name, and ID. In the ‘Applicable for discount’ column set the value as yes.
  • Similarly, repeat this in the ‘If no’ section, and in the ‘Applicable for discount’ column set the value as no like below:
power automate using multiple conditions and or
power automate using multiple conditions and or

Now our flow is ready. Just ‘Save‘ it and click on test > Manually > Runflow. We can see it will update the list where the conditions are satisfied:

How to use power automate multiple conditions and or
How to use power automate multiple conditions and or

This is how to use Power Automate multiple conditions with ‘and’, ‘or’ operators.

Power Automate subject filter multiple conditions

In Power Automate, there is a trigger ‘When a new email arrives’ that contains a field called ‘Subject filter’. When we enter a string in that field and if the string is a part of the email subject then the flow will trigger; otherwise, it won’t.

Power Automate subject filter multiple conditions
Power Automate subject filter multiple conditions

But it takes a single string, if there is no subject then it will not trigger the flow. As the field does not allow multiple strings to filter, we are going to use the trigger conditions. Where the subject will filter according to multiple conditions.

In this example, we will create a flow using multiple conditions on the subject that will filter it as per the conditions. According to the flow, it will trigger when the condition is met and if there is any attachment then it will store in a specific SharePoint library. To create the flow, the steps are:

  • On Power Automate, go to + Create > Automated Cloud Flow > select the trigger ‘When an email arrives’ > Create.
  • Select the folder for incoming mails i.e. Inbox.
  • To apply the conditions, click on the ellipses(…) > Setting.
Power Automate apply subject filter multiple conditions
Power Automate applies subject filter multiple conditions
  • Then click on the trigger condition > Insert the below expression.
@or(contains(triggerOutputs()?['body/subject'], 'SharePoint'),contains(triggerOutputs()?['body/subject'], 'Developer'), contains(triggerOutputs()?['body/subject'], 'Power Platform'))
Multiple Conditions on Flow email subject filter
Multiple Conditions on Flow email subject filter
  • Next, add an action to get the attachment from the email. Click on the + New step > Get attachment. Set the message Id and attachment Id from the dynamic content. It will create an ‘apply to each loop.
how do you specify multiple keywords in the subject filter Power Automate
How do you specify multiple keywords in the subject filter Power Automate
  • After getting the attachment, it will upload the file to the specified document library. Click on +Add an action > Create file. Specify the site address and folder path of the document library. set the file name as ‘name‘ and file content as ‘content byte‘ from the dynamic content.
power automate email subject filter multiple conditions
power automate email subject filter multiple conditions

Now the flow is ready. Click on Save > Test > Manually > Run flow. For testing purposes, send an email to yourself from another user account.

subject filter multiple conditions power automate
subject filter multiple conditions power automate

As the subject has that specified string, it will save the attachments in the Sharepoint document library.

Microsoft flow subject filter multiple conditions
Microsoft flow subject filter multiple conditions

This is how to do a subject filter with multiple conditions using Power Automate.

Power Automate condition contains multiple values

In this example, we will see how to use conditions that contain multiple values. To implement this, we have prepared a SharePoint list based on Vehicles having columns such as Title, Regd Number, Wheels, Color, country, state, owner, and date.

Example of SharePoint list
Example of SharePoint list

Now we will create a flow that will filter the data according to some specific string. For example, we will filter data whose title contains ‘B’ and the regd number contains ‘TX’. To create the flow, the steps are:

  • On Power Automate, go to + Create > Instant cloud flow > Select the trigger ‘Manually trigger a flow> Create.
  • Next, add an action to get the items from the list. Click on +New step > Get items. Specify the site address and the list name.
  • To add the multiple conditions, add a condition control. Click on +New step > Condition. In this condition control, add the values, operators, and the compare values such as:
    • Title (select the field from the dynamic content) contains B
    • To add another condition, click on +Add > +Add row > change the main operator to ‘And‘.
    • Then add the next condition, Regd number contains TX
power automate condition multiple values
Power Automate condition multiple values

If the condition is met, then it will move to the ‘If yes‘ section. Where we will add a compose action to see the retrieve values. In the ‘If yes‘ section, click on +Add an action > Compose. Add title and the regd number from the dynamic content of the get items.

power automate condition contains multiple values
Power Automate condition contains multiple values

Now save the flow and test it manually. We can see it will filter data that satisfies both the conditions. As there are 8 data, it will check all those data but show only those data that satisfied the conditions.

Microsoft flow conditions contains multiple values
Microsoft flow conditions contain multiple values

This is how the multiple conditions work with the ‘contains’ operator in Power Automate.

Power Automate multiple conditions email recipients

In this example, we will see how to use multiple conditions with email recipients in Power Automate. For example, we have a SharePoint list based on ‘Product’ having columns such as Title, Vendor (single line of text), Types (choice i.e. Software, hardware, including blank).

power automate multiple conditions email recipients
Power Automate multiple conditions email recipients

Next, we will create a flow that will send an email based on multiple conditions. If the product’s type is equal to software then it will send an email to a specific user, if the product’s type is equal to hardware then it will send an email to another user, similarly, if the type is blank then it will send an email to another user. To create the flow, the following steps are:

  • On Power Automate, go to My flows > + New flow > Instant cloud flow > Select the trigger ‘Manually trigger a flow‘.
  • Next, add an action that will get all the items from the SharePoint list. Click on +New step > Get items. Specify the site address and the list name.
  • After getting all the items, now we will add a condition control. Click on +New step > Condition control. Where we will use the values for the condition such as:
    • Types value is equal to Software.

If the condition is satisfied, then it will send an email to a specific user or HR. In the ‘If yes’ section, click on + Add an action > Send an email. Set the properties such as To, subject, and body of the email.

Multiple conditions email recipients Power Automate
Multiple conditions email recipients Power Automate
  • In the ‘If no’ section, add another condition control. Where we will insert a condition. According to the condition, whether the types are equal to hardware is not. Click on +Add an action > Condition. Set the values such as:
    • Types value is equal to Hardware
  • If the condition satisfies, then it will send an email to a specific user; Otherwise, it will notify another user to update the types of the product. In both the ‘, If yes’ and ‘If no’ sections, click on +Add an action > Send an email and send the properties to activate this action.
Microsoft flow multiple conditions email recipients
Microsoft flow multiple conditions email recipients

Now save the flow, click on test > manually > Runflow. We can see the flow ran successfully.

Sending an email with multiple conditions using Power Automate
Sending an email with multiple conditions using Power Automate

Also, it will notify the recipients via outlook as per the conditions. This is how to do send an email with multiple conditions using Power Automate.

Power Automate multiple condition person field is empty

For example, in a company, an HR has prepared a list in SharePoint but unfortunately, he forgot to insert data in some person’s fields. Here we will see how to work with an empty person field using multiple conditions in Power Automate.

Let’s take an example of a SharePoint list based on some columns such as the Project’s title, Start date, delivery date, manager (person field), and team lead (person field). These person fields have some empty fields.

power automate multiple condition person field is empty
power automate multiple condition person field is empty

Now, we will create a flow that will check if any of the people’s fields is empty then it will send an email to HR via Outlook. So that he can update the field. To create the flow, the steps are:

  • On Power Automate, create an instant cloud flow that will trigger the flow manually.
  • Next, add the ‘Get items‘ action to retrieve all the items from the list. Provide the site address and the list name.
Retrieve the items from the SharePoint list using Get items action
Retrieve the items from the SharePoint list using the Get items action
  • To check the empty fields in both columns, we will add a condition control. Click on the +New step > ‘Condition’ control. Set the fields, operators, and the compare values such as:
    • TeamLead display name is equal to null
    • Manager display name is equal to null
Flow condition on empty SharePoint multiple person fields
Flow condition on empty SharePoint multiple person fields
  • If conditions got matched then it will send an email notification to HR to update the list with the respective item link. In the ‘If yes‘ section, click on +Add an action > Send an email. Set a user ID in the To, give a subject to the email notification, and specify the body of the email.
Checking if a Person Field has an empty or Null condition Power Automate
Checking if a Person Field has an empty or Null condition Power Automate

That’s it. Now save the flow, click on test > manually > run flow. We can see it will notify the specified user or HR via outlook to update the people field in the SharePoint list with a link.

Dealing with empty Person fields in Flow
Dealing with empty Person fields in Flow

This is how to deal with empty Person fields in Flow.

Power Automate multiple condition parallel branch

There is an article where we have described some examples of how to work with a parallel branch in Power Automate under multiple conditions.

Power Automate multiple conditions email attachments

We have a blog where you can find the solution on how to save the email attachments in the SharePoint library based on multiple conditions.

Power Automate multiple conditions has attachment

Here we will see how to work with multiple conditions if the email has attachments. Also, we will see how to save those attachments to another location.

For example, when an email arrives the flow will check whether the email has attachments or not. If it has attachments then it will retrieve the attachments and store them in another Sharepoint folder.

To create the flow, the following steps are:

  • On Power Automate, create an automated cloud flow that triggers ‘When a new email arrives. Select a folder location for the arrival message i.e. Inbox.
  • Add a condition control to check whether the email has an attachment or not. Click on +New step > Condition. Set the values such as:
    • Has attachment is equal to true (expression)
    • And
    • Has attachment is not equal to null

Note- select ‘Has attachment’ from the dynamic content of the trigger.

power automate multiple condition has attachment
Power Automate multiple conditions has attachment
  • If there are any attachments, then it will get the attachments. In the ‘If yes‘ section, click on + Add an action > Get attachment. Provide the message Id and attachment Id from the dynamic content of the previous action.
Multiple conditions has attachment Power Automate
Multiple conditions ‘has attachment’ Power Automate
  • Next, add an action that will store the attachments in a specific SharePoint folder. Under ‘Get Attachment‘ action, click on + Add an action > Create file (under SharePoint connector). Provide the site address and the folder path. Set the ‘File name‘ and ‘File content‘ as ‘Name‘ and ‘Content Byte‘ from the dynamic content.
has attachment power automate multiple condition
Has attachment power automate multiple conditions

Now the flow is ready to run. Let’s save the flow and test it manually. For testing purposes, send an email to your outlook.

Has Attachment multiple conditions in Power Automate
Has Attachment multiple conditions in Power Automate

As the email has attachments, it will retrieve and store them in the specified folder like below:

Has Attachments Multiple Conditions using Power Automate
Has Attachments Multiple Conditions using Power Automate

This is how to do power automate multiple conditions has attachment.

Power Automate nested conditions limit

In Power Automate, there is a limitation of nesting a flow. It allows up to 8 nestings. If you use nestings more than 8 i.e. 9 or more then it will through an error message like below:

Items are nested at level '9' which exceeds the maximum nesting limit of '8'

But we can handle this error by combining the conditions. That means instead of using condition actions we can merge them into an expression.

Read Power Automate IF Expression

Power Automate multiple condition HTML table

Now, we will see how to create an HTML table from a SharePoint list using multiple conditions. To implement this, we are going to use a SharePoint list based on tasks having columns such as Title, Description, Assigned To, Start Date, End Date, Status(choices i.e. Blog Post, Content, YouTube).

Power Automate multiple condition HTML table
Power Automate multiple condition HTML table

Let’s create a flow that will build an HTML table from this SharePoint list whose task’s status is equal to ‘Blog Post’ and ‘Content’. Then it will send this table within the email. To create the flow, the following steps are:

  • On Power Automate, create an instant cloud flow that will trigger the flow manually. (We described in the previous flow to create an instant cloud flow).
  • Add an action ‘Get Items‘, to get the all items from the SharePoint list. Click on +New step > Get items. Provide the site address and the list name. In the ‘Filter Query‘, add the below expression that will retrieve only those data whose status is equal to ‘Blog Post‘ or ‘Content‘.
Status eq 'Blog Post' or Status eq 'Content'
Flow with Multiple condition create HTML table
Flow with Multiple conditions creates an HTML table
  • Add a ‘Select’ action that will select the specified properties from all elements of the ‘From’ array into a new array. Click on + New step > Select.
    • In the ‘From‘, select ‘value‘ from the dynamic content.
    • In the ‘Map‘, add the column name and insert the field from the dynamic content.
Microsoft Flow with Multiple conditions creates an HTML table
Microsoft Flow with Multiple conditions creates an HTML table
  • Next, add the action ‘Create HTML table‘ it will create an HTML table using the retrieved data. Click on +New step > Create HTML table. Set the ‘From‘ as ‘OutPut‘ and ‘Columns‘ as ‘Automatic‘.
Multiple conditions to create an html table Power Automate
Multiple conditions to create an HTML table Power Automate
  • Now the table is created but not formatted. To format the created HTML table, add the below expression within a compose action. Click on +New step > Compose.
replace(body('Create_HTML_table'),'<table>', '<table border = "2">')
  • Send this output via email to a user. Click on +New step > Send an email.
Multiple Get Items in one Html Table using Power Automate
Multiple Get Items in one Html Table using Power Automate

Now, save the flow. Click on Test > Manually > Run flow. We can see the flow will run successfully as well as it will send the email with converted the retrieved data into a table.

multiple condition html table using power automate
Multiple condition HTML table using power automate

This is how to do multiple condition HTML table using power automate.

Power Automate desktop multiple conditions

Here we will see how to use the multiple conditions within the Power Automate Desktop where the if action checks whether the given statement is true or not. If the statement is valid then it executes the logic between the If and end steps.

Let’s take an example of a desktop flow, where it will check if the product material is equal to solid then it checks the next condition whether the product’s price is greater than or equal to 1000. If both the conditions are valid then the product is eligible for a discount; otherwise, the product is not eligible for a discount.

To create the flow, the following steps are:

  • On Power Automate, go to + Create > click on ‘Desktop Flow’ > launch app. (If you have installed the desktop flow on your local system; otherwise, first download then click on launch app).
Working with Microsoft Power Automate
Working with Microsoft Power Automate
  • Click on + New flow. Give a name to the flow and then click on ‘Create‘.
Desktop flow using multiple conditions
Desktop flow using multiple conditions
  • From the left ‘Action’ panel, drag the ‘Set variable’ to the workspace. Set the variable name (ex- ProductPrice) and the value (i.e. 1500). Click on save.
Desktop flow conditions
Desktop flow conditions
  • Again, drag the ‘Set variable‘ to the workspace and drop it under the first variable. Give the variable name (i.e. IsItSolid) and set the value as ‘True’.
How to use multiple conditions on Power Automate Desktop flow
How to use multiple conditions on Power Automate Desktop flow
  • Next, drag the if action under the ‘conditionals‘ and drop it in the workplace. Set the properties such as:
    • First operand: IsItSolid
    • Operator: Equal to (=)
    • Second operand: True

Click on the Create.

How to include the conditionals within the Desktop flow
How to include the conditionals within the Desktop flow
  • To add another condition, drag the if condition and drop it under the previous ‘if’ action. Similarly, set the properties such as:
    • First operand: ProductPrice
    • Operator: Greater than or equal to
    • Second operand: 1000

Then click on the ‘Create‘.

Power Automate desktop multiple conditions
Power Automate desktop multiple conditions
  • If the statements are valid then it will show a message via message box. Drag and drop the Display message from the ‘Message boxes’ action. Give e title to the message box and the message to display. Then click on ‘Create‘.
Multiple conditions with contains in power automate desktop
Multiple conditions with contains in power automate desktop
  • If the conditions are not valid then it will move to the else part. Drag the ‘Else‘ action and drop it between the if and end statements.
  • Then add a message that will display when the conditions are not valid. Drag the display message action and drop it between the else and end statements.
  • Set the message box title and the display message.
If Else Conditions in Power Automate Desktop
If Else Conditions in Power Automate Desktop

Now, the entire flow will look like the below:

How to Use Conditionals in Microsoft Power Automate Desktop
How to Use Conditionals in Microsoft Power Automate Desktop

To see the result, click on save > Run. We can see the output will come as ‘Yes‘ as we have set the variable value as ‘1500‘.

How to Use Conditionals in Power Automate Desktop
How to Use Conditionals in Power Automate Desktop

We can see, that the flow will stop and show the output where the conditions are met. Similarly, if we set the variable value as below 1000 (suppose 500), then it will come as ‘No’.

Using of Conditionals in Microsoft Power Automate Desktop
Using of Conditionals in Microsoft Power Automate Desktop

This is how the multiple conditions work on Power Automate Desktop.

You may like the following Power Automate tutorials:

Conclusion

From this Power Automate Tutorial, we learned all about multiple conditions in Power Automate or Microsoft Flow. Also, we have discussed the below topics:

  • How to use multiple conditions in Power Automate with examples?
  • How to insert multiple trigger conditions in Power Automate?
  • How to use multiple if conditions in Power Automate?
  • Work with OData filters using multiple conditions in Power Automate.
  • How to use a Filter array with multiple conditions in Power Automate?
  • How to work with Microsoft flow conditions if yes continue?
  • How to use switch case multiple values in Power Automate?
  • Work with multiple conditions using both the ‘And’, ‘or’ Operator?
  • How to use multiple conditions in a SharePoint person field in Microsoft Power Automate?
>