Answered

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

(0) Share

Report

Posted on 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:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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.
ingallspw 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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!)
ingallspw 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Nevermind... I had duplicated the form and changed the datepicker name but not the formula. The "Or" || statment worked!