Power Automate Get items Filter Query

This Power Automate tutorial will teach you about “Power Automate Get items Filter Query“. Also, I will show some examples of Odata filter query conditions like Power Automate get items filter query equals, Power Automate get items filter query not equals, and Power Automate get items filter query greater than.

Power Automate Odata filter query is an option of ‘Get items’ and ‘Get rows’ action, which filters the data based on the requirements using specific conditions.

Power Automate Get items Filter Query

The Power Automate get items filter query is an option in the ‘Get items’ and ‘Get rows’ flow action, which filters and fetches the data from SharePoint based on the specific filter query conditions.

However, this property will be helpful when a user is dealing with bulk data to fetch all list items at a time.

Power Automate ‘Get items’ flow action Filter Query Operators:

The operators in the table below can be used in the Power Automate get items filter query syntax.

OperatorFor
eqequals
nenot equals
gtgreater than
gegreater than or equal to
ltless than
leless than or equal to

Power Automate Get Items Filter Query Equals

I will show you how to use Power Automate’s get items filter query equals operator.

I have taken a SharePoint with a few column names, like Trip Title, Trip start date, End date, Travel duration days, etc. According to our requirements, we wanted to get all the SharePoint list items with ‘Trip Status’ as ‘In Progress.’

This is the image of SharePoint list looks like with different columns:

Power Automate Get Items Filter Query Equals

Let’s follow the below-mentioned steps to create a Power Automate flow:

1. Browse make.powerautomate.com to open the Power Automate Home page -> Tap on +Create -> Select ‘Automated cloud flow’ -> Give Flow name and choose trigger ‘When an item is created or modified’ -> Provide Site Address and List Name.

Power Automate OData filter query equals example

2. Add the ‘Get items’ flow action under the trigger. Power Automate ‘Get items’ flow action retrieves all items from a SharePoint list. Set the below details:

  • Site address: Select a specific site address from the drop-down.
  • List Name: Select a specific list from the drop-down.
  • Filter Query: Provide the condition as placed below code:
TripStatus eq 'In Progress'

Where ‘eq’ means ‘equals to’ operator in a Power Automate filter query syntax. (TripStatus: Internal Name of a Field).

Power Automate OData filter query equals

3. In this step, add a ‘Create HTML table‘ flow action to view Power Automate’s filtered SharePoint list items. Then, set the below details.

  • From: Take ‘Value‘ from dynamic content.
  • Columns: Select column options from the drop-down.
  • If it is a custom column, create the table below, as displayed in the image below.
HeaderValue
Trip Title
Travel Start Date
Travel End Date
Trip Status
Submitted By
Click on Dynamic Content -> Select values under dynamic content.
How to use Power Automate filter query equals Condition Operator

4. Now, the flow has been created. Click on Save and Test it Manually. Then, modify or create a new list item in the SharePoint list that we have specified.

5. The HTML table’s output will display all the SharePoint list items where ‘Trip Status’ equals ‘In Progress.’

Power Automate Filter Query Equals

This is how to use an OData filter query “equals” in the Power Automate Get Items flow action.

Power Automate Get items Filter Query Not equals

Let’s look at how to use Power Automate get items filter query not equals in a flow.

Similarly, based on the same SharePoint list, I will filter the SharePoint list items where ‘Trip End Date’ is not equal to ‘Today’s date.

Build a Power Automate cloud flow by following the steps that are mentioned above. But you only need to change the filter query syntax.

1. Inside the Power Automate’s ‘Get items’ flow action, take the filter query related to the requirement as placed in the code. Give the details like Site Address and List Name.

EndDate ne '@{utcNow()}'

Power Automate filter query syntax will only include a SharePoint list column’s ‘Internal name.’

Power Automate get items filter query not equals

2. Once the flow runs successfully, clicking on the HTML table will display all the SharePoint list’s filtered items, satisfying the condition the ‘Trip End Date’ is not equal to ‘Today.’

Power Automate get items filter query syntax not equals

This is how to work with Power Automate get items filter query not equals in a flow.

Power Automate Get Items Filter Query Greater than

Let me explain an example on Power Automate ‘Get items’ filter query greater than.

To explain the Power Automate Odata filter query greater than, I will use a SharePoint list containing columns like Admission ID, Full name, Age, etc. We wanted to filter out the SharePoint list items with’ Age’ greater than ’20’.

Power Automate Filter Query Greater than Operator

As mentioned above, follow the above instructions to create a flow but only change the filter query condition and syntax.

1. Open the ‘Get items’ flow action to set the Site Address, List Name, and Filter Query.

Filter Query: Age gt '20'

In the filter query syntax, provide the internal name of a SharePoint list column.

Power Automate OData Filter Query Greater than Operator

2. To view the filtered items of a SharePoint list, add a ‘Create HTML table‘ flow action. Then, set the custom column along with values, as shown below.

Power Automate OData Filter Query Greater than example

3. Then, the ‘HTML’ table outputs will display all the filtered items from a SharePoint list of items with ‘Age’ > ’20’ in a Power Automate flow.

Power Automate Odata filter query greater than

This is how to use Power Automate Odata filter query condition greater than in a flow.

Conclusion

This tutorial provides valuable insights on managing Power Automate get items filter queries and when to utilize them. The Power Automate tutorial delves into the Odata filter query syntax conditions, with examples from a SharePoint list.

  • Power Automate get items filter query equals
  • Power Automate Odata filter query not equals
  • Power Automate ‘Get items’ flow action filter query not equals

You may also like: