cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bobby_Wallace
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

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
dinusc
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.

timl
Super User III
Super User III

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.

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,561)