Answered

Make combobox results not case sensitive

(1) Share

Report

Posted on by Ziolno

Hi everyone,

I have a form I use for receiving at work, one of the fields the receivers populate is the manufacturer which is a text input field and which writes to a standard text column in Dataverse. In another app I use a combobox to filter items in a gallery based on the manufacturer. The combobox displays all the manufacturers in this column, but depending on how the receiver enters it, a manufacturer can show up multiple times based on if it is all caps, all lower, or proper case. Is there a way to have the combobox just display one instance per manufacturer and combine all case combinations? If the combobox could, i assume i could use that to filter the gallery with the “in function as opposed to matching the column to the combobox.selected.value?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report
You should be able to fix this by wrapping the function Upper or Proper into the combobox. Are you using Distinct for the Items property currently? The new formula would be something like this:

Sort(Distinct(YourData.Manufacturer,Upper(Manufacturer))),Result)

Was this reply helpful? Yes No
Ziolno 10 on at

Like (1)

Report

I was using the distinct function but not proper/upper.

This did make all the selections either proper or upper, but for some reason it is still listing multiple of the same spelling.

my formula is now as follows:

Sort(Distinct(collection,Proper(Manufacturer)),Value,SortOrder.Ascending)

image.jpg

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report

That's strange... I just tested the exact formula you mentioned and it works perfectly for me. Please see below the raw data displayed in a table, and the ComboBox results:

Are you sure there's not something else going on in your data? Is there a space or something after the duplicate "Arhaus"?

Was this reply helpful? Yes No
Ziolno 10 on at

Like (1)

Report

I agree that it is odd, I have not finished checking all of the rows that have this vendor listed as you may be correct and that may be the case.

as I do not have control over what they enter as we have many clients with various vendors so a simple pick from list will not do, is there a way to have a catchall that would avoid extra spaces in a line of text?

Was this reply helpful? Yes No
Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report
Let's try this, adding in the Trim function (https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-trim):

Sort(Distinct(collection, Proper(Trim(Manufacturer))), Value, SortOrder.Ascending)

Was this reply helpful? Yes No
Ziolno 10 on at

Like (1)

Report

Perfect this did it! Thanks so much!

Was this reply helpful? Yes No
LC-23100906-0 2 on at

Like (1)

Report

Dear all!

One doubt:

When I don't apply:

Sort(Distinct('[dbo].[Sujetos]';Proper('[dbo].[Sujetos]'[@Nombre]));Value;SortOrder.Ascending)

My list is the next one looking for "Luis":

But when I apply it is as follows:

Do you know why?

Was this reply helpful? Yes No