How to Multiply with Currency Column using Power Automate

(0) Share

Report

Posted on by Himanshu Kamboj

425

Hi,

I have MS flow, through that I want to update a currency field on change of that field only.

I need to multiply the currency field by 1000000 and then want to update the currency field.

First of all can I do this without any recurring error ??

And how to multiply the currency field with 1000000 any syntax formula??

Like above SS, I have already added few conditions, after these I need to multiply this currency field with 100000 and update the same currency filed in opportunity entity.

And I need to run this ms flow on change of this currency field only.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

Hi Himanshu Kamboj,

Since you set the condition that the value of Currency field should be less than 1000, so the flow would not have recurring error. The flow would only be triggered twice, first time is when you modify the field. Another is after the first time executed, the flow would be triggered again. However, its value would be greater than 1000.

Here is the steps(I used the Budget Amount on the Opportunity entity as sample):

First, create only Modified trigger and type the logical name of your currency field in the Select setting:

Then create the same condition as your screenshot:

Finally, update the record is ok.

The expression of the Budget Amount is mul(triggerOutputs()?['body/budgetamount'],1000000)

Note: Change this logical name ‘budgetamount’ to yours.

Result:

Was this reply helpful? Yes No
Suggested answer

KK-365 1,010 on at

Like (0)

Report

I agree with Steve answers.

However, I would recommend you to initialize a floating number variable and then set the calculated value.

Use this variable to assign on the Currency field.

Was this reply helpful? Yes No