The field of type taxonomyfieldtype cannot be used in the query filter expression in SharePoint Online visual studio workflow

This SharePoint tutorial, we will disucss, how to fix error The field <field name> of type taxonomyfieldtype cannot be used in the query filter expression. The error comes when we try to filter based on taxonomy field type in SharePoint Online visual studio 2015 workflow.

Recently we were working in a visual studio 2015 workflow for our SharePoint online site. In that workflow, we were trying to filter data from a SharePoint online list. We were filtering based on a taxonomy field type through Rest API by using a httpsend workflow activity. But it gave me an error like below:

“The field <field name> of type TaxonomyFieldType cannot be used in the query filter expression”. The error looks like below:

The field <field name> of type taxonomyfieldtype cannot be used in the query filter expression

We were using the below URL:

https://oursite.sharepoint.com/sites/MyDev/_api/web/lists/getByTitle(‘ourlistname’)/items?$filter=FieldName eq Execution

The field <field name> of type taxonomyfieldtype cannot be used in the query filter expression

We can not filter based on the taxonomy field like above. So we can write like below:

Here we have used 3 variable inside our workflow:

• currentWebUri: This will give the current site URL.
• ourListGuid: This will give our current list guid
• CurrentItemTaxonolyFieldWssId: This will give the WssId of the column which we want to use in the filter condition.

We have to use CAML like below:

currentWebUri + "_api/lists(guid\'" + ourListGuid + "\’)/GetItems(query=@v1)?@v1={\"ViewXml\":\"<View%20Scope=\’RecursiveAll\’><RowLimit>1</RowLimit><Query><Where><Eq><FieldRef%20Name=\’FieldName\’%20LookupId=\’True\’/><Value%20Type=\’Integer\’>" + CurrentItemTaxonolyFieldWssId + "</Value></Eq></Where></Query></View>\"}"

If you are using inside a visual studio 2015 workflow using httpsend activitity make sure to use this as a POST request rather than a Get request.

You may like following SharePoint tutorials:

• Difference between designer workflow and visual studio workflows
• SharePoint online visual studio workflow issue The ExpressionTranslationBuildTask task failed unexpectedly
• SharePoint Approved and Rejected buttons not appearing in task form in Visual Studio 2015 workflow
• Workflow association form sharepoint not appearing visual studio 2015 while developing workflow for SharePoint online Office 365 site
• Cannot cast LValue expression to type Microsoft.Activities.DynamicValue error in visual studio 2015 workflow
• SharePoint Hosted Add-in: Send Email using visual studio workflow
• SharePoint online visual studio 2015 workflow variable not available in various scopes
• Invalid text value. A text field contains invalid data error in visual studio 2015 workflow in SharePoint online
• Create Workflow Activity using Visual Studio 2010 in SharePoint 2010
• Create a Sequential workflow using visual Studio 2010 in SharePoint 2010

This SharePoint tutorial helps us to solve an error The field <field name> of type TaxonomyFieldType cannot be used in the query filter expression.