Dependent Combobox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone.

I 've a combobox with property

Combobox 1. Items property : Distinct(Table2,'Entity Name')

DSI : Table({Result: Parent.Default})

I need my 2 combobox value dependent on the basis of the combobox 1 selected value

Combobox 2 . Items Property : Filter(Table2,'Entity Name'=ComboBox1.Selected.Result),'Role Name'

DSI : Filter(Split(Parent.Default, "; "), !IsBlank(Result))

Update property of datacard : ComboBox2.Selected.Result

Label text for Displaying the multiselect value

Text : Concat(ComboBox2.SelectedItems,Result,Char(13))

the item property of my second combobox value is showing some error

Could anyone help me to fix it

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Mayuresh_Joshi 54 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous Use the below formula

Filter(Table2,'Entity Name'=ComboBox1.Selected.Result).'Role Name'

You have used "," instead of "."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Thanks, That worked !
But I'm selecting multiple values in the combobox, but only the last selected item is showing in label text
Text property of label : Text : Concat(ComboBox2.SelectedItems,Result,Char(13))

Was this reply helpful? Yes No
Mayuresh_Joshi 54 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous You can use below formula for multi-selection enabled dropdown case:

Set the items property of second Combobox to:
Filter(Table2,'Entity Name' in ComboBox1.SelectedItems.Result).'Role Name'

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , Thanks for replying
Still only one the last selected value is showing in my combobox

Was this reply helpful? Yes No
Ruben_Carvalho 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello everyone,
I am developing an app in PowerApps for my master's thesis, but I have an issue with the comboboxes. I have a database in an online Excel where I have a formatted table with 3 columns: type, brand, and model. I want the root of the choice made in the "cbTipoEquipamento_Clima" combobox, which references what appears in the first column of the "type" table, to display the brand only for that type in the "cbMarca" combobox. Additionally, I want the root of the brand choice to only display the models of that brand in the third combobox "cbModelo". In other words, I want the third combobox "cbModelo" to depend on the choice made in the second combobox "cbMarca," and the second combobox "cbMarca" to depend on the choice made in the first combobox "cbTipoEquipamento_Clima." However, I'm having trouble making it work. Does anyone know how to solve this?
Thank you to everyone who takes their time to help me.

Was this reply helpful? Yes No