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

🌸You're Invited: Community Spring Festival Awards Celebration 🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,731 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,075 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans