cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Sql error to save a form, does not recognize a column.

I'm trying to save a form in SQL, but the message is showing that there is no column x in the table, but it does exist.

 

When saved without the specific column, the application registers and "null" appears in the specified column field.

1 ACCEPTED SOLUTION

Accepted Solutions
3 REPLIES 3
Microsoft
Microsoft

Lourenacdm,

 

This is an inner exception being thrown when the app is trying to run some stored procedure. You can see it's a server response so it's not likely an error with the app itself or a given expression, although always possible.

 

The most likely breakpoint is the stored procedure in question. You can look to see if there are syntax errors, maybe there are other deleted fields still being referenced in there. You'll also want to look for special characters in both the SPROC and your data, anything that could possibly interrupt this.

 

You can try some "toggle" type steps, as well...

 

  • Recreate the data connection in your app, ensuring to refresh your data source.
  • Recreate the SPROC the app is leveraging.
  • Test the same SPROC/expressions/et al. in a fresh app to see if it still reproduces.
  • Test from Power Automate to see if the issue follows there. If it does, then you can be pretty confident the issue is with the server, SPROC or data.

 

For more:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections-list

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabas...

https://docs.microsoft.com/en-us/connectors/sql/

 

If this remains persistent even with this troubleshooting, you can navigate to the Power Platform Admin Center and set up a support incident. This may not ultimately be a PowerApps issue but we can make certain.

 

Let us know!

 

Sincerely,

Patrick

Hi Patrick,

 

We followed the steps, remade the connections and in our database we don't have Stored procedures, triggers, etc. And the error persists.

 

I appreciate your feedback and we will set up a support incident on that.

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 (4,475)