Filter inside filter for each record

(0) Share

Report

Posted on by lucasm107

Hi!

I´m updating a funcion of Building Access app

I have an error with geting a filter of each record of parent filter:

ClearCollect(colReservedSpaces,
Filter(
BAR_Requests,
RequestDate >= datepkStartDate.SelectedDate && RequestDate <= datepkEndDate.SelectedDate,
Active = 1,
TimeSlot="Full-day" ||TimeSlot in cmbSelectSlot.SelectedItems,
SpaceName = cmbSelectSpace.Selected.Title,
( Count( Filter( BAR_Requests, Active = 1, RequestDate = ThisRecord.RequestDate).ID ) >= varTotalSeats)
))

The last sentence Filter, the ThisRecord i´m not sure if it´s getting the firt BAR_request statement or the second BAR_Request

That I need is to make a count over each record on the first BAR_request filter

Thanks a lot

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@lucasm107

Please consider changing your Formula to the following:

ClearCollect(colReservedSpaces, With({_reqs: Filter(BAR_Requests, Active=1 && RequestDate >= datepkStartDate.SelectedDate && RequestDate <= datepkEndDate.SelectedDate)}, Filter( Filter(_reqs, (TimeSlot="Full-day" || TimeSlot in cmbSelectSlot.SelectedItems) && SpaceName = cmbSelectSpace.Selected.Title ) As _item, CountRows(Filter(_reqs, RequestDate = _item.RequestDate)) >= varTotalSeats ) ) )

This should give you what you are looking for.

I hope this is helpful for you.