Share
Report
3I have an Excel sheet that serves as a data list.
One of the columns is called 'Main Address Group'
I have created a dropdown, and defined the Items property as:
Distinct('_Testdata-voor-Jenss';'Main Address group')
There is also a gallery on the same screen, where the Items property is set as:
Distinct(
SortByColumns(
Search(
Filter(
[@'_Testdata-voor-Jenss'];
'Main Address group' = Dropdown1.Selected.Result);
TextSearchBox1.Text;
"cra60_part";
"cra60_addressgroup";
"cra60_firm");
"cra60_part";
If(SortDescending1; Descending; Ascending));
Part)
This part of the app works: when selecting something in the dropdown, the gallery updates with only the records that have a matching Main Address group
I have already set AllowEmptySelection to true so it always starts with no choice and a full list. What i now want is for a way to undo the dropdown selection/filter and get the full list again, without having to reload the page or navigate away.
Once you make a selection in a dropdown, there seems to be no way to undo it and make it so that filter doesn't apply.
What do i need to update or does this need a completely new implementation?
All responses (
Answers (
