#PowerPlatformTip 23 – ‘Filter Blank’

💡 Challenge

Filtering galleries in PowerApps based on user input (like text input, dropdown, or combo box) is common. But what if you want to display all items when no input is provided?

✅ Solution

Use the || isblank(YOUR FILTERINPUT) condition in your filter formula to show all items when the filter input is empty.

🔧 How It’s Done

Here’s how to do it:

1. Create a gallery and set up your filter inputs (e.g., text input, dropdown, or combo box).

2. Apply the following formula to your gallery’s Items property:

   Filter(YourDataSource, Condition

   isblank(YOUR FILTERINPUT))

   🔸 YourDataSource is the source of your data.
   🔸 Condition is your filtering condition (e.g., TextInput.Text = ThisItem.Field).
   🔸 YOUR FILTERINPUT is the input control (e.g., TextInput, Dropdown).

🎉 Result

When the filter input is empty, the gallery will show all items. If an input is provided, the gallery will filter based on the specified condition.

🌟 Key Advantages

🔸 Simplifies gallery filtering logic.
🔸 Enhances user experience by dynamically displaying all or filtered data.
🔸 Reduces the need for multiple filtering conditions.

---

🛠️ FAQ

1. Can I use multiple filter conditions with the isblank() check?
Yes, you can combine multiple conditions using && or || operators while still including the isblank() check for each filter input.

2. Does this technique work with all data sources in PowerApps?
Yes, this filtering approach works with SharePoint lists, Dataverse tables, SQL databases, and other supported data sources.

3. How can I handle multiple filter inputs simultaneously?
Create compound conditions like: Filter(DataSource, (Condition1 || IsBlank(Input1)) && (Condition2 || IsBlank(Input2)))