I can filter and search text and date but adding ComboBox breaks the gallery

Like (0) Share

Report

Posted on 21 Sep 2022 15:02:09 by ingallspw

I am using a gallery to show data. I can use these two codes separate and the gallery works.

Search(Filter(SortByColumns('Production Reporting',"Created"),Created>=DatePickerStart.SelectedDate, Created<=DatePickerEnd.SelectedDate),InputEmployee.Text,"Employee","Employee2","Employee3","PartNumber")


Filter('Production Reporting','Work Center'.Value = ComboBox1.Selected.Value)

However when I combine them, the Gallery comes up empty (as seen below):

Search(Filter(Filter(SortByColumns('Production Reporting',"Created"),Created>=DatePickerStart.SelectedDate, Created<=DatePickerEnd.SelectedDate),'Work Center'.Value = ComboBox1.Selected.Value),InputEmployee.Text,"Employee","Employee2","Employee3","PartNumber")

Any help would be appreciated!
gallery broke.png

Categories:

Using Apps Using Formulas

All responses (3)

Answers (1)

ingallspw 18 on 21 Sep 2022 at 17:27:11

Like (0)

Report

Re: I can filter and search text and date but adding ComboBox breaks the gallery

Nevermind... I had duplicated the form and changed the datepicker name but not the formula. The "Or" || statment worked!
ingallspw 18 on 21 Sep 2022 at 17:11:11

Like (0)

Report

Re: I can filter and search text and date but adding ComboBox breaks the gallery

Thanks!! I tried this but sorry to say it fails. Then I just added the || or statement and it works better but only pulls up the second item on the list when nothing is selected?

I see you combined the filter function... I couldn't get that to work the first time and that's why I had it twice.

(By the way... I subbed to your YouTube channel!)
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on 21 Sep 2022 at 15:06:05

Like (1)

Report
Re: I can filter and search text and date but adding ComboBox breaks the gallery

@ingallspw

Please consider changing your Formula to the following:

SortByColumns('Production Reporting' Search( Filter( Created>=DatePickerStart.SelectedDate, Created<=DatePickerEnd.SelectedDate, 'Work Center'.Value = ComboBox1.Selected.Value || IsBlank(ComboBox1.Selected.Value) ), InputEmployee.Text,"Employee", "Employee2","Employee3","PartNumber" ), "Created" )

I hope this is helpful for you.