cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
schwibach
Impactful Individual
Impactful Individual

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?

 

__________________________________
Please mark topics as solved if they are and give kudos to make people happy 🙂
Always interested to hear about solutions/problems in the education sector.
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

5 REPLIES 5
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.

schwibach
Impactful Individual
Impactful Individual

Perfect!

Thank you so much!

__________________________________
Please mark topics as solved if they are and give kudos to make people happy 🙂
Always interested to hear about solutions/problems in the education sector.
Steve_CRP
Frequent 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.

schwibach
Impactful Individual
Impactful Individual

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.

__________________________________
Please mark topics as solved if they are and give kudos to make people happy 🙂
Always interested to hear about solutions/problems in the education sector.

Lookup is case sensitive and that is the problem. That's why we try to find solution.
But you're right in other conclusion: this makes the Lookup non-delegable and this creates even worse problem.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,931)