cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Big_S
Post Patron
Post Patron

Dropdown searching

Hi Guys,
Thank you for viewing my message, does anyone knows how to execute searching using dropdown? i tried combo box but I prefer dropdown or any workaround?
dropdown.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions

@Big_S 

 

 
For doing so, you can add a text input control on your screen, now modify your dropdown control items as:
Filter(DataSource,StartsWith(ColName,TextInput1.Text))
 
Here, we are doing a filter based on text entered in the textbox. Please replace DataSource,ColName and TextInput1 with the actual names.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

v-yutliu-msft
Community Support
Community Support

Hi @Big_S ,

Could you tell me the data type of 'business unit','department','program'?

Could you show me the settings of the drop downs?

I assume that they are all text and the drop down's Items are tablename.

Try this formula:

Filter(tablename,business unit=drop down1.Selected.business unit,

                          department=drop down2.Selected.department,

                          program=drop down3.Selected.program)

 

Best regards,

Community Support Team _ Phoebe Liu

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3

@Big_S 

 

 
For doing so, you can add a text input control on your screen, now modify your dropdown control items as:
Filter(DataSource,StartsWith(ColName,TextInput1.Text))
 
Here, we are doing a filter based on text entered in the textbox. Please replace DataSource,ColName and TextInput1 with the actual names.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
v-yutliu-msft
Community Support
Community Support

Hi @Big_S ,

Could you tell me the data type of 'business unit','department','program'?

Could you show me the settings of the drop downs?

I assume that they are all text and the drop down's Items are tablename.

Try this formula:

Filter(tablename,business unit=drop down1.Selected.business unit,

                          department=drop down2.Selected.department,

                          program=drop down3.Selected.program)

 

Best regards,

Community Support Team _ Phoebe Liu

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Big_S
Post Patron
Post Patron

@v-yutliu-msft  @yashag2255 

Thank you for your suggestions guys im going to try all of it and keep you posted THANK YOU SO MUCH ❤️

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,740)