Filter SharePoint List on Managed Metadata field

[Gottijay2000]

i'm trying to filter a SharePoint list and retrieve item that match a certain in a managed metadata column. This field accepts multiple values.   i have seen in some articles that odata filter query are not currently supported. Is there a way of doing this in flow?

[v-litu-msft · Accepted solution]

Hi @Gottijay2000,

You could consider using Send an HTTP request to SharePoint action and api to filter the managed metadata field, there is a document that introduces how to use it, hope something could help you:

https://itgeneralisten.wordpress.com/2018/10/09/filter-a-sharepoint-list-on-a-managed-metadata-field...

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SchneidAIR]

Get items and OData-Filter not possible with Managed Metadata Columns. Actually you have to use HTTP Request to SharePoint with CAML Query Syntax.

Please also see

Managed Metadata column is supported in OData Filt... - Power Platform Community (microsoft.com)

But please consider, that Filtering on Mananged Metadata Columns (TaxonomyFieldType) with the Term Label will not work in multilingual Termsets with multilingual Term Translations.  

Also beware when you attempt to use the Term GUID instead. This will not work, you will get no filter results.

I dont know why....

But instead you can use a HTTP Request to SharePoint with a CAML Query on Lookup-Filtertype on the Terms WSSID (this would be generated based of the local TaxonomyHiddenList of the Site Collection).

This Filter will also work in multilingual Taxonomy Environments on the same site...

Example

_api/web/Lists/GetByTitle('Responsibilities')/GetItems(query=@v1)?@v1={"ViewXml":"<View><Query><Where><And><And><Eq><FieldRef LookupId='TRUE' Name='imsProcess' /><Value Type='Lookup'>@{body('Get_file_properties')?['imsProcess']?['WssId']}</Value></Eq><Eq><FieldRef LookupId='TRUE' Name='imsDepartment' /><Value Type='Lookup'>@{body('Get_file_properties')?['imsDepartment']?['WssId']}</Value></Eq></And><Eq><FieldRef LookupId='TRUE' Name='imsLocation' /><Value Type='Lookup'>@{body('Get_file_properties')?['imsLocation']?['WssId']}</Value></Eq></And></Where></Query></View>"}