Filter by Content Type using Get Items in Power Automate. Microsoft Office 365 image 2

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.

Filter by Content Type using Get Items in Power Automate. Microsoft Office 365 image

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?

Filter by Content Type using Get Items in Power Automate. Microsoft Office 365 image 1

Then I tried out the following Filter Query

Content Type eq 'Contact'

as shown below

Filter by content type

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

Filter by Content Type using Get Items in Power Automate. Microsoft Office 365 image 3

By 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 contact@veenstra.me.uk.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: