Hi @janla2112
Unfortunately, field type 'Calculated' cannot be used in the filter query.
But you can use toLower() function in filter query. If you want to use function, please edit it in ‘Expression’, otherwise the flow will recognize it as plain text.
And it seems that your filter query expression is in a wrong structure. Please make sure you put the field name of a column in front of ‘eq’. Only after ‘eq’ can you put expression or dynamic content.
The syntax for the operator ‘eq’ in filter query is:
eq: Test whether a field is equal to a constant value
For more info about operators in filter query, please go to the link: OData comparison operator reference - Azure Cognitive Search | Microsoft Docs
The step is for your reference:
Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
