Power Platform Community Forum Thread Details

Hi Team,

I am attempting to use the BC connector to search for records based on a name filter and have set up the filter as shown below.

Concatenate("contains(displayName,'",Topic.Var10,"')")

Could you please suggest how to handle case-insensitive "contains" filters in OData?

Issue: The record should be found regardless of whether I enter "test" or "Test."

Categories:

How to handle case sensitive in Text Filter