Categories: Microsoft 365

Filter by Content Type using Get Items in Power Automate.

In a comment on my Filter Query on Get Items in the SharePoint connector post I was asked about how to filter by content type.

Filter by content type

This week I was asked about how you can filter by content type. To filter by content type I tried enabling the experimental preview features, but that didn’t have content type listed there.

Looking at the output from REST API I could query by ContentTypeId. Querying by Content Type ID could make sense if I wanted to include child content types. Do you remember these long number get longer and longer the more levels of parent/child you have?

Then I tried out the following Filter Query

Content Type eq 'Contact'

as shown below

and now my flow is returning the right items selecting just the items using the Contact content type.

Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using

Recent Posts

8 top reasons to use Dataverse or SharePoint lists in the Power Platform

Why would you use Dataverse, if SharePoint lists gives you the option to avoid premium…

6 days ago

Filter by calculated fields in SharePoint using Power Automate

When you read items from a SharePoint list and you want to filter by calculated…

1 week ago

Expected String but got Null, when calling a flow from a Model Driven app

A few weeks ago I looked at calling flows from model driven apps. And for…

1 week ago

Get all your broken connections using Power Automate

To get all your broken connections in the Power Platform can be a challenge. In…

2 weeks ago

Customer Voice a.k.a. Forms Pro the database behind the magic

If you call Customer Voice still Forms Pro or not, have you ever looked into…

2 weeks ago

Many running flows in Power Automate

Recently I noticed that some of my flows end up with many running flows. Types…

3 weeks ago