Answered

Show all data in the data table when dropdown is empty

(0) Share

Report

Posted on by Solomon_c

Hello, I have a dropdown box that filters a column when item is selected. However, when I haven't made a selection, the data table is blank. How can I make the filter default to show all data until a selection is made from drop down? Currently, this is my formula: Filter(Feature1_1, Title = TitleFilter.Selected.Value). Thank you.

Categories:

Building Power Apps

Populatedata.png

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
Hi @Solomon_c ,
Like this
If( IsBlank(TitleFilter), Feature1_1, Filter( Feature1_1, Title = TitleFilter.Selected.Value ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi @Solomon_c

@WarrenBelz solution works. Another one is to use a Combobox with the Items property: Distinct(dataset, fieldname), Allow Searching off, Allow multiple selections: off, DefaultSelectedItems property: Blank().

A button with OnSelect property: Reset(Combobox) and the

DataTable Items property Filter(dataset, field = Combobox.Selected.Result).

Comboboxes are blank by default and the initial datatable filtered on it will contain all of the items. Resetting the Combobox will fill the datatable.
After playing with this, it’s too much trouble. I vote for @WarrenBelz solution.

Was this reply helpful? Yes No
Solomon_c 65 on at

Like (0)

Report

Hello @WarrenBelz ,the formula does not work for me. I realize that the dropdown isn't "Blank". To make the first option in the dropdown items blank... I have this in Items: ["","Milestone 1", "Milestone 2", "Milestone 3"] this is the default of the dropdown box: "0". Do you know how to make the dropdown default blank? Thank you.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Hi @Solomon_c

Sort the list by the field name containing the milestones, Ascending

Sort( Feature1_1, Title, Ascending)

If there are duplicates in the dropdown, then use this instead as the items property of the dropdown

Sort(Distinct(Feature1_1, Title), Result, Ascending)

This assumes that your list is called Feature1_1

Was this reply helpful? Yes No
Solomon_c 65 on at

Like (0)

Report

Hi @Drrickryp.
The sort works, but then the filter for my dropdown selection does not work. I think the easiest way is to make the first item in my dropdown "blank", but I am not sure how to do that...

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Can you edit your list and add "... " to it? That way you could put the following in the Items property of the gallery as per @WarrenBelz

If( TitleFilter.Selected.Title = "...", Feature1_1, Filter( Feature1_1, Title = TitleFilter.Selected.Value ) )

Was this reply helpful? Yes No
Solomon_c 65 on at

Like (0)

Report

I could, if "blank" isn't an option. Add "..." in my list, then just reference "..." as "All data" is what you are saying?

@Drrickryp thank you for the help. This is the formula:
If(TitleFilter.Selected.Value = "...",Feature1_1, Filter(Feature1_1, Title = TitleFilter.Selected.Value)), PERFECT. @WarrenBelz credit as well for original.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Exactly! If this works, please credit @WarrenBelz as well

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Thanks @Solomon_c and @Drrickryp ,
Good to see this solved "overnight" (7:15am Thursday morning here).

Was this reply helpful? Yes No