Answered

Does not match the expected type ‘Currency’. Type found ‘Number’.

(0) Share

Report

Posted on by QuentinDURIEZ

577 Moderator

Hi,

On creation version 3.25123.14 while editing a custom page I got an error while patching a dataverse table regarding a currency type column :

The type of this argument ‘man_remisemontantmin’ does not match the expected type ‘Currency’. Type found ‘Number’.

Whenere I try to patch this column I got an error on the editor, but the currency type does not exists in PowerApps so I don't know what to do about this.

Regards,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Kalathiya 1,456 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @QuentinDURIEZ,

Please try this:

Patch( YourTable, //Replace 'YourTable' table name with your table name Defaults(YourTable), //Replace 'YourTable' table name with your table name {man_remisemontantmin: Value(TextInput1.Text) /replace with your column name } //TextInput1 - replace with your input field name )

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @QuentinDURIEZ

You are trying to patch number in currency field.

Try below code to achieve the same

Patch(TableName, LookUp('Table Name', ID=1), // if it is an existing Record Defaults('Table Name'), // if it is an new Record { "new_currencyfield": Value(350.25) // Logical Name of Currency field }

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No
Verified answer

QuentinDURIEZ 577 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello all,

Thanks for your reponses but this not work

Here is what I do :

Patch(Remises ; ForAll(_collectionRemises ; Patch( LookUp(_collectionRemisesExistantes As r ; r.'Famille de SKU'.SKU = ThisRecord.'Famille de SKU'.SKU And r.'Montant min.' = NumberInput3.Value); { 'Offre commerciale': ThisRecord.'Offre commerciale'; 'Famille de SKU': ThisRecord.'Famille de SKU'; 'Montant min.': NumberInput3.Value } ) ) )

I use a modern number input, but even if I force a constant value I got the same error message

Patch(Remises ; ForAll(_collectionRemises ; Patch( LookUp(_collectionRemisesExistantes As r ; r.'Famille de SKU'.SKU = ThisRecord.'Famille de SKU'.SKU And r.'Montant min.' = NumberInput3.Value); { 'Offre commerciale': ThisRecord.'Offre commerciale'; 'Famille de SKU': ThisRecord.'Famille de SKU'; 'Montant min.': 0 } ) ) )
The currency field waits for a currency value but this does not exists.

Since I use a custom page I can't change the authoring version that coonvert my currency field as a number where I collect my remises and cannot be reverted

If I use a classic Patch in a ForAll loop, everything goes fine

ForAll(_collectionRemises As r; Patch( Remises ; Coalesce(LookUp(_collectionRemisesExistantes As e ; e.'Famille de SKU'.SKU = r.'Famille de SKU'.SKU And e.'Montant min.' = NumberInput3.Value); Defaults(Remises) ); { 'Offre commerciale': r.'Offre commerciale'; 'Famille de SKU': r.'Famille de SKU'; 'Montant min.': NumberInput3.Value } ) )

Was this reply helpful? Yes No
Kalathiya 1,456 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@QuentinDURIEZ,

you need to wrap the value you are patching with the Value() function so that it is correctly interpreted when sent to Dataverse.

Assuming ‘Offre commerciale’ is a currency column, you need to pass the dynamic field value like this:

Value(ThisRecord.'Offre commerciale')

Patch(Remises ; ForAll(_collectionRemises ; Patch( LookUp(_collectionRemisesExistantes As r ; r.'Famille de SKU'.SKU = ThisRecord.'Famille de SKU'.SKU And r.'Montant min.' = NumberInput3.Value); { 'Offre commerciale': Value(ThisRecord.'Offre commerciale'); 'Famille de SKU': ThisRecord.'Famille de SKU'; 'Montant min.': 0 } ) ) )

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No