cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PrinceG
Level: Power Up

Can't edit record in azure sql : Invalid Mashup Expression ... We couldn't convert to Number

Hello,

I'm connecting to azure sql using sql server connector but cannot make edit forms work.

The submit button displays following error : 

 

"The requested operation is invalid.

Server Response: Invalid Mashup Expression using supplied values.

  inner exception: We couldn't convert to Number.

clientRequestId : <id>

"

 

I've tried both patch and submit form, neither of them works.

I've tried different tables, but they all fail with the same error.

I've tried lookup, filter, search, gallery select in combination with above.

However, retrieving data and creating new rows work without any problem.

My primary keys on the tables are all integer type, auto incremented (using IDENTITY).

Is it a bug?

Can anyone help me get it working?

 

Also, I'm using Korean for table and column names. Could it be the cause of the problem?

3 REPLIES 3
Meneghino
Level 10

Re: Can't edit record in azure sql : Invalid Mashup Expression ... We couldn't convert to Number

I always suggest to avoid forms:

https://baizini-it.com/blog/index.php/2017/09/28/powerapps-101-create-your-own-forms/

 

I never have problems with Azure SQL Database

Sienna
Level 10

Re: Can't edit record in azure sql : Invalid Mashup Expression ... We couldn't convert to Number

@Meneghino

oh I'm so glad I'm not the only one here with the same opinion on forms

Super User
Super User

Re: Can't edit record in azure sql : Invalid Mashup Expression ... We couldn't convert to Number

Hi @PrinceG

 

With regard to your table containing Korean table and column names, what happens if you try to use a table that uses latin characters? Do you still get the same Invalid Mashup Expression?

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 44 members 4,599 guests
Please welcome our newest community members: