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)

Sort by

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(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,877 Super User 2026 Season 1 on at

Like
a
(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
a
(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 2,456 Super User 2026 Season 1 on at

Like
a
(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