cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Bobby_Wallace
Level: Powered On

Tracing SQL

I am trying to find a way to trace the SQL statements being issues by PowerApps. When I submit a form, I am getting:

 

An entry is required or has an invalid value. Please correct and try again.

I have reviewed the "required" fields and the table definition and I don't see a problem. If I could see a SQL trace, or even a detailed error description, I could debug this a little easier.

1 ACCEPTED SOLUTION

Accepted Solutions
Bobby_Wallace
Level: Powered On

Re: Tracing SQL

Thanks for the input.

 

  • It's not a primary key definition issue. The table does have a primary key, and it is defined as an Identity (althought I wouldn't the primary key reqired to be an Identity.
  • It's not Azure.
  • And FYI - SQL Profiler only works when you have sa privileges.

I destroyed the screen and started from scratch and all is copacetic.

View solution in original post

3 REPLIES 3
Microsoft Employee

Re: Tracing SQL

Hello @Bobby_Wallace,

 I'm not aware about a way to trace the logs in PowerApps.

Please note that the SQL table the PowerApps writes to must contain a private key column with "identity" setting (auto increment). This usually is the most common reason for the erro you mentioned in your post.

Super User
Super User

Re: Tracing SQL

Hi @Bobby_Wallace

I agree with @dinusc - it's likely that the primary key column isn't set up as an 'identity' column. You may find some of the details in this post useful.

https://powerusers.microsoft.com/t5/General-Discussion/PowerApps-with-SQL-server-connection/td-p/929...

If you're using on-premises SQL Server (rather than SQL Azure), you can use SQL Server Profiler to see the SQL statements that PowerApps is issuing.

Bobby_Wallace
Level: Powered On

Re: Tracing SQL

Thanks for the input.

 

  • It's not a primary key definition issue. The table does have a primary key, and it is defined as an Identity (althought I wouldn't the primary key reqired to be an Identity.
  • It's not Azure.
  • And FYI - SQL Profiler only works when you have sa privileges.

I destroyed the screen and started from scratch and all is copacetic.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,634)