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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,919)