Unanswered

How to add blank to DropDown List and Not Filter when blank is selected?

(0) Share

Report

Posted on by chrislamb2012

Hi yall, thanks again for all your help these past few days.

Im coming in with another question, that I know is simple, but when I try to apply the previously threaded solutions or youtube tutorials I still cannot seem to get it to work.

As you can see I have a dropdown list helping to filter a gallery before a textinput is used to search. This dropdown list is populated with the distinct values of the "Plant" column, and Im trying to add a blank in the beginning of the dropdown list such that if a user does not know the Plant number, they can search the entire gallery.

Additionally, I've noticed when I first open the page that when there is no value selected in the DDL, no information loads in the gallery. So I'm trying to guarantee that there doesnt necessarily NEED to have a value selected in the DDL in order to still search the gallery.

This has been my current attempt, which i've taken from another thread:

Ungroup(

Table(

{myMenuOptions: Table({DDValue: Blank()})},

{myMenuOptions: Filter('Dropdown Values', DDType="Plant").DDValue}

"myMenuOptions"

)

Some additional relevant information, my Gallery name is "DataGallery", the column for the Plant number is "Plant", and the DDL name is "PlantDropDown"

Thanks again for yalls help!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-bofeng-msft on at

Like (1)

Report
Hi @chrislamb2012 ,

You could set the dropdown control's AllowEmptySelection property to true and clear it's default property then it will not select any option by default.

And then you could use this formula to do the filter:

Filter( DataSource IsBlank(DropDown.Selected) || ColumnName=DropDown.Selected.ColumnName )

Best Regards,

Bof

Was this reply helpful? Yes No
chrislamb2012 30 on at

Like (0)

Report

Hi @v-bofeng-msft, I already had AllowEmptySelection set to true, so I continued with your strategy but its still throwing errors.

The formula you proposed is supposed to be in the "Items" section of the Drop Down, right? I proceeded with this:

Filter(
'MnS Summary V5',
IsBlank(PlantDropDown.Selected) || ColumnName=PlantDropDown.Selected.Value
)

Here 'MnS Summary V5' is the entire SharePoint List, and PlantDropDown is the name of the DropDownList.
I also tried using the extensions .Value, .'Plant', and .Plant on the end of PlantDropDown.Selected, but none of them worked.

Please advise and thanks again for your time

Was this reply helpful? Yes No
VishalJhaveri 1,167 Moderator on at

Like (0)

Report

You need to create a collection in which you need to store the items you need to display in Dropdown along with BLANK in the Dropdown.
This will help you out in displaying Blank along with Items.

Was this reply helpful? Yes No
chrislamb2012 30 on at

Like (0)

Report

Hi @v-bofeng-msft, sorry to bother you again, but Im still working on this issue. Are you willing to provide any advice?

Was this reply helpful? Yes No
chrislamb2012 30 on at

Like (0)

Report

Hi @VishalJhaveri

I've tried your method and this is my current circumstance
Then in the Items line of the DropDown I have colLocalUniform

It has seemed to work well, but has created a new issue where the other drop down list items arent showing visually> The strange part though is that I know they proper information is there, because if I select one of the "blank" options in the DDL, it still filters my gallery properly.

Any advice?

Was this reply helpful? Yes No