web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / combobox search with a...
Power Apps
Unanswered

combobox search with accents and without accents

(0) ShareShare
ReportReport
Posted on by khaoula 25
I have a combobox modern for search group members if a name or first name has an accent or a comma in the system, we will not find the person if we forget to write it, for example I can’t find "Stéphane BOURDILA" by writing "Stephane BOURDILA". do you help me ?
Categories:
Building Power Apps
I have the same question (0)
  • SaiRT14 Profile Picture
    SaiRT14 1,990 Super User 2025 Season 2 on at
    Power Apps does not have a built-in function for removing accents,
  • WarrenBelz Profile Picture
    WarrenBelz 153,413 Most Valuable Professional on at
    You posted the same question on this thread and your last response is correct. They are different characters (as different as a and b) and you need to think of all the possible ones that may be used and substitute them for the ones you want to use. Where are you using the code you posted ?
    If you do this OnChange of the Text box (remove the ones not on the user's keyboard)
    UpdateContext(
   {
      varText: 
          Substitute(
         Substitute(
            Substitute(
               Substitute(
                  Substitute(
                     Substitute(
                        Substitute(
                           Substitute(
                              Substitute(
                                 Substitute(
                                    Substitute(
                                       Substitute(
                                          Substitute(
                                             Substitute(
                                                Substitute(
                                                   Substitute(
                                                      Substitute(
                                                         Substitute(
                                                            Substitute(
                                                               Substitute(
                                                                  Substitute(
                                                                     Substitute(
                                                                        Substitute(
                                                                           Substitute(
                                                                              Substitute(
                                                                                 Substitute(
                                                                                    Substitute(
                                                                                       Substitute(
                                                                                          Substitute(
                                                                                             Substitute(
                                                                                                Substitute(
                                                                                                   Substitute(
                                                                                                      Self.Text;
                                                                                                      "À";
                                                                                                      "A"
                                                                                                   );
                                                                                                   "Â";
                                                                                                   "A"
                                                                                                );
                                                                                                "Á";
                                                                                                "A"
                                                                                             );
                                                                                             "Ç";
                                                                                             "C"
                                                                                          );
                                                                                          "È";
                                                                                          "E"
                                                                                       );
                                                                                       "É";
                                                                                       "E"
                                                                                    );
                                                                                    "Ê";
                                                                                    "E"
                                                                                 );
                                                                                 "É";
                                                                                 "E"
                                                                              );
                                                                              "Î";
                                                                              "I"
                                                                           );
                                                                           "Í";
                                                                           "I"
                                                                        );
                                                                        "Ô";
                                                                        "O"
                                                                     );
                                                                     "Ó";
                                                                     "O"
                                                                  );
                                                                  "Ù";
                                                                  "U"
                                                               );
                                                               "Û";
                                                               "U"
                                                            );
                                                            "Ú";
                                                            "U"
                                                         );
                                                         "à";
                                                         "a"
                                                      );
                                                      "â";
                                                      "a"
                                                   );
                                                   "á";
                                                   "a"
                                                );
                                                "ã";
                                                "a"
                                             );
                                             "ç";
                                             "c"
                                          );
                                          "è";
                                          "e"
                                       );
                                       "é";
                                       "e"
                                    );
                                    "ê";
                                    "e"
                                 );
                                 "é";
                                 "e"
                              );
                              "î";
                              "i"
                           );
                           "í";
                           "i"
                        );
                        "ô";
                        "o"
                     );
                     "ó";
                     "o"
                  );
                  "õ";
                  "o"
               );
               "ù";
               "u"
            );
            "û";
            "u"
         );
         "ú";
         "u"
      )
   }
);;
Reset(Self)

    and then make the Default of the Text Box
    varText

    it should work

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    Buy me a coffee
  • khaoula Profile Picture
    khaoula 25 on at
    @WarrenBelz thanks for helping me but the same thing did not give a result
  • khaoula Profile Picture
    khaoula 25 on at
    @WarrenBelzI write this code ..... onchange of  combobox ?? here’s how I want 
    ​​​​​​​​​​​​​​
  • WarrenBelz Profile Picture
    WarrenBelz 153,413 Most Valuable Professional on at
    @khaoula​​​​​​​
    I was going off your original post with a Text box - a Person combo box is much more challenging as the search function is inbuilt. This (sort of) works in the Items of a Classic Combo Box
    With(
   {
      _Text: 
      Substitute(
         Self.SearchText;
         AllYourSubstituteCodeHere
      )
   },
   Filter(
      Office365Groups.ListGroupMembers(
         "YourGroupIdHere";
         {top: 10}
      ).value;
      StartsWith(
         displayName;
         _Text
      )
   )
)

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    Buy me a coffee
  • khaoula Profile Picture
    khaoula 25 on at
     
    I don’t want to delete I just want it to read the same for example "e" read "é"
  • WarrenBelz Profile Picture
    WarrenBelz 153,413 Most Valuable Professional on at
    Sorry I don't understand your comment - you need to put the substitute code and your group's ID in the blue areas.
  • khaoula Profile Picture
    khaoula 25 on at
    @WarrenBelz here the capture I write in search of TextInput just "ka" it displays the gallery name I want to do the same thing in combobox but I don’t want to use gallery and TextInput just combobox ​​​​​​​
  • khaoula Profile Picture
    khaoula 25 on at
    ​​​​​​​
    and here it is a combobox just I make a small modification for change model 
  • WarrenBelz Profile Picture
    WarrenBelz 153,413 Most Valuable Professional on at
    That is why I gave you the code for the Items of the Combo Box.

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

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 380 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 340

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 333 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans