Answered

adding a static dropdown value to a dynamic dropdown that is dependent on the 3 other dropdowns

(0) Share

Report

Posted on by KevinGador

822 Super User 2025 Season 2

This is my code. Basically I have 3 more dropdowns that the choices for the office location is going to be based on the other 3 selected value but I want to add Any - no preferred location to my office location drop down.

this is the code that is not working.

ClearCollect(
 OfficeLocationCollection,
 Distinct(
 Filter(
 'DataSource',
 ONE= DataCardValueONE.Selected.Value &&
 TWO= DataCardValueTWO.Selected.Value &&
 THREE= DataCardValueTHREE.Selected.Value
 ),
 'Office Location'
 )
);
Collect(
 OfficeLocationCollection,
 { OfficeLocationLabel: "Any - No preferred location" }
);

it looks like this for my new formula. Its blank

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report
Hi @kej ,

You do not need the Collection - put this in the Items of your drop-down

Ungroup( Table( {Data: Table({Value: "Any - No Preferred Location"})}, { Data: Distinct( Filter( 'DataSource', One = DataCardValueOne.Selected.Value && Two = DataCardValueTwo.Selected.Value && Three = DataCardValueThree.Selected.Value ), 'Office Location' ) } ), "Data" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
KevinGador 822 Super User 2025 Season 2 on at

Like (0)

Report

did not work as intended other values are appearing as blanks.

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
@kej ,

It will work if your posted code is valid - does this return a list ?

Distinct( Filter( 'DataSource', One = DataCardValueOne.Selected.Value && Two = DataCardValueTwo.Selected.Value && Three = DataCardValueThree.Selected.Value ), 'Office Location' )

Was this reply helpful? Yes No
KevinGador 822 Super User 2025 Season 2 on at

Like (0)

Report

hello yes this is the current values of dropdown with that formula used

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report

@kej ,

This is not making a lot of sense to me presently as I use this structure regularly in prod apps. Assuming this is a classic Combo Box, are you displaying the Value field ?

Was this reply helpful? Yes No
KevinGador 822 Super User 2025 Season 2 on at

Like (0)

Report

oh im using a dropdown on this one not a combobox. will try to use a combo box with the same formula

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report

@kej ,

Yep - does not work in drop-down (I had never tried that before). I assume you are in Oz ?

Was this reply helpful? Yes No
KevinGador 822 Super User 2025 Season 2 on at

Like (0)

Report

this has worked perfectly in a combobox. I initially was using a drop down that's why it did not work. Thanks @WarrenBelz

Was this reply helpful? Yes No