Filter combobox with radio buttons

(0) Share

Report

Posted on by R Bakker

725

Hi everyone

I didn't think I would get stuck on this one.

I have a gallery which is filtered by a Combobox that is populated by a multiselect lookup column and radio buttons which is populated by a choices column, both from the same Sharepoint list. What I want is that the radio buttons filter the Combobox. That way the Combobox will only give results that conform to the radio buttons.

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-yujincui-msft on at

Like (0)

Report
Hi @Corissandageri ,

Do you want to filter ComboBox with radio button?
I have made a test for your reference.
1. Here is my SharePoint list.
2. Select the Radio Control and apply the following formula on its items property as:

Choices(ProductList.Category)

3. Select the ComboBox Control and apply the following formula on its items property as:

LookUp(ProductList,Radio1.Selected.Value=Category.Value).Product

Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

Hi
Thank you for your time, I'm not getting any errors, but I am only getting a single result. Would this have something to do with the lookup column being a multi select?

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (0)

Report

Hi @Corissandageri ,

The lookup column in my List also allows multiple selection, if it is convenient, could you please provide an example of the data source? (no sensitive information)

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

Don't know if this helps

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report
Hi @Corissandageri ,

Please try the following formula:

Ungroup(Filter(datasource,Radio1.Selected.Value=ReportStatus.Value).PeopleInvolved,"PeopleInvolved").Value

Best Regards,
Charlie Choi

Was this reply helpful? Yes No