web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery Filter Nightma...

Power Apps

Unanswered

Gallery Filter Nightmare - Filter based on multiple values

(0) Share

Report

Report

Posted on by Angry_Sys_Admin

181

Afternoon All.

I have a gallery which I already have a filter applied to removing accounts marked as 'Left'. The code is below:

Filter(ListName,
 !(Status.Value = "Left")
)

In addition to the above I need my Gallery to filter based on several column values.

First, I need to filter based on 2 columns, call them, Name (filter first) and Location (filter second)

Then I need to add a search function for a third column in the list, say Date of Birth.

Realise this is a bit sketchy but any guidance would be appreciated

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

Akash17 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Angry_Sys_Admin
Please try with this formula
Filter(TableName,(Name="Java" And Location="Demo"),StartsWith(DateOfBirth,TextInput.Text))

for more combinations of filter function plz refer
https://www.enjoysharepoint.com/power-apps-gallery-filter/
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-startswith

Join the conversation