Answered

Trying to set dropdown for ALL option does not work

(0) Share

Report

Posted on by davismarist1198

Hi Currently trying to use my dropdown and add an "All" option to my list so I do not need to select a option to populate the gallery.

I have a button that is set up to a collect seen here: ClearCollect(colChoices, {Result:"All"}, Distinct(Tsp,'certifications?')). I now have a dropdown that has the option 'All' in it. However I am struggling to write the filter to capture "ALL" of it.

Here is my filter of the gallary

Filter(Tsp,Dropdown1_1.Selected.Result='All' || 'certifications?'=Dropdown1_1.Selected.Result) I do not understand why in this instance I have to use .result and not .value. Also I am not sure why my column is not working and I am not able to set it as a .value. I should not that I am importing this data from excel please let me know if you have any ideas. I have beem sifting for a answer and I am not seeing much. I will attach a picture of what this column looks like in excel.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @davismarist1198 ,

If you really want "Value", do this

ClearCollect( colChoices, {Value: "All"}, RenameColumns( Distinct( Tsp, 'certifications?' ), "Result", "Value" ) )

then your Filter

Filter( Tsp, Dropdown1_1.Selected.Value = "All" || 'certifications?' = Dropdown1_1.Selected.Value )

and you need double quotes around "All". To answer your question on Result - this is the output of the Distinct() Function

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
davismarist1198 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much Warren, one last question how could I implement one more filter for example I have a second drop down

I attempted this and it is not working

Filter(Tsp,
Dropdown1_1.Selected.Result= "All" || 'certifications?' = Dropdown1_1.Selected.Result && 'What is your current rank'=Dropdown1.Selected.Result)

The end goal is the rank column is required to have one entry but I would like to have the certification column remain ALL. Much thanks

Was this reply helpful? Yes No
davismarist1198 12 on at

Like
a
(0)

Report
Copy link

Link copied!

So currently this is what I have

Filter(Tsp,'What is your current rank'=Dropdown1.Selected.Result And
Dropdown1_1.Selected.Result= "All" || 'certifications?' = Dropdown1_1.Selected.Result)

The issue is I would like to always follow the first criteria, so if I select 'Senior Manager' in the first dropdown it will so all senior managers. I noticed that regardless of what I select in the first it will follow the second question. Please see a example in the picture. Ignore the combo boxs they are for testing purposes

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @davismarist1198 ,

Some bracketing on the and/or ad also double quotes around the selected value

Filter( Tsp, ( Dropdown1_1.Selected.Result = "All" || 'certifications?' = Dropdown1_1.Selected.Result ) && Dropdown1.Selected.Result = "What is your current rank" )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No