I have two galleries. The first one displays a day with all entries of work for that day (glry_Day). The second displays the week with a sum of hours of entries for the days of that week (glry_Week). The galleries are populating correctly with data, from an Excel spreadsheet.
When I click an arrow control on glry_Week, say for 05/06/24, I want to make glry_Day visible and populate it with the data that corresponds with that day. To do that, I have set the following:
// I use a variable for visibility and the date value, both are being set correctly
glryDayArrow.OnSelect >
Set(varScrn2Focus, "Day");
Set(varDateValue, DateAdd(ThisItem.Date, TimeZoneOffset(), TimeUnit.Minutes));
glry_Day.Items >
Sort(Filter(facTimeEntry, EmployeeName = User().FullName && DateAdd(TimeEntryDate, TimeZoneOffset(), TimeUnit.Minutes) = varDateValue), TimeIn, SortOrder.Ascending)
This successfully changes to the glry_Day but does not display the entries:
If I click the date picker (without choosing a date), or if I do choose a date, the entries appear as normal:
The date picker control simply sets varDateValue to its selected date:
dtpk_DayPicker.OnSelect (and OnChange)
Set(varDateValue, Self.SelectedDate);
The default date is also set using the variable:
dtpk_DayPicker.Default
varDateValue
How do I trigger the gallery to "refresh" as if the date was picked from the date picker, when clicked from the other gallery's arrow control?
