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! 

 

Unte
Level: Powered On

Re: Math function to sum or multiply values?

@afernando

 

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Kudoed Authors
Users Online
Currently online: 363 members 6,894 guests
Please welcome our newest community members: