How to write Filter query in Power Automate on Person or Group Column

Power Automate, the popular workflow automation tool from Microsoft, provides powerful capabilities for filtering and manipulating data. In this blog post, we’ll delve into writing filter queries specifically for Person or Group columns in Power Automate.

Understanding Person or Group Columns:

Person or Group columns are commonly used to store user information, such as the author, manager, or assignee of a document or item. These columns hold references to user objects and provide properties like email, display name, and more. To filter data based on Person or Group columns, we need to expand the User object and target the relevant user properties.

To filter data in Power Automate on a Person or Group column, follow these steps:

1. Determine the specific Person or Group column you want to filter on. For our example, we’ll use the “Author” column.

2. To access user properties, expand the User object associated with the column. Use the following syntax:

Author/Email
Author/DisplayName

3. To filter based on the Person or Group column, use the following syntax:

Author/Email eq 'xyz@xyz.onmicrosoft.com'
Author/DisplayName eq 'name'

Replace the email address and display name with the values you want to filter on.

Conclusion:

In this blog post, we discussed the process of expanding the User object and provided examples of constructing filter queries using both email and display name properties.