cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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 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 blog

Power Automate Video Tutorials

View solution in original post

8 REPLIES 8
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 blog

Power Automate Video Tutorials

View solution in original post

Highlighted
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.

Highlighted

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

Highlighted
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

Highlighted

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

Highlighted

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

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.  

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (7,464)