Power Automate Trigger Conditions [33 Useful Examples]

In this Power Automate tutorial, users will get to know all about how to use trigger conditions in Power Automate. Also, we will see various examples of power automate trigger conditions:

  • Power Automate trigger condition
  • Power Automate adds trigger condition
  • Power Automate trigger condition with examples
  • Power Automate trigger conditions equals
  • Power Automate trigger condition not equal
  • Power Automate trigger condition contains
  • Power Automate trigger condition not empty
  • Power Automate trigger conditions multiple
  • Power Automate trigger condition SharePoint column
  • Power Automate trigger condition And OR
  • Power Automate trigger condition AND
  • Power Automate trigger condition OR
  • Power Automate trigger condition email subject
  • Power Automate trigger condition email
  • Power Automate trigger condition empty
  • Power Automate trigger condition greater than
  • Power Automate trigger condition true false
  • Power Automate trigger condition less than
  • Power Automate trigger condition modified date
  • Power Automate trigger condition null
  • Power Automate trigger condition ends with
  • Power Automate trigger condition choice column
  • Power Automate when an item is created trigger condition
  • Power Automate trigger condition modified by
  • Power Automate when a file is created trigger condition
  • Power Automate trigger condition file name
  • Power Automate when a new email arrives trigger condition
  • Power Automate trigger condition approval status
  • Power Automate trigger condition lookup field
  • Power Automate trigger condition based on time
  • Power Automate trigger condition string
  • Power Automate trigger condition has attachment
  • Power Automate trigger condition infinite loop
  • Power Automate trigger condition team

As the name suggests, a ‘Trigger condition’ is a condition that will trigger the flow as per the specified condition. Usually, we use a trigger condition to stop the infinite loop.

For example, we have created a flow that will trigger when an item is created or modified in the SharePoint list. We can see the flow will start with every update that will consume more space, to restrict that we need to set a trigger condition.

Table of Contents

Power Automate trigger condition

In Power Automate, the trigger condition is specified b the expression that evaluates the output in boolean format i.e. true or false.

The trigger condition allows one or more expressions using logical operators that must be true for the trigger to fire. Before using the trigger conditions, we need to sign in the Power Automate with the Microsoft user ID or your office ID.

As the dynamic content menu is not available so the user must use the expression using the available functions that return a boolean value. The trigger condition does not allow the numeric or object type, if we set the trigger condition using a non-null value then the flow will fail to tun,

The following table shows us whether the condition expression is valid or not.

ExpressionOutPut (Data type)Valid?
@add (15,10)IntegerNo
@json(triggerBody())ObjectNo
@equals(5,5)BooleanYes
@trueBooleanYes

Read Power Automate IF Expression

Power Automate add trigger condition

We can add one or more trigger conditions using ‘AND‘ & ‘OR‘ operators that evaluate a ‘true‘ value in Power Automate or Microsoft flow.

To add the trigger condition option, the following steps are:

  • On Power Automate, create an automated flow or any kind of flow by selecting a trigger. For example, let us create an instant cloud flow and select the trigger ‘Manually trigger a flow‘, and click on create.
Create an instant flow on Power Automate
Create an instant flow on Power Automate
  • In the trigger, click on the ellipses (…) (in the upper right corner) > settings.
Power Automate trigger condition
Power Automate trigger condition
  • Click on setting. We can find the option to add the trigger condition at the bottom with other properties such as:
    • Custom Tracking Id – The trigger’s Custom Tracking Id provides for the static or dynamic input of an identifier that may be passed in or set from the trigger and then added to the response.
    • Secure Inputs/Outputs – It is used to handle sensitive data such as passwords, IDs, banking-related information, etc.
    • Concurrency Control – It is used to control the concurrent or parallel run of our flow.
Power Automate trigger conditions
Power Automate trigger conditions

Note – Make sure to add a ‘@’ symbol at the beginning of the trigger condition.

Read Power Automate Multiple Conditions

Power Automate trigger condition with examples

Here we will see how the trigger condition works within the Power Automate with an example.

Suppose we have a SharePoint list based on ‘Products’ having columns such as:

ColumnsData type
TitleDefault
VendorSingle line of text
TypesChoice
PriceCurrency ($)
OrderDateDate and Time
StatusChoice
Power Automate trigger condition example
Power Automate trigger condition example

Now, we will create a flow that will send a notification when an item is created or modified in the SharePoint list and if the vendor is equal to ‘Dell’ then it notify a specified user or HR via Outlook.

To create the flow the following steps are:

  • On Power Automate, create an automated flow that will trigger when an item is created or modified. Click on +Create > Automated Cloud Flow > When an item is created or modified > Create. Provide the SharePoint site address and the list name.
Power Automate trigger condition example
Power Automate trigger condition example
  • Next, add an action that will send an email notification to the specified user. Click on +New step > send an email. Set the properties such as:
    • To – Specify the person’s email to whom you want to send the notification
    • Subject – Specify the email’s subject
    • Body – Specify the body of the email using dynamic content.
Example of Power Automate trigger condition
Example of Power Automate trigger condition
  • Now, we will add the trigger condition that will trigger only when the vendor is equal to Dell. To add the condition, go to the setting on the trigger and add the below expression:
@equals(triggerBody()?['Vendor'], 'Dell')
Trigger condition example in Power Automate
Trigger condition example in Power Automate

Click on the Done. Now save the flow and test it. For testing, add a new item in the SharePoint list with the vendor ‘Dell’.

Power automate example trigger condition
Power automate example trigger condition

We can see it will send an email notification to the specified user.

Power Automate example of trigger condition
Power Automate example of the trigger condition

Similarly, the flow will trigger when an item is modified to ‘Dell‘ and send an email notification to the specified user. This is how the trigger condition works on Power Automate.

Read Power Automate Parallel Branch with Examples

Power Automate trigger condition contains

In this example, we will see how to use contains function in the Power Autonare trigger condition.

We have a SharePoint task list based on tasks, descriptions, assignees, start date, and status. Now, we will set a condition that will trigger the flow if the title contains ‘Power Automate’.

@contains(triggerBody()?['Title'], 'Power Automate')
Power Automate trigger condition using contains
Power Automate trigger condition using contains

As per the condition, the flow will trigger only when the title of the task list contains the specified text i.e. ‘Power Automate’; otherwise, the flow will not trigger.

This is how to do Power Automate trigger condition using contains.

Read Power Automate email body formatting

Power Automate trigger condition not equal

Similarly, in this example, we will see how to use the ‘not equal’ function in the Power Automate trigger condition.

Let us take the previous SharePoint task list example where the flow will trigger when the title is not equal to ‘Power Automate’. In that case, we will insert the below expression in the trigger condition section.

@not(equals(triggerBody()?['Title'], 'Power Automate'))
Power Automate trigger condition not equals
Power Automate trigger condition not equals

The flow will trigger only when the title is not equal to Power Automate; otherwise, the flow will not run. This is how the ‘not equals’ function works with the Power Automate trigger condition.

Read Power Automate Do until

Power Automate trigger condition equals

In this example, we will see how to work with the equals function in the Power Automate trigger condition.

Suppose we have a SharePoint list based on Vehicles with some random data.

Power Automate trigger condition equals
Power Automate trigger condition equals

Now we will create a flow and set a trigger condition that will trigger the flow if the country is equal to the USA.

  • On Power Automate, we will create a flow that will trigger when an item is created or modified in the SharePoint list. Click on +Create > Automated Cloud Flow > When an item is created or modified > Create. Provide the SharePoint site address and the list name.
Power Automate trigger condition with equals
Power Automate trigger condition with equals

Here they will trigger and proceed with the further steps (as per your requirement) when the country is equal to the USA; otherwise, the flow will not run.

This is how to use trigger conditions with equals function in Power Automate.

Read Power Automate create a task in Microsoft Planner

Power Automate trigger condition AND

In Power Automate we can add multiple trigger conditions using ‘AND’ and ‘OR’ operators. In this example, we will see how to use the AND operator in the Power Automate trigger condition. To implement this, we are going to take the previous SharePoint list (i.e. Vehicles).

Suppose we will create a flow that will trigger when the title and the country are equal to the specified values such as Tesla and UK respectively.

The syntax for the AND operator:

@and(condition1, condition2, condition3,...)

To implement this, first, we will trigger the flow when an item is created or modified in the list. Then provide the SharePoint site address and the list name. Then go to the trigger condition and set the below condition:

@and(equals(triggerBody()?['Country'], 'USA'), equals(triggerBody()?['Title'],'Tesla'))
Power Automate trigger condition AND
Power Automate trigger condition AND

Here the flow will trigger when both conditions are satisfied; else, the flow will stop running. This is how to add trigger conditions using AND operator in Power Automate.

Read Power Automate Copy Folders

Power Automate trigger condition OR

Similarly, we can use the ‘OR’ operator instead of the ‘AND’ operator in the trigger condition. Here, if one of the condition is true, then the whole statement execute a true value. The syntax for the OR operator is:

@or(condition1, condition2, condition3,...)

To implement this, we are going to use the previous example where the flow will trigger only when the title or the country is equal to the specified values.

Suppose the flow will trigger only when the title is equal to ‘Tesla’ or the country is equal to ‘USA’. For this the expression will be:

@or(equals(triggerBody()?['Country'], 'USA'), equals(triggerBody()?['Title'],'Tesla'))
Power Automate trigger condition OR
Power Automate trigger condition OR

Then click on Done. Add the action as per your requirement. We can see the flow will trigger if one condition got true. This is how to use the OR operator in the Power Automate trigger condition.

Read Power Automate Copy Files + 21 Examples

Power Automate trigger condition AND OR

In this example, we will see how to use both the ‘AND’ and ‘OR’ operators in the trigger condition.

  • Suppose, we will create a flow and set a trigger condition that will trigger when the country and the state are equal to ‘USA‘ and ‘Texas‘ respectively or the title equals ‘Tesla‘.
  • For this, we will create a flow that will trigger when an item is created or modified in the SharePoint list. Provide the SharePoint site address and the list name.
  • Insert the below expression in the trigger condition section:
@or(and(equals(triggerBody()?['Country'],'USA'), equals(triggerBody()?['State'],'Texas')),equals(triggerBody()?['Title'],'Tesla'))
Power Automate trigger condition AND OR
Power Automate trigger condition AND OR

According to the above expression, the flow will trigger only when an item is created or modified, and also, when their country and the state or the title will match the given values. This is how to use the AND & OR operator in the Power Automate trigger condition.

Read Power Automate Create PDF

Power Automate trigger condition greater than

Here, we will see how to use the ‘greater than’ function in Power Automate trigger conditions. To implement this, we are going to use the previous SharePoint list i.e. Voters list.

Power Automate trigger condition greater
Power Automate trigger condition greater

Suppose, when we modified or created an item (voter’s name and age) in the SharePoint list, the flow will trigger as per the trigger condition i.e. the flow will trigger only when the voter’s age is greater than or equal to 18.

To create the flow, the following steps are:

  • On Power Automate, click on + Create > Automated Cloud Flow > When an item is created or Modified > Create.
  • Specify the SharePoint site address and the list name.
  • On the trigger, go to the trigger condition and set the below expression:
@greaterOrEquals(triggerBody()?['Age'],18)

As per the above expression, the flow will trigger only when the age is greater than or equal to 18.

Power Automate trigger condition greater than
Power Automate trigger condition greater than
  • Next, add a compose action to view the result:
Power Automate trigger condition greater than equals to
Power Automate trigger condition greater than equals to

Now, save the flow and test the flow manually. For testing purposes, let us create a new item or modify an item:

Power Automate trigger condition using greater than
Power Automate trigger condition using greater than

We can see the flow will run when the age is greater than or equal to 18.

Trigger condition greaterOrEquals in Power Automate
Trigger condition greater or equal in Power Automate

This is how to do Power Automate trigger condition using greater than.

Read Power Automate dynamic content

Power Automate trigger condition less than

Similarly, here, we will see how to use the ‘less than’ function in the Power Automate trigger condition.

Now, we will create a flow that will fire when the trigger condition matches i.e. if the age is less than 18. In this case, the expression will be:

@less(triggerBody()?['Age'],18)
Power Automate trigger condition less than
Power Automate trigger condition less than

As per the above expression, the flow will trigger when an item is created or modified and the value is less than 18; otherwise, the flow will not trigger. This is how to do the Power Automate trigger condition using less than.

Read Start and wait for an approval Power Automate

Power Automate trigger condition email

In this example, we will see how to insert a trigger condition when an email arrives in your mailbox (i.e. outlook) using Power Automate.

Now, we will create a flow that will trigger when an email comes from a specific person and it will notify the user via Microsoft Teams. To create the flow, the following steps are:

  • On Power Automate, click on +Create > Automated Cloud Flow > When a new email arrives > Create. Select the folder location to check the new emails (i.e. Inbox).
  • On the trigger, click on the ellipses(…) > setting > Trigger condition. Insert the below expression.
  • Click on Done.
@equals(triggerBody()?['From'], 'User3@tsinfotechnologies.com')

The above expression shows that the flow will run only when the email comes from the specified user; Otherwise, the flow will not run.

Power Automate trigger condition email
Power Automate trigger condition email
  • Next, we will add another action ‘Post message in a chat or channel‘ that will notify the user via Microsoft teams when the email arrives. Set the properties such as:
    • Post as– Flow bot
    • Post in– Chat with flow bot
    • Recipient– specify with a user email
    • Message– Give a message that will appear on the Teams
Power Automate Trigger condition When new email arrives
Power Automate Trigger condition When a new email arrives

Let’s save the flow and test it manually. Send an email from the specified user ID to yourself for testing purposes.

Trigger a flow when an email arrives from an specific sender
Trigger a flow when an email arrives from a specific sender

We can see it will notify the user via teams like below:

Trigger Conditions When a new email arrives (v3)
Trigger Conditions When a new email arrives (v3)

This is how to set Trigger Conditions When a new email arrives (v3) using Power Automate.

Read Power Automate shared mailbox

Power Automate trigger condition email subject

Similarly, here, we will see how to insert a trigger condition based on the email’s subject using Power Automate.

For example, we will create a flow that will trigger when the email subject contains a specific message. To create the flow, the following steps are:

  • On Power Automate, click on +Create > Automated Cloud Flow > When a new email arrives (V3) > Create.
  • In the trigger, click in the ellipses (…) > settings > Trigger conditions.
@contains(triggerBody()?['subject'], 'Offer Letter')
Power Automate trigger condition email subject
Power Automate trigger condition email subject
  • Next, add an action ‘Post message in a chat or channel‘ and set the properties to activate the action.
Power Automate trigger condition use email subject
Power Automate trigger condition use email subject

Now save the flow. For testing purposes send an email from another user to yourself where the subject has that specific keyword.

We can see the flow will run successfully if the email subject has the specific word otherwise the flow will not trigger. This is how to do the Power Automate trigger condition using the email subject.

Read Power Automate flow with Microsoft teams

Power Automate trigger condition empty

Here we will see how to use the empty function in the Power Automate trigger condition and based on that the flow will trigger only when a specific field is empty in a SharePoint list or library.

For example, when we upload a file in the SharePoint library, the flow will trigger and check if the ‘details‘ field is empty in that library then it will notify the user about the empty field.

Suppose we have a library like the below:

Power Automate trigger condition empty
Power Automate trigger condition empty

To create the flow, the following steps are:

  • On Power Automate, click on My flows > +New flow > Automated Cloud Flow > Create.
  • Specify the SharePoint site address and the library name.
  • Then click on the ellipses(…) of the trigger > Settings.
Power Automate trigger condition with empty
Power Automate trigger condition with empty
  • Set the below expression in the trigger conditions section.
@empty(triggerBody()?['Details'])
Power Automate trigger condition empty function
Power Automate trigger condition empty function
  • Next, add an action ‘Post message in a chat or channel‘ and set the properties to activate the action.
