News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows how to calculate squar...

Power Automate - Building Flows

Answered

how to calculate square root, absolute value in expressions?

Like (0) Share

Report

Report

Posted on 3 Jan 2021 05:09:34 by Community Power Pla...

Hi,

I am using power automate to create 54 columns with calculations which include exponents, square roots, absolute values etc.?

How do I achieve the following in expressions?

(body('Create_item')?['column1']))^2 (eg. 5^2 = 25)
Abs((body('Create_item')?['column1'])) (eg. Abs(2) or Abs(-2) = 2)
Sq.rt((body('Create_item')?['column1'])) (eg. Sq.rt(25) = 5)

Regards,

Aakash

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

abm abm 32,464 Most Valuable Professional on 03 Jan 2021 at 21:31:32

Like (0)

Report

Re: how to calculate square root, absolute value in expressions?

Hi @Anonymous

Unfortunately these functions are not available under Power Automate. The only way you could implement is host a http webservice/function where it can receive the numbers and return the relevant math function results. Use the HTTP action step in Power Automate to call the custom function/webservice.

You could also add this as an idea under the idea forum.

Power Automate Ideas - Power Platform Community (microsoft.com)

Thanks

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard > Power Automate - Building Flows

#1

Michael E. Gernaey 186 Super User 2025 Season 1

#2

David_MA 163 Super User 2025 Season 1

#3

stampcoin 159

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans