I have a gallery that I'm filtering by a few different queries and I see a weird issue every once in and while.
It's a gallery within a gallery and when I first go to the screen the filter doesn't work properly but if I leave the screen and come back it then works properly. The first gallery acts like an accordion where the headers are the status, once clicked that section opens with the items with that status within the open section.
First gallery 'Items' property:
Choices(Tasks.Status)
Inner gallery 'Items' property:
SortByColumns(
Filter(
Tasks,
Status.Value = ThisItem.Value && ('Due Date' >= varStartDate && 'Due Date' <= varEndDate) && 'Created By'.Email = varUser.Email,
StartsWith(
Title,
Search_5.Text
) || StartsWith(
RelatedRequestTitle,
Search_5.Text
)
),
"DueDate"
)
When I first go to the screen the item count is 0. If I go to a different screen and back to the first screen the items then show
Ugh, brain fart 😞 I was setting the date variables on a different screen's OnVisible prop. I've moved it to the app OnStart
Hi @t145h1b1 ,
When navigating between screen, does the value of varStartDate and varEndDate change?