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 / Issue: 'SQL Server - i...
Power Apps
Answered

Issue: 'SQL Server - insert row' - "Invalid Mashup Expression using supplied values"

(0) ShareShare
ReportReport
Posted on by 329

One of my users recieved this error when trying to add a record using the application that I built.  The user was accessing the application in Chrome. My app uses an Azure SQL server connection. 

 

 

I've added an exception to my server's firewall that allows PowerApps to access the application. Would I need to add every single IP address that my users use? What would cause this error?

 

 

Brendon

Categories:
  • Verified answer
    v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi @BrendonBrooksP1,

     

    Did you mean that all your users are getting this error? 

     

    Please check the following things.

     

    1. Please make sure your database engine is configured to accept remote connections.
    2. Please make sure that you create an exception on the firewall for the SQL Server instance and port you are using.
    3. Please check if your SQL server services is up and running properly.
    4. Please make sure that you enable TCP/IP in SQL Server Configuration

     

    This article could be a reference for you:
    https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-erro...

     

    Make sure that you have gone throught the below article:

    https://powerapps.microsoft.com/en-us/tutorials/connection-azure-sqldatabase/

     

    Best regards,
    Mona

  • BrendonBrooksP1 Profile Picture
    329 on at

    Turns out, it was caused by an invalid input. The column in question was set to timestamp, when it should have been set to DateTime

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 236 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 207 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 169

Last 30 days Overall leaderboard