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
Highlighted
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
Highlighted
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! 

 

Unte
Level: Powered On

Re: Math function to sum or multiply values?

@afernando

 

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

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

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