web

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

News and Announcements icon

Power Platform CommunityForums Power Apps 2 filter formulas

Power Apps

Answered

2 filter formulas

(0) Share

Report

Report

Posted on by Hannah4987

3

Hi,

I am trying to add 2 filters to one data gallery. Both formulas work on their own but i am struggling to find advice on how to add them together. Can anyone help please?

(Filter('Project Database',('Scheduled Date'>=DatePickerfrom.SelectedDate)&&('Scheduled Date'<=DatePickerto.SelectedDate))

(Filter('Project Database', Filtertextbox.Text in 'Lead Engineer'))

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Hannah4987

You can combine them like this

Filter( 'Project Database', 'Scheduled Date'>=DatePickerfrom.SelectedDate, 'Scheduled Date'<=DatePickerto.SelectedDate, Filtertextbox.Text in 'Lead Engineer' )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Hannah4987 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much! this worked a treat. your help has been much appreciated.

Was this reply helpful? Yes No

Join the conversation