Filter function in Canvas Power Apps | Power Fx Formula Example

In case you are looking for how you use Search function as opposed to using Lookup() function in Power Fx in Canvas App, check this post!

Scenario

I have a Gallery control which is populated with Accounts data from Dataverse.

Then, I have another Gallery control to demonstrate how we can filter and pick records that satisfy one or more criteria in the Filter formula.

Let’s see how we can use Filter in Canvas App based on the above scenario –

Start by typing Filter while the target Gallery is selected under Items property and you’ll see that it’s a valid function in the list. And the first thing in the parameter after opening the bracket is the source.
Now, Accounts is the table which I’m looking to filter on. I selected this from the Auto-complete when I types Accounts and then press comma (,) for the next parameter.
Next, I’ll be asked the criteria to check for in order to Filter from the source data.
Here, I want to select all the Account whose Annual Revenue is under 750,000.

So, when I start typing the field name, the list will show the correct name which I can select.
Then, I complete the formula.
Optionally, I can have multiple criteria to be Filtered for.
In this example, I’ll still keep only 1.
Now, based on the completed formula, you can see below that the matching records have been filtered in the new Gallery control we added.