Notifications
Announcements
Hello working on a vacation app. I came into this webserver error as well as a JSON error.
Attatched is the server error. Data seems to flow just fine, but throws this error. Attatched the function it is trying to use
Error Message:
Hi @Anonymous ,
Could you please share a bit more about your data source used within your app? Is it a SQL Table?
Based on the error message that you mentioned, it seems to tell that there is something wrong with the SQL Table connection added within your app.
The user @hshah has faced same issue with you, please check my response within the following thread:
https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Powerapp-connected-to-database-with-on-premise-gateway/m-p/285519#M1744
If the issue still exists, please conside submit an assisted support ticket through the following link:
https://powerapps.microsoft.com/en-us/support/pro
Best regards,
Hi @Anonymous are you still receiving this error? Was the above reply helpful?
@Anonymous
Still getting the error. Tech above reached out and has said that it is working by design SQL cannot use those predicts.
Our product team has informed us that this issue is by design and documented in the below link:
https://docs.microsoft.com/en-us/connectors/sql/
The following data types cannot be used as query option predicates:
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 796 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
Power Platform 1919 268
