cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nmccool
Level: Powered On

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!



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!



View solution in original post

Community Support Team
Community Support Team

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
Level: Powered On

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
Level: Powered On

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
Level: Powered On

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 Team
Community Support Team

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.

nmccool
Level: Powered On

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 Team
Community Support Team

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
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 (Last 30 Days)
Users online (6,124)