cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
schwibach
Helper V
Helper V

How to make Lookup case-insensitive from SharePoint list

Hi,

 

I'm working with two SharePoint lists in a simple app.

 

In one list, I have the e-mail addresses in the title column and the name of the organisation the person belongs to in a separate column.

I want to show the organisation depending on the user who is logged in.
I managed to it with this "LookUp(Schulzugehörigkeit; Title = User().Email; Organisation)"
However, the LookUp is case-sensitive. I know all the e-mail adresses, but I don't know if the names are capitalised (some are). 

 

Is there a way to make this lookup case-insensitive to make it more robust?

 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

You use the Lower or Upper function to convert the Title and email addresses so the result in same case before the comparison:

LookUp(Schulzugehörigkeit; Lower(Title) = Lower(User().Email); Organisation)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

4 REPLIES 4
eka24
Super User
Super User

You use the Lower or Upper function to convert the Title and email addresses so the result in same case before the comparison:

LookUp(Schulzugehörigkeit; Lower(Title) = Lower(User().Email); Organisation)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Perfect!

Thank you so much!

Steve_CRP
Regular Visitor

This is actually unnecessary. 

 

Lookup in Sharepoint is already case insensitive.

(ref: https://powerusers.microsoft.com/t5/Building-Power-Apps/Can-Case-sensitive-look-up-can-be-done-in-Po...)

 

Furthermore, adding Lower(...) makes it non-delegable - so not only is it unnecessary, but it could be detrimental too.

I'll check that out... 

I think we had the problem in the past that filters in powerapps against user mails stored in SP lists did not work if the case did not match the user profile.

I'll look into it.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,059)