Does anyone know why the filter start/dateTime eq '2025-03-28T13:00:00.0000000' returns no appointment but the filter start/dateTime ge '2025-03-28T13:00:00.0000000' and start/dateTime le '2025-03-28T13:00:00.0000000' returns the appointment that starts at 1pm on 2025-03-28?
I'm not sure why I had to select from these categories to ask this either.
The problem happens because eq (equals) does an exact text match on date-time, and even a small difference in format or time zone causes no result. But ge and le (greater than or equal, less than or equal) work better with ranges and return results correctly.
1. start/dateTime is a string, not a true datetime object
2. eq '2025-03-28T13:00:00.0000000' must match exactly — even one small change (like missing 'Z' or decimals) makes it fail
3. events in Outlook might store time like '2025-03-28T13:00:00.0000000Z' or '2025-03-28T13:00:00' — so eq doesn’t work
4. ge and le do string comparison but allow a range, so it's safer
5. use this filter instead
start/dateTime ge '2025-03-28T13:00:00.0000000' and start/dateTime le '2025-03-28T13:00:00.0000000'
6. even better, use a short time window like
start/dateTime ge '2025-03-28T13:00:00.0000000' and start/dateTime lt '2025-03-28T13:01:00.0000000'
7. this will catch all events starting at 13:00:00 exactly, even with slight format differences
8. avoid using eq for datetime filters in Power Automate when calling calendar events
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
14
Share
Report
All responses (
Answers (
