Skip to main content

Notifications

Community site session details

Community site session details

Session Id : bUpWYupPkHLKdBBdftkBGa
Power Apps - Building Power Apps
Unanswered

how to filter a combobox, which has capital letters, accents and other characters and which make the filter difficult

Like (0) ShareShare
ReportReport
Posted on 24 May 2021 22:09:37 by

How about, thank you very much for any information you can give me what happens is that I have a combobox whose data resource is connected to a sharepoint list

 

itemscombobox.PNG

 

For the search field I am filtering the Title column, but as I mentioned, the fields have uppercase, names with accents, so if the user enters the names in lowercase or does not say the accents, the combobox does not filter well, how is it possible to do that the combobox filters correctly so that if the user does not enter these characters the combobox can still filter

 

 

And I ask you another question, when I connect the combobox to these sharedpoint lists, how can I make it so that it only brings me a maximum of 10 or 5 fields when it searches for a field. 

 

Thank you so much for everything

 

Categories:
  • v-bofeng-msft Profile Picture
    on 28 May 2021 at 01:21:40
    Re: how to filter a combobox, which has capital letters, accents and other characters and which make the filter difficult

    Hi @Anonymous :

    I've made a test and verified that this method is effective:

    v-bofeng-msft_0-1622164866732.png

    Do you have any special circumstances that have not been mentioned before?

    Best Regards,

    Bof

  • Community Power Platform Member Profile Picture
    on 27 May 2021 at 15:36:17
    Re: how to filter a combobox, which has capital letters, accents and other characters and which make the filter difficult

    @v-bofeng-msft  many many thannks Yes, this parenthesis was missing a thousand apologies :(, thank you very much for your solutions, it still does not filter me, this has me a bit frayed 😞 , I put the name without the accent so that it shows it to me but the combobox still does not filter, necessarily You must place the check mark if I want you to filter those surnames but still, thank you very much for trying to help me 

     

     

  • v-bofeng-msft Profile Picture
    on 27 May 2021 at 01:12:32
    Re: how to filter a combobox, which has capital letters, accents and other characters and which make the filter difficult

    Hi @Anonymous :

    You have lost a ")".

     

    Filter(
    UsXXX.SearchUser(),
    Substitute(Substitute(Substitute(Substitute(Substitute(Lower(ComboBox1.Selected.DisplayName),"á","a"),"é","e"),"í","i"),"ó","o"),"ú","u")
    in
    Substitute(Substitute(Substitute(Substitute(Substitute(Lower(Title),"á","a"),"é","e"),"í","i"),"ó","o"),"ú","u")

     

    Best Regards,

    Bof

  • Community Power Platform Member Profile Picture
    on 26 May 2021 at 14:28:32
    Re: how to filter a combobox, which has capital letters, accents and other characters and which make the filter difficult

    @v-bofeng-msft  

    Thank you very much for answering, let me tell you, the case of uppercase and lowercase was used for the combobox that is connected to the sharepoint file risk data resource.

     

    The other combobox has office 365 users as data resources, how can I make this formula work that you indicate with this combobox? , is this formula used in the SearchFIelds event or in the Items? , thank you very much for any information

    filtro en combobox.PNG

  • v-bofeng-msft Profile Picture
    on 26 May 2021 at 01:57:10
    Re: how to filter a combobox, which has capital letters, accents and other characters and which make the filter difficult

    Hi @Anonymous :

    Please try:

    Filter(
     FichadeRiesgos,
     Substitute(Substitute(Substitute(Substitute(Substitute(Lower(TextInput2.Text),"á","a"),"é","e"),"í","i"),"ó","o"),"ú","u") in Substitute(Substitute(Substitute(Substitute(Substitute(Lower(Title),"á","a"),"é","e"),"í","i"),"ó","o"),"ú","u")
    )
    
    
    
    

    Best Regards,

    Bof 

  • Community Power Platform Member Profile Picture
    on 25 May 2021 at 15:51:30
    Re: how to filter a combobox, which has capital letters, accents and other characters and which make the filter difficult

    @v-bofeng-msft Thank you very much for answering, Thanks to you I was able to solve the case of upper and lower case letters, but is there any function that helps me to make the correct filter for when there are names with accents? , is that if I look for the name and I do not put an accent on it, it does not appear, I would like that if the user does not place these accents in the names, the combobox will also filter the name, I will show you an image of what happens to me (I am currently using Office 365 Users as a data source )

    AppEscritorio_Gestion_incidentesV2 - Guardada (no publicada) - Power Apps y 4 páginas más - Trabajo_ Microsoft_ Edge 2021-05-25 10-45-51.gif

    thank you very much for everything equally       

  • v-bofeng-msft Profile Picture
    on 25 May 2021 at 01:57:40
    Re: how to filter a combobox, which has capital letters, accents and other characters and which make the filter difficult

    Hi @Anonymous :

    Firstly,are you unable to get the correct result due to case sensitivity?

    If so, I suggest you use case-insensitive operators, such as replacing "exactin" with "in".

    You could also try the Lower function,for example:

    Filter(
     FichadeRiesgos,
     Lower(TextInput2.Text) exactin Lower(Title)
    )

     Secondly,do you only want to get 5-10 specified columns?

    If so,you could try ShowColumns function,for example:

    ShowColumns(
     Filter(
     FichadeRiesgos,
     Lower(TextInput2.Text) exactin Lower(Title)
     ),
    "Column1",
    "Column2",
    "Column3",
    ……
    )

    Best Regards,

    Bof

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 89 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 60

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard