Answered

Error with Patch() function

(0) Share

Report

Posted on by ProtoSup

Hi Sirs, I'm on this problem since 2 days, I don't understand for why I can't Submit my Form, each submit form make me this error while 2 days it worked very well...I haven't changed anything...

can you tell me what to check to fix this problem ?

thank you very much to whoever takes the time to help me 🙏

Here my error message :

Categories:

Connecting to Data

Using Apps Using Formulas

Dataflows

General Questions

All responses (16)

Answers (2)

ProtoSup on at

Like (0)

Report

Re: Error with Patch() function
ProtoSup on at

Like (0)

Report

Re: Error with Patch() function

hi ! @v-xiaochen-msft

I'm testing this manipulation to display another error with more informations , but, it don't works ... I don't understand why ... You know ?

Thanks ...
ProtoSup on at

Like (0)

Report

Re: Error with Patch() function

ok thanks you two, it works good ! Have a nice day
Verified answer

v-xiaochen-msft on at

Like (1)

Report

Re: Error with Patch() function

Hi @ProtoSup ,

The type of this column is determined by the database.

If you want to save the number 100 instead of the string 100, please first change the text column to a number column in the database.

What's your database? SharePoint list? Dataverse?

Best Regards,

Wearsky
Verified answer

SanshubhLubal 509 on at

Like (1)

Report

Re: Error with Patch() function

What is column Type of Prix and Database?
ProtoSup on at

Like (0)

Report

Re: Error with Patch() function

ok thanks, i change it, now it detecte the value but i think it's not the good type, how to modify in Integer ?

Thanks
v-xiaochen-msft on at

Like (0)

Report

Re: Error with Patch() function

Hi @ProtoSup ,

Which one control is called 'DataCardValue10' in your screen?

Besides, remove the Value function in update formula.

Best Regards,

Wearsky
ProtoSup on at

Like (0)

Report

Re: Error with Patch() function

@v-xiaochen-msft

That !?
Thanks again
v-xiaochen-msft on at

Like (0)

Report

Re: Error with Patch() function

Hi @ProtoSup ,

Thanks, please share the formula of Update property of the datacard control.

Best Regards,

Wearsky
ProtoSup on at

Like (0)

Report

Re: Error with Patch() function

@v-xiaochen-msft
I don't understand, why the error said me value for field 'Prix' = 2.5, we can see the value = 100 ... thank you for thid start, we can see better the error ...