Power Automate trigger condition if the field is empty
Power Automate trigger condition if the field is empty

Now we will save the flow and test it manually. Let us upload a file in that library without details.

Power Automate trigger condition with empty function
Power Automate trigger condition with an empty function

We can see it will notify the specified user about the empty field via Teams like below:

Trigger condition when field is empty
Trigger condition when the field is empty

This is how to use the Trigger condition when the field is empty in Power Automate.

Read Power Automate vs Nintex

Power Automate trigger condition not empty

Similarly, we can trigger the flow if the field is not empty. For this, we need to insert the below expression in the trigger condition.

@not(empty(triggerBody()?['Details']))
Power Automate trigger condition not empty
Power Automate trigger condition not empty

Here, the flow will trigger if the details field is not empty; otherwise, the flow will not trigger. This is how to do the Power Automate trigger condition not empty.

Power Automate trigger condition true false

In this example, we will see how to use the true/false statement in Power Automate. For example, we have a ‘yes/no’ column in the Voters SharePoint list (we have used it previously).

Power Automate trigger condition true false
Power Automate trigger condition true false

Now we will create a flow that will trigger if the voter is eligible for voting as per the respective age. To create the flow,

  • On Power Automate, create an automated cloud flow and trigger this ‘When an item is created or modified. Provide the SharePoint site address and the list name.
  • On the trigger, click on the ellipses (…) and then go to setting. In the trigger condition, insert the below expression.
@equals(triggerBody()?['Eligible'],true)
Power Automate trigger condition using true false
Power Automate trigger condition using true false
  • Click on Done.
  • To see the output, add a compose action under the trigger and add the dynamic contents.
Power Automate trigger condition Boolean
Power Automate trigger condition Boolean

Now save the flow and test it. For testing purposes, let us modify one data in the list and mark it as eligible.

Power Automate trigger condition with true false
Power Automate trigger condition with true false

We can see as the trigger conditions matched true, so the outcome will appear like below:

Power Automate trigger condition with Boolean
Power Automate trigger condition with Boolean

The flow will trigger only when the true/false or yes/no column mark as true; otherwise, the flow will not start. This is how to use the Power Automate trigger condition with Boolean.

Read Power Automate or Microsoft Flow delete all files in a folder

Power Automate trigger conditions multiple

Now, we will see how to use multiple trigger conditions on Power Automate. For example, we have a SharePoint list based on task, their respective assignees, and the details such as:

Power Automate trigger conditions multiple
Power Automate trigger conditions multiple

Based on the above list, we are going to create a flow that will trigger only when the title contains a specified text i.e. ‘Power BI’ and the status is equal to ‘Completed’. To create the flow, the following steps are:

  • On Power Automate, create an automated flow that will trigger when an item is created or modified. Provide the SharePoint site address and the list name.
  • On that trigger, go to the setting > trigger conditions. Insert the below expression to check whether the title contains ‘Power BI’ or not.
@contains(triggerBody()?['Title'],'Power BI')
  • To add another condition, click on the +Add, then add the below expression to check whether the status is completed or not.
@equals(triggerBody()?['Status']?['Value'], 'Completed')
Power Automate Multiple trigger conditions
Power Automate Multiple trigger conditions
  • Click on the Done. Now add a compose action and insert some fields from the dynamic contents such as title, status, date, etc.
Multiple trigger conditions in Power Automate
Multiple trigger conditions in Power Automate

Let’s save the flow and test it, For testing purposes, we will modify one data according to trigger conditions:

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

We can see as the conditions got matched, the flow will trigger and the output will come as:

Multiple trigger conditions in a flow
Multiple trigger conditions in a flow

This is how to use multiple trigger conditions in a flow.

Read Upload PowerApps Attachments to SharePoint Library Folder

Power Automate trigger condition SharePoint column

Here, we will see how to use the SharePoint column in the Power Automate trigger condition. Suppose, we have a SharePoint list based on task reports having some random data.

Power Automate trigger condition SharePoint column
Power Automate trigger condition SharePoint column

Now, we will create a flow that will trigger if the created or modified item contains a specified text (i.e. ‘SharePoint’) then it will notify the respective employee via outlook. To create the flow, the following steps are:

  • On Power Automate, create an automated cloud flow and trigger the flow when an item is created or modified in the SharePoint list. Provide the SharePoint site address and the list name.
  • Then on the trigger conditions set the below expression that will trigger the flow if the ‘topic name‘ has SharePoint.
@contains(triggerBody()?['Topicname'], 'SharePoint')
Power Automate trigger condition SharePoint single line text
Power Automate trigger condition SharePoint single-line text
  • Click on Done.
  • Add another action to send an email to the respective assignee to notify them about the task. Click on +New step > Send an email. Set the properties such as To, Subject, and Body.
Power Automate trigger condition based on SharePoint column
Power Automate trigger condition based on SharePoint column

Now save the flow and test it. For testing purposes, let’s modify an item in that list where the topic name contains ‘SharePoint‘.

Power Automate trigger condition based on SharePoint column
Power Automate trigger condition based on SharePoint column

As the topic name contains the specified text, the flow will trigger and send the notification to the assignee like below:

Power Automate trigger condition using SharePoint column
Power Automate trigger condition using SharePoint column

If the topic name does not contain the specified text, then it will not trigger. This is how to use the SharePoint column in the Power Automate trigger condition.

Read Power Automate add days to date

Power Automate trigger condition modified date

