You’re offline. This is a read only version of the page.
181
Afternoon All.
I have a gallery which I already have a filter applied to removing accounts marked as 'Left'. The code is below:
Share
ReportFilter(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
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
#1
WarrenBelz
146,620
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,962
Most Valuable Professional
All responses (
Answers (
