I believe there is some issue with behaviour/refreshing of the lists.
I have a data object containing sales orders and I wanted to display them as a List, filtered with Start and End dates.
My approach was to get a local data variable containing all orders and repeat a list item with selection using the following formula:
SELECT(data.LocalStoreOrders, item.createdAt >= pageVars.dateRangeStart && item.createdAt <= pageVars.dateRangeEnd)
This was not working. The dateRangeStart was working fine but the End of the Range was not working or was generating strange results (dates outside of the range, items on the list would change the date).
The issue is caused by the top of the range as even simpler version of this was not working:
SELECT(data.LocalStoreOrders, item.createdAt <= pageVars.dateRangeEnd)
I think this might be some issue with rendering of the list as the pageVars.dateRangeEnd variable was changing correctly.
What solved the problem was removing formula from Repeat With:
and adding the filter while setting the Data variable passed to the list.
I was afraid that triggering multiple times Get record collection would have worse impact on performance vs just dynamically changing filters on a list , but it seems to work.
BTW I have also noticed that using
DATETIME_IS_SAME_OR_AFTER(date1, date2) formula was reducing performance vs just simple