calculate currency data type using flow variable

[_kikilalaaa]

hi all.

i have a column name price (which is a currency data type) and company(line of text) in my sharepoint. 

when user submitted a data, it will filter the sharepoint list based on "company" column and get the maximum "price" within the company. 

after that, it will set a variable named "thresholdAmount".
thresholdAmount = maximum price * 1.5

however, i received this error when i set the variable:

"Enter a valid number"

is this because of the currency data type that i put? how do i solve this?

[RobElliott]

@_kikilalaaa could you post a screenshot of your flow so one of us here can see what the problem might be. Thanks.

Rob
Los Gallardos

[_kikilalaaa]

hello @RobElliott ,

I do not know why but I could not put the screenshots here. here is the summary of my workflow as for now.

1. PowerApps as trigger

2. Initialize variable

Name: ThresholdAmt

Type:Float 

3. Get Items // this is to get the latest input submitted by user in the Power Apps:

Order by: ID desc

Top Count: 1

4. Apply to each 

    Output: [value]

       4.1 Get items // this is to check whether there are any prior records with the company. In my case, the company column is named as "To/From".  If there is prior records, it will check all the records and look for record that has maximum value for "Estimated Monetary Value" column.

              Filter Query :To_x002f_From eq 'To/From' and InputID0 ne 'InputID'

              Order By: Estimated_x0020_Monetary_x0020_V desc

       4.2 Apply to each 

              Output: [value]

              4.2.1 Set variable 

              Name : ThresholdAmt

              Value : 1.3 * Estimated Monetary Value  // this is where I receive an error : " Enter a valid number"