You’re offline. This is a read only version of the page.
Announcements
3
I 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:
Share
ReportDistinct('_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?
Clicking the selected value in the dropdown again will empty the dropdown.
You should update the filter like below to show all results when no value is selected:
All responses (
Answers (
Filter(
[@'_Testdata-voor-Jenss'];
'Main Address group' = Dropdown1.Selected.Result) || IsBlank(Dropdown1.Selected.Result)
