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!

 

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!

 

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 Smiley Sad

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

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow 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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 225 members 4,647 guests
Please welcome our newest community members: