web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery with Se...

Power Apps

Answered

Filter Gallery with SearchBox and /or Datepickers

(0) Share

Report

Report

Posted on by LTEVA

27

Hello dear all,

please assist as i cannot syntax of the below requirement formula:

Gallery (connected to a SP list) must be filtered by:

A SearchBox (by Name, Department,Status..)
2 datepickers in the same screen with searchbox (datepicker1(Start) and datepicker2(End)) that filter the range of Start and End.

How can i filter (or search) the gallery with either searchbox or the date range and (if possible) combination of the two options.

(e.g. filter the date range and then filter by name)

Looking forward to learn from you replies.

Thanks @ALL!!!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@LTEVA ,

Firstly, you need to set some and/or rules - you cannot have them both at the one time and also neither dates nor the in Filter (nor Search) are Delegable, but the syntax would be something like this

Filter( YourSPListName, YourStartDP.SelectedDate >= Start && YourEndDP.SelectedDate <= End && ( YourSearchBox.Text in Name || YourSearchBox.Text in Department || YourSearchBox.Text in Status ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Verified answer

LTEVA 27 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@WarrenBelz,

this part of your solution helped me a lot:

YourStartDP.SelectedDate >= Start && YourEndDP.SelectedDate <= End &&

Afterwards i used the folowing which worked for my case:

Filter( YourSPListName, YourStartDP.SelectedDate >= Start && YourEndDP.SelectedDate <= End && ( StartsWith(Name,SearchBox.Text) || StartsWith(Department,SearchBox.Text) StartsWith(Status,SearchBox.Text) ) )

Many thanks!!!

Join the conversation