Showing results for 
Search instead for 
Did you mean: 
New Member

Can a wildcard be used to indicate 'all items' in a Filter function?



I am trying to understand whether I can somehow replicate Excel's * in a filter function so that the function returns all items in a table. For example Filter(TableName, Column1 = "*"), what do I need to put instead of the * so that the function returns all of the records in TableName?



Power Apps
Power Apps

There is no wildcard as such, but there are a few ways you could achieve that by for example using an "If" and return either the full datasource or a filter expression, or you can use an "Or" to check if it should return all of the rows, here is what I do:


	Filter(UserMessages, Email = Dropdown1.Selected.Value || Dropdown1.Selected.Result = "<All>" )


Thanks, that is a nice way to do it 🙂

Advocate II
Advocate II

This is old, but there is not a whole lot of documentation and help for PowerApps so i'm adding where i can.


I don't understand the "<All>" syntax of the accepted solution, so this is what I did:


DropDown1.Selected.Value <> "[YourDefaultValue]",
DropDown1.Selected.Value = TableFilterColumn1,
TableFilterColumn1 in DropDown1Selections
If(DropDown2.Selected.Value <> "[YourDefaultValue]",
DropDown2.Selected.Value = TableFilterColumn2,
TableFilterColumn2 in DropDown2Selections


And you can continue the logic for how every many dropdown filters you want to use. Each dropdown when not equal to the first/default value will act as an AND filter for the returned table, which I use as the Items property of a gallery.


Be sure to set DropDown1 Items property = DropDown1Selections and DropDown2 Items property = DropDown2Selections. I Collect the two collections with a button.


Frequent Visitor

Please explain, I don't understand how the "Or" statement is checking all the records

Filter(UserMessages, Email = Dropdown1.Selected.Value || Dropdown1.Selected.Result = "<All>" )

It looks like the filter resulting from the OR statement would either be
Filter(UserMessages, Email = Dropdown1.Selected.Value)
which is a valid filter, or it would be
Filter(UserMessages, Dropdown1.Selected.Result = "<All>")

which is not a valid filter, because the statement Dropdown1.Selected.Result = "<All>" doesn't have any relationship to the UserMessages table.

Advocate II
Advocate II

You can call the Data Source -> Column in the filter parameters using an if statement. I have added an example below.

        ProgramName = my_ProgramComboBox.Selected.Result,
        ProgramName in Workflows.ProgramName



Filter(UserMessages, Dropdown1.Selected.Value = "<All>")


If you have a dropdown with <All> as a choice, the result should return "true", hence the formula will be Filter(UserMessage, true), or simply Filter(UserMessage), which return all result

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,368)