Hello,
Im a beginer in power I'm working on a Power App with a calendar template connected to a Dataverse Bookings table. I have two issues I cannot resolve:
My Setup :
- Power app using the built-in Power Apps calendar template
- Dataverse Bookings table with a `Session Date` column
- `Session Date` is a Date only format,
- Calendar uses standard variables `_dateSelected` and `_firstDayInView`
Issue 1 — Dots appear but on inaccurate/wrong dates
I have this formula on the `Visible` property of `Circle2_2` inside `MonthDayGallery2_2` to show a dot when a booking exists on that calendar date:
CountRows(
Filter(
Bookings,
DateValue(Text('Session Date', "mm/dd/yyyy")) =
DateValue(Text(DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days), "mm/dd/yyyy"))
)
) > 0
Dots do appear on the calendar, but they are showing on the wrong dates — they don't accurately match the actual session dates stored in the Bookings table.
Issue 2 — The gallery on the right side shows wrong records for the selected date
When a date is selected on the calendar, a gallery on the right side should show all bookings for that date. My `Items` formula for `Gallery1_1` is:
Filter(
Bookings,
DateValue(Text('Session Date', "mm/dd/yyyy")) =
DateValue(Text(_dateSelected, "mm/dd/yyyy"))
)
This is not working - the gallery either shows no results or displays records from a different date, not the one selected.
What I have already tried:
- Changing `"mm/dd/yyyy"` to `"MM/dd/yyyy"` (uppercase MM for months) — did not fix it
- Direct comparison: `Filter(Bookings, 'Session Date' = DateValue(_dateSelected))` — did not work
- Setting a `varSelectedDate` variable in `MonthDayGallery2_2 OnSelect` using `DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days)` and filtering with that — still incorrect results
- Splitting comparison into `Year() && Month() && Day()` — still not returning accurate results
My Questions :
1. Is `DateValue(Text('Session Date', ...))` not delegable to Dataverse, causing it to only process the first 500 records? Could this be why dates are inaccurate?
2. Is there a known issue comparing Dataverse Date Only fields with the calendar template's `_dateSelected` variable?
3. What is the correct, delegable formula to filter a Dataverse Date Only field against a selected calendar date?
4. Does the `_dateSelected` variable in the calendar template store a Date or DateTime value, and could that mismatch be causing the filter to fail?
Thanks so much to anyone who takes the time to respond - I've been stuck on this for days and would really appreciate any help to get it sorted!