In this example, we will see how to modified date and time works in the Power Automate trigger condition.

Let us take an example of a Sharepoint list based on Products and their details such as:

Power Automate trigger condition modified
Power Automate trigger condition modified

Now we will create a flow, that will fire when both the created and the modified timings are the same. To create the flow, the following steps are:

  • On Power Automate, create an automated flow and trigger it when an item is created or modified. Provide the SharePoint site address and the list name.
  • Then on the trigger, set the below expression in the trigger conditions:
@equals(triggerBody()?['Modified'], triggerBody()?['Created'])
Power Automate trigger condition modified date
Power Automate trigger condition modified date
  • To see the output, we will add a compose action with some dynamic contents.
Power Automate trigger condition based on modified date
Power Automate trigger condition based on modified date

Now save the flow and test it manually. Let us create a new item in the SharePoint list to test the flow.

Trigger condition modified date on Power Automate
Trigger condition modified date on Power Automate

As both the created and the modified are at the same time, the flow will trigger successfully. This is how to trigger the condition modified date on Power Automate.

Read Power Automate Increment Variable

Power Automate trigger condition null

Here, we will see how to work with a null value in the Power Automate trigger condition. To implement this, we are going to use the previous SharePoint list (i.e. Product) where the Status has a null value like below:

Power Automate trigger condition null
Power Automate trigger condition null

Now we will create a flow that will trigger when the status has not a null value. For this, we will create an automated cloud flow and trigger it when the item is created or modified and insert the below expression to fire the flow if there is no null value in the status field.

@not(equals(triggerBody()?['Status']?['Value'], null))
Power Automate trigger condition using null
Power Automate trigger condition using null
  • Add a compose action to see the outputs:
Trigger condition null in Power Automate
Trigger condition null in Power Automate

Now save the flow and for testing purposes, let us modify the status in the SharePoint list.

Power Automate trigger condition using null value
Power Automate trigger condition using a null value

As the status has no value the flow will trigger successfully and the output will come as:

Power Automate trigger condition with null
Power Automate trigger condition with null

This is how to use the null value in the Power Automate trigger condition.

Power Automate trigger condition ends with

In this example, we will see how to use the ‘ends with’ function in the Power Automate trigger condition. Here, we are going to use the previous SharePoint list i.e. Product.

Power Automate trigger condition ends with
Power Automate trigger condition ends with

Now, we will create an automated flow that will fire when the item is created or modified and ends with a specific text. Suppose, the flow will be triggered when the product’s title ends with ‘top’ (whether it is a laptop or desktop); otherwise the flow will not trigger and run.

  • Create an automated flow that will trigger when an item is created or modified. Then provide the SharePoint site address and the list name.
  • In the trigger condition section, add the below expression:
@endswith(triggerBody()?['Title'], 'top')
Power Automate trigger condition with ends with
Power Automate trigger condition with ends with
  • Then add other logical actions as per the requirements. For example, we are going to use the compose action with some values having dynamic contents to show the output.
Trigger condition using ends with in Power Automate
Trigger condition using endswith in Power Automate

Now save the flow and test it. For testing purposes, modify an item to another that endswith ‘top’ i.e. Desktop.

Trigger condition using endswith function
Trigger condition using ends with function

As the modified item ends with ‘top’, the flow will be triggered successfully and return the output. This is how to use the ‘ends with’ function in the Power Automate trigger condition.

Power Automate trigger condition choice column

In this example, we will see how to work with the choice column or option value in the Power Automate trigger condition.

To implement this, we are going to use the previous SharePoint list i.e. Product. Now, we will set trigger conditions that will trigger the flow when the status is Delivered.

@equals(triggerBody()?['Status']?['Value'], 'Delivered') 
Power Automate trigger condition choice column
Power Automate trigger condition choice column

Click on Done. We can see the flow will trigger when the status is updated to deliver. This is how to do the Power Automate trigger condition choice column.

Power Automate when an item is created trigger condition

In this example, we will see how to use a trigger condition when an item is created in the SharePoint list.

Suppose, when a task is created in a SharePoint list having a specified text and the task is assigned to you, then it will create a task in the Microsoft Planner automatically.

The list that we have prepared looks like the below:

Power Automate when an item is created trigger condition
Power Automate when an item is created trigger condition

Now, we will create a flow that will trigger when an item is created based on ‘Power Automate’ and assigned to a specific person ‘Sonam Subhadarsini’ then it will create a task in the user’s planner.

To do this, the following steps are:

  • On Power Automate, create an automated flow that will trigger when an item is created in the SharePoint list. Provide the SharePoint list and site address.
  • Then in the trigger conditions section, insert the below conditions:

Note- You can merge the conditions with the AND operator or insert them separately.

@contains(triggerBody()?['Title'],'Power Automate')
@equals(triggerBody()?['AssignedTo']?['DisplayName'], 'Sonam Subhadarsini')
Power Automate trigger condition when an item is created
Power Automate trigger condition when an item is created
  • Next, add an action ‘Create a task‘ to create a task in the Microsoft Planner. Provide the Group Id, Plan Id, Title, Bucket Id, Assigned user Ids, etc.
Set trigger condition when an item is created
Set trigger condition when an item is created

Now, the flow is ready. Let’s save the flow and test it manually. Create a new item in the SharePoint list as per the conditions set:

Power Automate set trigger condition when an item is created
Power Automate set trigger condition when an item is created

We can see as both the conditions matched, a task has been created in the planner:

