cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrWill
Level: Powered On

Patch error: We couldn't convert to Number

Hi guys

 

So I'm trying to patch a record in Azure SQL DB. I'm only getting this error with one table and even this one used to work a while back.

 

But to simplify things, it's a table with a primary key (smallint) and a nullable column that's defined as bit (with a default value of True). I'm able to patch a new record, but unable to update it. I've recreated the table in SQL, recreated the connection from Powerapps and even created another Powerapp to use that connection.

Here's my simplified test which fails to succeed:

Patch('<my table name, which has the character ä in it>', LookUp('<my table name, which has the character ä in it>', primary_key_name = 11), {column_name_that_also_has_the_letter_ä_in_it: false})


I've tried using 0 instead of false. I have other tables with the letter ä in them, and they work. I've tried dropping all the constraints on the table.

The error I'm getting is:
The requested operation is invalid. Server Response: We couldn't convert to Number. inner exception: We couldn't convert to Number. clientRequestId: d8318119-4f18-4569-a985-c609a017bf0c

This used to work and is driving me nuts. I can successfully update other tables from the same app. The table with these issues has schema permission of SELECT and table permission of INSERT,UPDATE for the user account I'm using.

What should I try next?

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,999)