Filter record from selected component in Gallery

(0) Share

Report

Posted on by dyna009

Hello Everyone,

Please help me in my priority task.

In this Gallery i am filtering record. in this, if i select start date and end date i want all record between two dates.

suppose i select start date, end date and employee then filter only selected employee record between two dates.

if i select only employee then need to filter selected employees all request till today.

currently i am filter record like below code

Filter(
 Requests,
 'Start Date' >= StartDatePicker.SelectedDate && 'End Date' <= EndDatePicker.SelectedDate && Requester in EmpListComboBox.SelectedItems
)

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

uwenagel 382 on at

Like
a
(1)

Report
Copy link

Link copied!
You could change your filter condition as follows:

Filter( Requests, ('Start Date' >= StartDatePicker.SelectedDate || IsBlank(StartDatePicker)) && ('End Date' <= EndDatePicker.SelectedDate || IsBlank(EndDatePicker)) && (Requester in EmpListComboBox.SelectedItems || IsBlank(Requester)) )

You of course have to set the DefaultDate of your DatePickers to Blank() for that to work.
dyna009 35 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @uwenagel
Thank for reply.
It is works.
dyna009 35 on at

Like
a
(0)

Report
Copy link

Link copied!
@uwenagel
i am writing below code and its work fine according to my requirement
Filter( Requests, ('Start Date' >= StartDatePicker.SelectedDate && 'End Date' <= EndDatePicker.SelectedDate) ), !IsBlank(RequestTypeDropdown), Filter( Requests, ('Start Date' >= StartDatePicker.SelectedDate && 'End Date' <= EndDatePicker.SelectedDate) && Requester in EmpListComboBox.SelectedItems && 'Request Status' in StatusDropdown.SelectedText.Value && 'Request Type' in RequestTypeDropdown.SelectedText.Value ), !IsBlank(EmpListComboBox), Filter( Requests, ('Start Date' >= StartDatePicker.SelectedDate && 'End Date' <= EndDatePicker.SelectedDate) && Requester in EmpListComboBox.SelectedItems ), !IsBlank(StatusDropdown), Filter( Requests, ('Start Date' >= StartDatePicker.SelectedDate && 'End Date' <= EndDatePicker.SelectedDate) && Requester in EmpListComboBox.SelectedItems && 'Request Status' in StatusDropdown.SelectedText.Value ) )
uwenagel 382 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you try my suggestion as well? It should work as well and is very much shorter!
dyna009 35 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @uwenagel
i have try your suggestion as well, but i want to set all filter. and also your answer is worked