Power Automate trigger condition when an item is created in the SharePoint list
Power Automate trigger condition when an item is created in the SharePoint list

This is how to set trigger conditions in Power Automate when an item is created.

Power Automate trigger condition modified by

Here, we will see how to set a trigger condition when an item is modified by someone else. Let’s take the previous task list as an example where the flow will trigger if the created and the modified fields are not the same.

Power Automate trigger condition modified by
Power Automate trigger condition modified by

To create the flow, the following steps are:

  • On Power Automate, create an automated flow that will trigger when an item is created or modified. Specify the SharePoint site address and the list name.
  • Then go to the trigger conditions section, and insert the below expression:
@not(equals(triggerBody()?['Author']?['DisplayName'], triggerBody()?['Editor']?['DisplayName']))

Note- Here the ‘Author‘ and ‘Editor‘ are the internal names of the ‘Created by‘ and ‘Modified by‘.

Power Automate trigger condition based on modified by
Power Automate trigger condition based on modified by
  • Add another action ‘Post message in a chat or channel‘ and set the properties such as Post as, post in, Recipient, Message (using dynamic contents).
Power Automate trigger condition using modified by
Power Automate trigger condition using modified by

Now the flow is ready. To test the flow, let’s modify an item from another user:

Power Automate using trigger condition based on Modified by
Power Automate using trigger condition based on Modified by

As both the author and editor are not the same, it will notify the specified user about the modification via Microsoft Teams. This is how to do Power Automate using trigger conditions based on Modified by.

Power Automate when a file is created trigger condition

Here, we will see how to use the trigger condition when a file is created in a SharePoint document library.

Suppose, there is a document library ‘File Storage‘ on the SharePoint site. Now, we will create a flow that will trigger when a file is created and we will set a trigger condition on that flow i.e. the flow will trigger only when the file contains a specific text. Also, it will notify the given user about file uploading.

To create the flow, the following steps are:

  • On Power Automate, create an automated cloud flow that will trigger the flow when a file is created. Specify the SharePoint site address and the library name.
  • To set the trigger condition, click on ellipses (…) > Settings.
Power Automate when a file is created trigger condition
Power Automate when a file is created trigger condition
  • On the trigger condition, set the below expression that will fire the flow only when the file name contains the text ‘Power Automate’.
@contains(triggerOutputs()?['body/{FilenameWithExtension}'], 'Power Automate')
Trigger condition in Power Automate flow when a file is created
Trigger condition in Power Automate flow when a file is created
  • Add a ‘Post message in a chat or channel‘ to notify the user about the related file (set the properties as previously).
Set trigger condition when a file is created in Power Automate
Set trigger condition when a file is created in Power Automate

Now, save the flow. To test the flow, upload a file in the document library:

Power Automate trigger condition when a file is created
Power Automate trigger condition when a file is created

As the file name contains ‘Power Automate’, the flow will trigger successfully and notify the user via Teams like below:

Trigger condition when a file is created in a library
Trigger condition when a file is created in a library

Note – The flow will not trigger and run if the file does not contain the given text i.e. Power Automate.

This is how to set trigger conditions when a file is created in a library in Power Automate.

Power Automate trigger condition file name

Here, we will see how to use a trigger condition based on a file name. For example, we can trigger a flow if the filename contains the specified extension i.e., .pdf, .txt, .xlsx, etc.

In such a case the trigger condition will be:

@endswith(triggerOutputs()?['body/{FilenameWithExtension}'], '.pdf')

Similarly, we will add a ‘Post message in a chat or channel‘ to notify the user about the file uploading.

Power Automate trigger condition file name
Power Automate trigger condition file name

Now save the flow and test it. Let’s upload multiple files including pdf format.

Power Automate trigger condition based on file name
Power Automate trigger condition based on filename

We can see it will notify only about that file whose filename contains ‘.pdf’. This is how to do the Power Automate trigger condition based on the file name.

Read Power Automate SharePoint Get items filter query contains is not valid

Power Automate when a new email arrives trigger condition

Here, we will see how to set a trigger condition when a new email arrives in your mailbox i.e. Outlook.

For example, we will create a flow that will trigger when a new email arrives from a specific person and it will send a mobile notification to the user; otherwise, the flow will not trigger. To implement this, we will create a flow and the following steps are:

  • On Power Automate, create an automated cloud flow and trigger it ‘When a new email arrives and select the ‘Inbox‘ as the email folder.
  • Set the below expression on trigger condition that will trigger only when the email comes from a specified user i.e. ‘User3@tsinfotechnologies.com‘.
@equals(triggerBody()?['From'], 'User3@tsinfotechnologies.com')
Power Automate when a new email arrives trigger condition
Power Automate when a new email arrives trigger condition
  • Add an action ‘Send me a mobile notification‘ that will notify the user via mobile.
Power Automate set trigger condition when a new email arrives
Power Automate set trigger condition when a new email arrives

Now save the flow. Send an email from the specified user ID.

Microsoft flow when a new email arrives trigger condition
Microsoft flow when a new email arrives triggers condition

As the condition is satisfied, so it will trigger the flow successfully and notify the user via mobile like below:

trigger condition when a new email arrives on Power Automate
trigger condition when a new email arrives on Power Automate

This is how to set trigger conditions when a new email arrives on Power Automate.

Power Automate trigger condition approval status

In this example, we will see how to use the trigger condition based on approval status in Power Automate.

