web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sql error to save a fo...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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.

error.PNG
Categories:
  • Patrick Hess Profile Picture
    Microsoft Employee on at

    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-sqldatabase

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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.

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 432 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 347

#3
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

Last 30 days Overall leaderboard