Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Copilot Studio - Copilot Studio Skills Development
Unanswered

How to handle case sensitive in Text Filter

(1) ShareShare
ReportReport
Posted on by 2
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:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >