I'm currently using the API to search for users like this:

/_api/web/siteusers?$select=Id,Title&$filter=substringof('string', Title)

However, I have the problem that in this case, the substringof filter is case sensitive. So, when a usear searches for say "Charles" he gets all the Charles, but when he searches for "charles" he gets nothing.

Is there a way to do this, while at the same time making the filter case insesitive?

I guess I could do it like this:

/_api/web/siteusers?$select=Id,Title&$filter=substringof('string', Title) or substringof('String', Title)

And do two filters, one for string without capitalization and one with it.

But surely a better soulution would be possible?

1 Answer 1


You can use tolower or toupper

/_api/web/siteusers?$select=Id,Title&$filter=substringof(tolower('string'), tolower(Title))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.