web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter dropdown with s...

Power Apps

Answered

Filter dropdown with search box

(0) Share

Report

Report

Posted on by Radoslavov

817

Hi all, i've been searching for a formula to filter a dropdown field using a search bar (text input) filed.

The used case is: I have two SPO lists one is called Suppliers and another Materials.

Every material has a supplier attached to it (like Apple - Iphone, Windows - Surface, etc.)

In my PA this are two separate dropdown pointing to it's respective list.

dpdSupplier - Suppliers.Title

dpdProduct - Suppliers.Title

searchSupplier

searchMaterial

Connection in SPO is that Products has a lookup to Supplier

Supplier is a standalone list

I'm trying to filter only the dropdown options based on the search box text by Product/Supplier title

Thank you for the help, and regards.

Kiril

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @Radoslavov,

Do you want to filter the Supplier dropdown based on Supplier Title and Material dropdown based on the Material Title?

Could you please share a bit more about your need? You don't tell me which column in the Material you want to search for

If you want to filter the respective dropdown based on Title column from each list, please take a try as below.

1). Filter Supplier dropdown based on Supplier Title, set the dropdown Items property as below:

Filter(Suppliers, Title=SuppliersTitle_TextInput.Text).Supplier

2). Filter the Material dropdown based on Material Title, set the dropdown Items property as below:

ForAll(Filter(Material,Title=MaterialTitle_TexInput.Text).Supplier,Supplier.Value)

Was this reply helpful? Yes No
Radoslavov 817 on at

Like (0)

Report

Hi @v-qiaqi-msft this was actually great and worked.
I was trying to filter the drop down based on a search bar because i have 2000 suppliers, and each one have 1000 products, so i had two search boxes, one for supplier and another for products. So the user can type the name of the supplier and the dropdown will filter them, and at the same time the product dropdown will filter only products by this supplier, but allowing the user to user the second search box to search a product by name.

Thanks again for the help 🙂

Was this reply helpful? Yes No

Join the conversation