Views:
Applies to Product - Power Apps

What’s happening?
  • When connecting to an Azure MySQL database and using filters to extract data, users encounter an SQL syntax error when specifying datetime or date type items in the filter condition. The error message typically states: "You have an error in your SQL syntax; check the manual that corresponds to your MYSQL server version for the right syntax to use near '0:0:0)". If datetime or date is not used as a condition, no error occurs.

 

Reason:

  • This has been identified as a bug in the connector related to the handling of datetime and date fields in OData filter queries, which causes syntax errors in MySQL.

 

Resolution:

  • As a current workaround, users should perform operations without using datetime or date-based filters until the bug is resolved.
  • The product development team is investigating the issue, and a bug fix is expected to be implemented by the end of a specified timeframe. Further updates will be provided as they become available.