cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nmccool
Helper II
Helper II

multiplying in a word template

trying for weeks to multiple the quanity and cost cloumns, then subtotaling, adding tax and totaling it all in a word template.  Started with and without (int) and (float); getting errors, see formula and errors.   formula to add.JPG
error.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User III
Super User III

Hi  @nmccool 

 

Try to do the int coversions inside two compose flow steps for both response details. Finally pass these two compose outputs in your multiply expression.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

8 REPLIES 8
abm
Super User III
Super User III

Hi  @nmccool 

 

Try to do the int coversions inside two compose flow steps for both response details. Finally pass these two compose outputs in your multiply expression.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

v-litu-msft
Community Support
Community Support

Hi @nmccool,

 

Could you please share an example output of the response?

Do these values of quanity and cost column have dots?

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

so i took your advise, and created an int for both items needing to be multiplied and then the compose to multiply and it doesnt like it...I am obviously doing something wrong .... just know I am new to Flowcreated int for both being multiplied.JPGsolution.JPG

nmccool
Helper II
Helper II

then i changed to a float, and it worked on the fo=irst cost, so i went all the way down, and i got the errorserror 2.JPG

the cost will, as it will be dollars and cents, but it will not have a dollar sign, see some examples of the cost and qtycost qty.JPG

Hi @nmccool,

 

If it has a dot, you can use the split() function to process the value, for example:

The 13.46 is the value I get from the excel table. If I want to get the integer part 13, I need to convert it into String first, then use the split to get the array [13,46], then get the first member split()[0] to get 13, then convert the String "13" into an integer.

int(split(string(outputs('Compose_2')),'.')[0])

Annotation 2019-10-21 164753.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

i dont see how this will work.  The numbers i have to convert arent known until someone updates Microsoft Form i have linked to SharePoint; thats where the info is coming from.  Looks like you are converting info already known.  

Hi @nmccool,

 

Yes, the value in my example processed is known, but this is just a method, you can use the method to process the field get from Excel.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (44,123)