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

836 Moderator

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)

Sort by

Verified answer

WarrenBelz 155,050 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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 836 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 155,050 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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 836 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 155,050 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@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 836 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 155,050 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@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 836 Moderator on at

Like (0)

Report
Copy link

Link copied!

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