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
Super User
Super User

Re: multiplying in a word template

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 blog

View solution in original post

8 REPLIES 8
Super User
Super User

Re: multiplying in a word template

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 blog

View solution in original post

Community Support
Community Support

Re: multiplying in a word template

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.

nmccool Helper II
Helper II

Re: multiplying in a word template

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

Re: multiplying in a word template

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

nmccool Helper II
Helper II

Re: multiplying in a word template

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

Community Support
Community Support

Re: multiplying in a word template

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.

Highlighted
nmccool Helper II
Helper II

Re: multiplying in a word template

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.  

Community Support
Community Support

Re: multiplying in a word template

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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
Users online (7,009)