How to Filter Data table in Power Apps?

While working with a Power Apps requirement, I needed to filter a Power Apps Data table control based on various SharePoint columns. Also, it’s quite easy to achieve this.

In this Power Apps article, I will explain to you how to filter data table in Power Apps using various scenarios like:

• Filter Power Apps Data table based on SharePoint Text column
• Filter Power Apps Data table based on SharePoint Choice column
• Filter Power Apps Data table based on SharePoint Multiple columns
• Filter Power Apps Data table based on ComboBox control

How to Filter Data table in Power Apps

So, let’s proceed with this one by one.

Example-1: (Filter Power Apps Data table based on SharePoint Text Column)

We will discuss filtering Power Apps data table control based on a SharePoint Text field.

The data table will filter and display the specific item information whenever a user searches for any device name in the search box.

To work around this, follow the steps below:

• Below is a SharePoint list called Products. This list contains two columns:
  • Title = Single line of text
  • Vendor = Choice [APPLE, SAMSUNG, HP, DELL, LENOVO]

• On the Power Apps screen, insert a Text input control where users can enter or search any Title like Mobile, Laptop, etc. Rename the text input control to txtSearchBox. Also, remove the text from its Default property.
• Insert a Data table control and set its Items property as:

Items = Filter(
    Products,
    Title = txtSearchBox.Text
)

Where,

1. Products = SharePoint List name
2. Title = Specify the SharePoint field name the user will search in the text box
3. txtSearchBox = Text input control name

• Now save and publish the app. Search any title value (like Mobile) in the text box; then, the specific item details will be displayed in the data table.

Example-2: (Filter Power Apps Data table based on SharePoint Choice Column)

Next, we will discuss filtering Power Apps data table control based on a SharePoint choice column.

• As discussed in the SharePoint list [Products] above, there is a Vendor column with various choices, like APPLE, DELL, HP, LENOVO, etc.

• The data table will filter and show the specific vendor details when a user chooses a name [suppose DELL] from the dropdown menu, as shown below.

• To achieve this, insert a Power Apps Dropdown control and set its Items property as:

Items = Choices(Products.Vendor)

Where,

Vendor = SharePoint Choice field