One of my apps recently received an error in which "An error occurred on the server. Server Response: Not a valid connector Error response" is displayed. This error occurs when a user is trying to refresh the connection to the Azure SQL database. The database is connected to a gallery.
This is the formula that I am using to sort and filter my SQL view, nothing too complex over here:
SortByColumns(Filter('[dbo].[table]',Location = InspectDropDown.SelectedText.Value),"NextDate",Ascending)
What would cause this issue? I've done the following:
1. Did a manual refresh in the PowerApps editor.
2. Deleted the connection, and then reconnected.
3. Manually refreshed the SQL view within my DB.
Appreciate the help. Thanks
Solved! Go to Solution.
I am able to make a simple gallery using the SQL connector. The error seems to originate from the use of SortByColumns or Filter.
Is there some box that I can hit on the side to make this work?
I've tried this formula in the gallery Filter('[dbo].[table]',Location in InspectCombo.SelectedItems.Value) and a delegation warning is returned.
Your weird idea worked for the time being!
Filter('[dbo].[table.dbo]', Location in InspectCombo.SelectedItems.Location)
Thank you for your assistance this morning!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Voting Ends: October 30, 2019!
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round