adding ALL option in dropdown menu to unfilter gallery

[nerdyplayer]

Been watching/ searching here for help. I know I am doing something wrong.

I have a drop down menu, and I want to add an ALL option to allow users to see all options before filtering down to more specific columns. I just cannot seem to get the code right. i reversed to a previous version to undo my screwup. 

I did make a collection table (ColCatagory) of my sharepoint list. 

FOS dropdown-

Item: 

[code]Distinct('Learning Catalog','Field Of Study')[/code]

Gallery-

Items:

[code]Filter('Learning Catalog','Field Of Study'='FOS dropdown'.Selected.Value)[/code]

[v-mengmli-msft]

Hi @nerdyplayer ,

Please try this.

1/Allow empty selection of drop down.

2/ Let Default of drop down blank.

3/OnSelect of "ALL" button.

Reset('FOS dropdown')

4/Items of gallery.

Filter('Learning Catalog','Field Of Study'='FOS dropdown'.Selected.Value||IsBlank('FOS dropdown'.Selected.Value))

Best regards,

Rimmon

[bgrgic1]

@nerdyplayer  Hi, if you want to have the "All" option, you will need to create a collection first (you can perhaps do it on OnVisible event of the screen) like this:

ClearCollect(collDropdownOptions,{Value:"All"},Distinct('Learning Catalog','Field Of Study')).

Set the Items for dropdown to collection collDropdownOptions.

Your filter would look like this then

Filter(('Learning Catalog','Field Of Study'='FOS dropdown'.SelectedText.Value Or 'FOS dropdown'.SelectedText.Value="All")

[nerdyplayer]

Thanks Mengmli.

the codes work, just 2 things. 

It's not a button, it is a drop down. So, when i added it to onselect the dropdown now flashes as it resets the filter.

Trying to add an ALL within the selection.

From what you showed me, I could add a reset filter button on the side to achieve the same results.

[nerdyplayer]

I have a collection created already (ColCatagory)

Would I still use the ClearCollect in the beginning?

[bgrgic1]

You can, or you can just change the place where you collect the choices first, so in you case I suppose it would be

Collect(ColCatagory,{Value:"All"},Distinct('Learning Catalog','Field Of Study')).

ClearCollect just removes everything first in case there is already something in the collection.

[v-mengmli-msft · Accepted solution]

Hi @nerdyplayer ,

Sorry. I didn't notice that "All" is an option in drop down.

Just like method @bgrgic1 provided, you can create a collection contains "all" option for dropdown.

There is also another method for your reference which doesn't need to create a collection.

Please try this:

1/Items of drop down.

Split(Concatenate(Concat(Distinct('Learning Catalog','Field Of Study'),Value,","),",","All"),",")

2/Items of gallery.

If('FOS dropdown'.Selected.Value="All",'Learning Catalog',Filter('Learning Catalog','Field Of Study'='FOS dropdown'.Selected.Value||IsBlank('FOS dropdown'.Selected.Value)))

_______________________________________________________________________________________________________________________

If my answer helps you solve the problem, please accept it as a solution.

Best regards,

Rimmon