Hello,
I am creating an app where I have a gallery to display cases created by users so an admin can filter based on dropdowns outside the gallery. Gallery is connected to a SharePoint list. Besides dropdowns I am including a searchbox so the people can search by the cases assigned to them and this is a person or group column (single choice). Up to this point no delegation problem.
My problem is that when I use the following formula (highlighted in red), the searchbox returns not only the user but also the cases that have not been assigned (items where this column is blank). If I dont use this formula the gallery only displays the cases that have been assigned.
How do I fix the formula so It can return only the cases related to the searchbox and exclude the blank but when there is nothing in the searchbox it shows everything?
SortByColumns(Filter(
If(
ddownStatus.Selected.Result="-" And ddownBuilding.Selected.Result="-" And ddownLocation.Selected.Result ="-",SPList,
ddownStatus.Selected.Result="-" And ddownBuilding.Selected.Result<>"-"And ddownLocation.Selected.Result="-",
Filter(SPList,Building=ddownBuilding.Selected.Result)),
Or(StartsWith('Assigned to:'.DisplayName,TextInput1.Text),IsBlank('Assigned to:')),Created>=DateFrom.SelectedDate And Created<=DateTo.SelectedDate),"Created",Descending)
Regards,
Serafin
