If CountRows(Combox1.SelectedItems)>1 then a specific value is display in another dropdown

(0) Share

Report

Posted on by SD29

152

Hi,

I have combo box and drop down in my app. Combo box and Dropdown is Cascaded which means where based on values selected in combo box, dropdown list is displayed.

Example:-

Combo box has below values:

Team A

Team B

Unknown.

Drop Down has below values

Person 1

Person 2

When I selected Team A in combo box, drop down displays Person 1

Combo Box has multi selection property as True. My query is- if I select more than 1 values from combo box, Drop down should display NA.

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

SD29 152 on at

Like (0)

Report

It will be really helpful if anyone can help me with this issue. I am really stuck with this since days.

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report
@SD29 ,

Try:
If(CountRows(ComboBox1.SelectedItems)>1,["N/A"],["A","B"])

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
SD29 152 on at

Like (0)

Report

Thanks for the response @Gochix , ["A","B"] will be hardcoded but my sharepoint list columns can have multiple values added in future. Hence, can you share solution based on dynamic approach. So that in future I am not required to change code.

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report

@SD29 ,

The ["A", "B"] was placed there just as an example for you. If you explain what's the logic then we can have a look into it. The original request was how to achieve displaying "N/A" if multiple values selected in the ComboBox.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
SD29 152 on at

Like (0)

Report

@Gochix , Currently
Combo box has below values:
Team A
Team B
''
''
Unknown.

Drop Down has below values

Person 1
Person 2
''
''
NA
'' this sign signifies more values listed in the column.

Currently When I select Team A in combo box, drop down displays Person 1 - Cascading relationship is created.

I want to build a dynamic logic like if I select more than 1 values from combo box example-Team A & Team B then Drop down should only display NA.

So if I use your below solution, what should I replace ["A","B"] with ?
Should I be applying this in Default property of Dropdown ?
If(CountRows(ComboBox1.SelectedItems)>1,["N/A"],["A","B"])

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report

@SD29 ,

Could you share what you have currently in the Items property of the DropDown?

Knowing this I can help more.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
SD29 152 on at

Like (0)

Report

For DropDown Items Property below is the query-
Filter('Team Lookup',Team=ComboBox1.Selected.Value)

where Team Lookup is the SharePoint List ComboBox1 is the name for Combo Box in app. Person Detail Column values are displayed in App Dropdown

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report
@SD29 ,

Thanks, so your code should be:

If(CountRows(ComboBox1.SelectedItems)>1,["N/A"],Table({Value:LookUp('Team Lookup',Team=ComboBox1.Selected.Value).'Person Detail'}))

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
SD29 152 on at

Like (0)

Report

Thanks for the code. Do I need to write this code in Default property of DropDown Card or Default property of DataCardValue1 ?

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (1)

Report

@SD29 ,

You can write it in the Items property of the DropDown.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No