Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Dropdown with Search/Filter as user inputs text

Like (1) ShareShare
ReportReport
Posted on 13 Sep 2024 01:25:48 by 8
Hi,
I've created a simple app that will allow our Order Entry team to select a customer and then retrieve their pricing.

At the moment I have a dropdown box linked to the Customer SharePoint List with the dropdown items set to Customer Name.
 

They select the customer from the dropdown list and press "get pricing" button and a data table linked to the Price SharePoint list is filtered based on the corresponding Price Group.
 
Customer    
     
Customer Name Price Group  
ABC Customer QM  
ABCD Customer BB  
EFG Customer QM  
HIJ Customer CC  
     
     
Price    
     
Price Group Product Price
QM Product A 1.00
QM Product B 2.00
QM Product c 3.00
BB Product A 1.20
BB Product B 2.20
BB Product c 3.20
CC Product A 1.50
CC Product B 2.50
CC Product c 3.50
 

It works ok except the Customer SharePoint list contains 500+ customers which makes the dropdown list very long.

I'd like to have a dropdown where the user can type the customers name and the options in the dropdown box filter by what they are typing.

For example if they typed "ABC" then they would see customers ABC Customer & ABCD Customer in the drop down. Or, if they typed "IJ" they would see HIJ Customer in the dropdown.

Please can someone point me in the right direction on how to achieve this?
Categories:
  • Suggested answer
    FLMike Profile Picture
    FLMike 27,286 on 13 Sep 2024 at 02:21:42
    Dropdown with Search/Filter as user inputs text
    Hi
     
    No worries, now it depends, on if they expect them to type what the customers name StartsWith (with is an expression) or just somehere "in" the string as they are different
     
    So let's say you have the dropdown and a text input
     
    The Items would look like this
    <=== NOTE here I have .Selected but if you have .Selected.Role or someother property you have to use it, I just used .Selected without knowledge of your current filter
     
    Filter(
           MySource, 
            ( IsBlank(MyDropDown.Selected) Or MyColumn = MyDropDown.Selected   )
            And
            MyCustomerNameColumn StartsWith(TextInput.Text)
     
    );
     
    OR if instead you want to check if the string is IN the customers name change above to
     
    TextInput.Text in MyColumnNameColumn
     
    and done.
     
    If this helps please mark as the answer
     
     
     

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,696

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,456

Leaderboard
Loading started