Hi @_sourcecod3_ ,
I will give you a concept if you have under 2,000 items in your data set I(and have your settings to this)- the below should work without Delegation errors. If you have more than this, dates are not Delegable, so some additional thought may be required.
With(
{
wFrom:YourFromDatePicker.SelectedDate,
wTo:YourToDatePicker.SelectedDate,
wDept:YourDepartmentSeach.Text,
wStatus:YourStatusDD.Selected.Value
wList:YourListName
},
Filter(
wList,
If(
Value(wFrom)=0,
true,
YourDateField>=wFrom
) &&
If(
Value(wTo)=0,
true,
YourDateField<=wTo
) &&
If(
IsBlank(wDept)=0,
true,
StartsWith(YourDeptField,wDept)
) &&
If(
IsBlank(wStatus)=0,
true,
YourStatusField=wStatus)
)
)
)
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.