For example, we have a SharePoint list of ‘Office expenses’ where the employee will request the office expenses. Based on the list, we will create a flow that will trigger only when the approval status will be updated as ‘Delivered’ and notify that user via the teams who created that request.

Power Automate set trigger condition approval status
Power Automate sets trigger condition approval status

To create the flow, the following steps are:

  • On Power Automate, create an automated flow that will trigger when an item is created or modified in the SharePoint list. Set the trigger condition using the below expression that will trigger only when the approval status will be set as ‘Delivered’.
@equals(triggerBody()?['Status']?['Value'], 'Approved')
Power Automate trigger condition approval status
Power Automate trigger condition approval status
  • To send the approval notification via the teams, add an action ‘Post message in a chat or channel‘. Set the properties as previously.
Power Automate trigger condition based on approval status
Power Automate trigger condition based on approval status

Now the flow is ready. To test the flow, let’s update the approval status to ‘Delivered’ in the SharePoint list.

Power Automate set trigger condition based on approval status
Power Automate set trigger condition based on approval status

As the approval status changes, it will send a notification to the requestor who created this request via the teams below:

Power Automate using trigger condition approval status
Power Automate using trigger condition approval status

This is how to use Power Automate trigger conditions based on approval status.

Power Automate trigger condition lookup field

Now, we will see how to use lookup field in Power Automate trigger condition. For example, we have a SharePoint list based on Events with some columns including a look up column i.e. Organizer.

Power Automate trigger condition lookup field
Power Automate trigger condition lookup field

Now we will create an automated flow that will trigger when an item is created or modified. Also, the flow will trigger only based on a trigger condition. As per the condition, if the lookup field is empty then it will notify the user via the Microsoft teams.

To create the flow, the following steps are:

  • On Power Automate, create an automated cloud flow and trigger it when an item is created or modified.
  • Set the below expression in the trigger condition that will fire the flow if the lookup field is empty.
@empty(triggerBody()?['Organizer'])
Power Automate trigger condition based on lookup field
Power Automate trigger condition based on lookup field

Next, add a ‘Post message in a chat or channel‘ and fill all the properties to activate the action.

Power Automate trigger condition using lookup field
Power Automate trigger condition using lookup field

Now save the flow and test it. For testing purposes, let’s insert a data in the SharePoint list:

Power Automate set trigger condition using lookup field
Power Automate set trigger condition using lookup field

We can see as the lookup field is blank, so the flow will triggered and send a notification via the teams who created this record.

Trigger condition using lookup field in Power Automate
Trigger condition using lookup field in Power Automate

This is how to work with lookup field in Power Automate trigger condition.

Power Automate trigger condition based on time

Here we will see how to work with trigger condition based on times. We have a SharePoint list having two date and time columns:

Power Automate trigger condition time
Power Automate trigger condition time

Now we will create a flow that will trigger when an item is created or modified and both the time are not same. In such case the trigger condition will be:

@not(equals(triggerBody()?['OrderDateTime'], triggerBody()?['ShippedDateTime']))

By using the above trigger condition, the flow will only when the created item or modified item has different date times ; otherwise, the flow will not trigger. This is how to use trigger condition based on time in Power Automate.

Power Automate trigger condition string

Similarly, here we will see how to use string data type in Power Automate trigger condition. For example, we have a SharePoint list that contains student’s name along with their last name, and their results.

Power Automate trigger condition string
Power Automate trigger condition string

Now we will create a flow that trigger when an item is created or modified in the SharePoint list. Also, insert the below trigger condition:

@empty(triggerBody()?['LastName'])

As per the above trigger condition, the flow will be trigger only when the created or modified item has blank string data i.e. blank lastname. This is how to use string data type in Power Automate trigger condition.

Power Automate trigger condition teams

This example will show how to set a trigger condition based on the Microsoft teams. For example, when an important message will post on a channel it will notify the user via mobile notification.

To implement this, we will create an automated flow and the following steps are:

  • On Power Automate, create an automated cloud flow and trigger it ‘When a new channel message is added‘. Provide the team and the channel.
Power Automate trigger condition team
Power Automate trigger condition team
  • To set the trigger condition, click on the ellipses(…) > settings > trigger condition. Insert the below expression that will trigger when an important or high-importance message is posted on the teams.
@equals(triggerOutputs()?['body/importance'], 'high')
Power Automate flow set trigger condition based on team
Power Automate flow set trigger condition based on team
  • To send the notification via mobile, add another action ‘Send me a mobile notification‘. Set the text field using the dynamic contents. We can see what the flow will look like below:
Teams Message Trigger Condition for IMPORTANT! or high
Teams Message Trigger Condition for IMPORTANT! or high

Now the flow is ready to run. To test the flow, let’s post a message in the specified channel and make it as important:

Teams Message set Trigger Condition for IMPORTANT! or high
Teams Message set Trigger Condition for IMPORTANT! or high

We can see as it is an important message it will send a notification to the user via mobile like below:

Power Automate trigger condition based on Microsoft team
Power Automate trigger condition based on Microsoft team

Power Automate trigger condition has attachment

In this example, we will see how to set a condition on the trigger when an item is created in the SharePoint list.

As per the trigger condition, the flow will trigger the created item that has attachments in the SharePoint list.

To create the flow, the following steps are:

  • On Power Automate, create an automated cloud flow that triggers when an item is created in a specified SharePoint list. Provide the SharePoint site address and the list name.
  • On the trigger, go to the trigger conditions and set the below expression:
@equals(triggerOutputs()['body/{HasAttachments}'], bool('True'))
Power Automate trigger condition has attachment
Power Automate trigger condition has attachment
  • To see the result add a Compose action and add values like the below:
Power Automate set trigger condition has attachment
Power Automate set trigger condition has attachment

Now save the flow and test it. Let’s insert an item with an attachment in the Sharepoint list.

Trigger condition has attachment on Power Automate
Trigger condition has an attachment on Power Automate

As the item has an attachment, the flow run successfully and the output will come like this:

Microsoft flow trigger condition has attachment
Microsoft flow trigger condition has attachment

This is how to use the Microsoft flow trigger condition has an attachment.

Power Automate trigger condition infinite loop

Here we will see how to avoid an infinite loop in the Power Automate trigger condition. For example, we are going to use a SharePoint list, when we created or modified an item it will update the item by adding some random digit to it.

Power Automate trigger condition infinite loop
Power Automate trigger condition infinite loop

To update the item automatically, we have created an automated flow like the below:

Power Automate trigger condition to avoid infinite loop
Power Automate trigger condition to avoid the infinite loop

In the compose action, we used the below expression:

concat('',rand(1,9))

In the Title, we inserted the below expression:

concat ( triggerOutputs()?['body/Title'], outputs('Compose'))

When we save the flow, we can see a warning message in the flow checker.


Actions in this flow may result in an infinite trigger loop. Please ensure you add appropriate conditional checks to prevent this flow from triggering itself.
Power Automate set trigger condition for infinite loop
Power Automate set trigger condition for infinite loop

When we run this flow, we can see it will create an infinite loop.

Power Automate trigger condition to avoid an infinite loop
Power Automate trigger condition to avoid an infinite loop

To avoid this, we will insert a trigger condition. As per the trigger condition, if the title equals a specified text, then the infinite loop will stop and update the item.

@equals(triggerBody()?['Title'], 'Checklist1')
How to avoid infinite loop in Power Automate trigger condition
How to avoid infinite loop in Power Automate trigger condition

Now save the flow and test it. We can see the flow will stop the infinite loop. This is how to avoid an infinite loop in the Power Automate trigger condition.

Conclusion

From this Power Automate Tutorial, we have discussed all trigger conditions and how to use the condition in different scenarios such as:

  • What is the Power Automate trigger condition?
  • How to add trigger conditions in Power Automate?
  • Give an example of a Power Automate trigger condition.
  • How to use contains function in the Power Automate trigger condition?
  • How to use ‘not equals’ in the Power Automate trigger condition?
  • How to use the equals function in Power Automate trigger conditions?
  • How to use the AND operator in the Power Automate trigger condition?
  • How to use the OR operator in the Power Automate trigger condition?
  • How to use both the AND OR in the Power Automate trigger condition?
  • How to use the Power Automate trigger condition with emails?
  • How to work with the email subject in the Power Automate trigger condition?
  • What happens if the trigger condition is not empty in Power Automate?
  • How to work with an empty function in the Power Automate trigger condition?
  • How to use the greater-than function in the Power Automate trigger condition?
  • How to use the less-than function in the Power Automate trigger condition?
  • How to work with the true/false or boolean in the Power Automate trigger condition?
  • How to use multiple trigger conditions in Power Automate?
  • How to use Power Automate trigger condition based on the SharePoint column?
  • How to use the modified date in the Power Automate trigger condition?
  • How to use a null value in the Power Automate trigger condition?
  • Power Automate trigger condition ends with
  • Power Automate trigger condition choice column
  • Power Automate when an item is created trigger condition
  • Power Automate trigger condition modified by
  • Power Automate when a file is created trigger condition
  • Power Automate trigger condition file name
  • Power Automate when a new email arrives trigger condition
  • Power Automate trigger condition approval status
  • Power Automate trigger condition lookup field
  • Power Automate trigger condition based on time
  • Power Automate trigger condition string
  • Power Automate trigger condition has attachment
  • Power Automate trigger condition infinite loop
  • Power Automate trigger condition team

You may like the following Power Automate tutorials:

  • Whenever I search something for power platform or SharePoint or PowerShell. I always found this site in top 10 links at first page.
    And I am very happy to say that 90% I found the stuff what I look for. Thank you Bijay!

  • Dear Bijay,
    How can i trigger a flow in Power Automate only when, let’s say, the column “Analyst” of a List is modified, regardless it’s value?
    I’ve been searching this for hours now.
    Thanks in advance!

  • Dear Bijay, I am new to Power Automate and this is a great article about adding filter conditions to flow triggers. I have a choice column where I’ve enabled multiple selections. Using your code above it doesn’t seem to ‘fire’ the trigger – even if I specify the value (presumably because it’s an array?)
    An example of a trigger condition I tried is as follows= @equals(triggerBody()?[‘Rejection Criteria’]?[‘Value’],’Other’).

    I have also tried @not(empty(triggerBody()?[Rejection Criteria’]))

    Any ideas how I can get the filter to activate if one or more choices are selected?? If I can get this to work I might have to add multiple conditions (one for each ‘choice’ available). Is there any way to simply set the filter so that it triggers when not empty (i.e. I’d only have to have one filter rather than multiple ones. Many thanks is advance.

  • Hi, I want to know that we can use calculated columns in trigger condition of when an item is created or modified of Power Automate trigger ?

  • >