cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Unte
Level: Powered On

Math function to sum or multiply values?

Is there a way to take math actions on output values?

 

 Screenshot_2.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Unte
Level: Powered On

Re: Math function to sum or multiply values?

Found it!

 

Screenshot_1.png

 

It's possible to use https://msdn.microsoft.com/en-us/library/azure/mt643789.aspx functions

Just needed quotes to make it work!

 

View solution in original post

9 REPLIES 9
Unte
Level: Powered On

Re: Math function to sum or multiply values?

Found it!

 

Screenshot_1.png

 

It's possible to use https://msdn.microsoft.com/en-us/library/azure/mt643789.aspx functions

Just needed quotes to make it work!

 

View solution in original post

efialtes
Level 8

Re: Math function to sum or multiply values?

@Stephen and Microsoft Flow team

Are wdl expressions inside Compose action block officially supported?

If so, these are really good news!

 

Unte
Level: Powered On

Re: Math function to sum or multiply values?

Yes, tested yesterday and it worked fine.

 

But got another issue updating it, as you can set "Copmose" once and using in loop as i++ will not work 😞

djw1005
Level: Powered On

Re: Math function to sum or multiply values?

Tried myself and it doesn't work at all. When I put it in quotes it just fails

afernando
Level 10

Re: Math function to sum or multiply values?

@Unte,

 

Can you please tell us how you added the multiple action? I managed to add a Scope but I can't seem to find Hop and Multiply options.

 

Thanks in advance. 

Unte
Level: Powered On

Re: Math function to sum or multiply values?

https://docs.microsoft.com/en-us/rest/api/logic/definition-language

 

Use WDL as JSON value in Compose element, that's it.

 

"@function(parameters('Hello'))"

 

And you can use this compose element as "@outputs('Compose_name')"

afernando
Level 10

Re: Math function to sum or multiply values?

@Unte legend!

afernando
Level 10

Re: Math function to sum or multiply values?

Hi @Unte,

 

I'm trying to divide column 1 by column 2. So I added the 2 inputs as in the picture below but I can only add the output right above. flow1.JPG

Any thoughts how can I achieve this? Thanks! 

 

Highlighted
Unte
Level: Powered On

Re: Math function to sum or multiply values?

@afernando

 

"@div(outputs('Duration'),outputs('Cartons'))"

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,818)