cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted

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
Highlighted
Microsoft
Microsoft

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.

Highlighted

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.

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (6,963)