Applies to Product - Power Automate
What’s happening?
The customer is experiencing issues with the filter query when using the "List rows present in a table" action in Excel Online, specifically when attempting to filter on a date column.
What’s happening?
The customer is experiencing issues with the filter query when using the "List rows present in a table" action in Excel Online, specifically when attempting to filter on a date column.
Reason:
This arises when the datetime format is set to ISO 8601, which does not allow for proper filtering using the date column.
Resolution:
To resolve this, change the datetime format from ISO 8601 to Serial Number in the filter query. This adjustment allows for successful filtering on the date column.