Reset Gallery to show all data/remove filter

[grantreid]

I gave a gallery filtered by two drop down boxes - "Team Assignment" and "Current Stage".

Drop_TeamAssign.Items =  Choices('SharePointList'.'Team assignment')   and same for 'Current Stage'

How can I add an "All" option to the Choice, which would essentially reset the filter. These would operate separately, if CurrentStage is "all", the selection in Drop_TeamAssign filter would still function.

Filter('SharePointList', Stage.Value=Drop_Stage.Selected.Value, 'Team assignment'.Value= Drop_TeamAssign.Selected.Value)

[yashag2255 · Accepted solution]

Hi @grantreid 

To configure this, you can use the below expressions:

App -> OnStart -> ClearCollect(TeamAssignmentCollection, {Value:"All"});Collect(TeamAssignmentCollection,Choices('SharePointList'.'Team assignment'));
ClearCollect(CurrentStageCollection, {Value:"All"});Collect(CurrentStageCollection,Choices('SharePointList'.'Current Stage'));

Now, in the Items property of the Dropdowns:

Drop_Stage -> CurrentStageCollection
Drop_TeamAssign -> TeamAssignmentCollection

Then, finally you can set the Filter expression like:

If Choice Type column is single select:

Filter('SharePointList', If(Drop_Stage.Selected.Value = "All", true,Stage.Value=Drop_Stage.Selected.Value), If(Drop_TeamAssign.Selected.Value = "All", true, 'Team assignment'.Value= Drop_TeamAssign.Selected.Value))

If Choice Type column is multi select:

Filter('SharePointList', If(Drop_Stage.Selected.Value = "All", true,Drop_Stage.Selected.Value in Stage.Value), If(Drop_TeamAssign.Selected.Value = "All", true,Drop_TeamAssign.Selected.Value in 'Team assignment'.Value))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[grantreid]

Hi

Thanks for the reply. 

I understand what the Collect and ClearCollect is attempting to do. When I add TeamAssignmentCollection to the dropdown items, its empty.   If I just make the ClearCollect something simple like:

App- OnStart = ClearCollect(TeamAssignmentCollection,{Value:"All"}, {Value:"123"});

DropDown - Items = TeamAssignmentCollection

and ignore the other code you suggested, the dropdown is empty. I've missed something?

[yashag2255]

Hi @grantreid 

In Edit mode, when you place an expression on the "OnStart" property, it is not triggered automatically, this should be done manually for the current session. If you save it and reopen the app, the collection will be filled automatically. In this case, you need to trigger the OnStart by following below steps:

Select App from the left menu, then click on the three dots beside it and then select Run OnStart, this way the collection will be populated with the values.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[grantreid]

Thanks for your help, much appreciated.