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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Error Handling / Power Apps IsMatch/Fin...
Power Apps - Error Handling
Suggested answer

Power Apps IsMatch/Find word in Dropdown Items

(0) ShareShare
ReportReport
Posted on by VB-09101500-0
Power Apps IsMatch/Find word

Hi everyone,

I’m having trouble making this code work in the Items property of Dropdown 2. When I try to search using this dropdown, no list is generated.

Dropdown 1 uses a similar code but without the IsMatch filter line, and it works fine. In the DisplayFields of Dropdown 1, I’m using "DisplayName", and I can clearly see that some DisplayNames contain "Madrid".

So my question is: Why does IsMatch not work in Dropdown 2 to filter DisplayName for "Madrid", when the data is clearly present?

 

Main objective is to get the list from dropdown 1 but only those that contain "Madrid" in their DisplayName.

Dropdown1_Items.png
Dropdown2_Items.png
I have the same question (0)
  • Suggested answer
    MMcCloud Profile Picture
    MMcCloud 236 Super User 2025 Season 2 on at
    Power Apps IsMatch/Find word in Dropdown Items
    Good Morning,
     
    The way I have done this before is a 
     
    "String" in [whatever your value you are looking through]
     
    it can also be applied to
     
    "CASE" in ForAll(Items/Collection/Gallery.SelectedItems)
     
    This has allowed me to filter for specific parts of statements and to display fields only when specific terms are within a list or a string.
     
    So in your case "Madrid" in ForAll(DropDown1.SelectedItems)
     
    If this solves your question please select this as the solution if not feel free to follow up and I will try to get back and assist from there.
     
    Have a great day!
  • WarrenBelz Profile Picture
    WarrenBelz 151,135 Most Valuable Professional on at
    Power Apps IsMatch/Find word in Dropdown Items
    Another option which may be easier - your issue also may have been nothing in the search box 
    SortByColumns(
   Filter(
      Office365Users.SearchUserV2(
         {
            searchTerm: Self.SearchText,
            isSearchTermRequired: false
         }
      ).value, 
      !IsBlank(Department) && "Madrid" in DisplayName
   ),
   "DisplayName",
   SortOrder.Ascending
)
     
    Please ✅ 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 answering Yes to Was this reply helpful?
    Visit my blog     Practical Power Apps    LinkedIn  
  • WarrenBelz Profile Picture
    WarrenBelz 151,135 Most Valuable Professional on at
    Power Apps IsMatch/Find word in Dropdown Items
    A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.
     
    Please ✅ 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 answering Yes to Was this reply helpful?
    Visit my blog     Practical Power Apps    LinkedIn   

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
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 839 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 489

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 397 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans