2 Approaches to filtering and selecting data from Microsoft Graph in Power Automate

Within my series about Microsoft Graph in the Power Platform I’ve collected data using customer connectors and HTTP actions but how do we filter and select data in Microsoft Graph?

Filter Action To filter our data that we get returned we could use the filter action. But that would mean collecting too much data before

Table of Contents

Filter Action

Filtering data in Power Automate

Microsoft Graph and filtering

Open full article

More about Microsoft Graph in Power Automate are using OData filters

The two approaches to filtering and selecting data from Microsoft Graph in Power Automate are using OData filters or the Get Items action with a filter query.

When using OData filters, you can use an expression such as “startswith(name,'Smith') eq true” which will return any results where the name begins with Smith. You can also add additional parameters to refine your search further, such as '$filter=contains(name, 'John')'. This makes it easier to find specific items that match certain criteria quickly and efficiently.

The other approach is to use the Get Items action with a Filter Query parameter. This allows you to specify conditions for what records should be returned by querying based on values of one or more properties in the result set. For example, if you wanted to get all users whose displayName starts with "Smith", then your filter query would look like this: "$filter=startsWith(displayName,'Smith')". With this approach, it's possible to build complex queries that involve multiple properties and conditions which can help narrow down your results even further.

• Use query parameters to customize responses - Microsoft Graph

  Jan 4, 2023 — Use the $filter query parameter to retrieve just a subset of a collection. For guidance on using $filter , see Use the $filter query parameter ...

• Use the $filter query parameter - Microsoft Graph

  6 days ago — Learn how to use the $filter OData query parameter and its operators against different types of properties in Microsoft Graph.

• Build advanced queries in Microsoft Graph with $count, $filter ...

  May 19, 2020 — Build advanced queries in Microsoft Graph with $count, $filter, $search, and $orderby · Select the beta endpoint · Add $count=true in the ...

• Use the Microsoft Graph API
  Aug 8, 2022 — In this article. OData namespace; Call a REST API method; HTTP methods; Version; Resource; Query parameters; Tools for interacting with ...