web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / calculate currency dat...
Power Automate
Unanswered

calculate currency data type using flow variable

(1) ShareShare
ReportReport
Posted on by _kikilalaaa 353

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?

Categories:
General topics
  • RobElliott Profile Picture
    RobElliott 10,541 Super User 2026 Season 2 on at

    @_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 Profile Picture
    _kikilalaaa 353 on at

    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"

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 424

#2
11manish Profile Picture

11manish 328 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans