Answered

Data source may be invalid when i want to add a new row from PowerApps to SQl server

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Guys,

I have a problem when i try to add new row from my PowerApps to my SQL Server. This is the error i get when i submit my form: There was a problem saving your changes. The data source may be invalid, when i try to add a new row

This is my table from my SQL server.

This is my form in my PowerApps

I don`t know what i am doing wrong? I just noticed when I manually try to add a new row in my SQL server then there is no problem.

Best regards!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-yuxima-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you fill all your field which is setting not null in your sql?

And do you fill all of your primary key in app?

From your screenshots’s shows, MUID: field required? Do you fill it in your app?

And there are two primary keys in your sql, are they all in your app?

Please check and fill them and try it again.

Hope this can be hlpful.

Best Regards.

Yumia
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous I'm sorry you're experiencing this issue. Can you review the above reply and advise if it was helpful?

Thank you,

@Anonymous
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous @v-yuxima-msft ,

This problem took me too long to fix it. Unfortunately i couln`t fix it so i create a new table in SQL without MUID column.

If i add a new row in that table then the column MUID will be automaticley inserted (created a new value).