Announcements
I have connected the Azure MySQL Database table named "order assignment" with PowerApps. However when i set the order assignment table as gallery item then it shows the below error
"Error when trying to retrieve data from the network: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Order Id FROM order_assignment LIMIT 500' at line 1"
Please help
Close the app. Reopen the app.
Remove the connection. Readd the connection. This is an internal error.
Hi @Saurabh5699
If you go to settings > general and increase the 'data row limit' to 2000, does that change the description of the error message?
I'm interested to see if this is bug that's related to the row limit setting.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 551
WarrenBelz 430 Most Valuable Professional
Valantis 298
