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

Float with error

I have one calculated column in SP-lists. I am trying to get the value from this column in the flow action as a part of e-mail body. I have the classical problem with too many zeroes when I refrence to a column as a dynamic content. 

To address this issue I have done two things so far: 

- I used round-formula in the calculated column: Round( Value(['many column refrences i my SP-list']); 0 )

- I then tried to use Float function inside the email body: float(triggerBody()?['name of my calculated column']), after I read this post.

 

Result of this is that I am getting this error message in failed e-mail part of the Flow:

InvalidTemplate. Unable to process template language expressions in action 'Send_an_e-mail' inputs at line '1' and column '1814': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'. 

 

How do I fix this, guys? 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Float with error

Hi @Jako ,

On your side, it is not necessary to add a "initialize variable" action within your flow. On my above solution, I just want to show you how do convert the "Totalsum avrunder" column into the expected value you want.

Within your flow, you could directly use the following expression witin the "Send en e-postmelding" action (as that within my "Send an email notification (V3)" action):

split(string(body('Oppdater_element')?['Totalsum avrunder']),'.')[0]

 

If you want to add a "Intialize variable" action within your flow to store the converted "Totalsum avrunder" value, please add a "Initialize variable" action under your "Oppdater element" action.

 

Yes, the "Update Item" action within my flow represents a update in the SP list with refrence to calculated column.

 

In addition, the "Send an email notification (V3)" action is a preview version of the "Send an email" action. It would not make effect on the result within your flow.

 

More details about using expression in flow actions, please check the following blog:

https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/

 

Best regards,

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

View solution in original post

8 REPLIES 8
Community Support Team
Community Support Team

Re: Float with error

Hi @Jako ,

Could you please share a bit more about the Calculated column in your SP list? Does the Calculated column return a Number value?

Further, could you please share a screenshot about your flow's configuration?

 

Based on the issue that you mentioned, I think there is something with the float expression you used in your flow. Actually, the float function is used to convert a string version for a floating-point number to an actual floating point number. The argument you typed within the float function should be a Number string value.

 

I have made a test on my side, please check the following screenshot:5.JPG

 

On your side, please consider modify your float formula within your flow as below:

 

float(string(triggerBody()?['name of my calculated column']))

If you want to directly type above formula within the email body of the "Send an email" action, please type the following formula:

 

@{float(string(triggerBody()?['name of my calculated column']))}

6.JPG

 

Also please check the Calculated column returns a proper value within your flow. You could add a "Compose" action within your flow, then set the Inputs field to your Calculated column Dynamic content, then run your flow, then check if the proper value is displayed within the "Compose" action.

 

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jako
Level: Powered On

Re: Float with error

Thank you for your reply, @v-xida-msft

 

I have tried to make it work with the suggestions, but still no success. 

I am sure I did not provide with enough info, so I will start from the begining. 

 

So I have a flow where the information filled in the MS forms is gathered in the SP list. 

Then follows the approval with following emails, there is also update in the SP list. 

Here is the overview: 

overview flow.JPG

 

One of the coulmns in the SP list is not filled in by flow, but created to sum up other columns in that list. 

It is create as a Calculated colmn with number value. The formula inside multiplies the values in each column with spesific number, in other words the value in the column is the number of orders which is then multiplied with spesific price. There is also ROUND formula. It all looks like this: 

 

=ROUND( Value(([SMØRBRØD ASSORTERT] * 34) + ([HVERDAGSSKIVER ASSORTERT] * 31) + ([BAGUETT MED OST OG SKINKE] * 51) + ([SANDWICH MED KYLLING OG BACON] * 53) + ([CROISSANT MED SKINKE] * 43) + ([CROISSANT MED REKESALAT] * 44) + ([WRAPS MED KYLLING] * 45) + ([PASTASALAT MED BRØD (450g)] * 105) + ([LUNSJTALLERK (430g)] * 105) + ([FRUKT I BITER (180g)] * 31) + ([WIENERBRØD] * 28) + ([FORMKAKE] * 25) + ([RUNDSTYKKE MED OST] * 29) + ([RUNDSTYKKE MED SKINKE] * 29) + ([FROKOSTBRØD] * 46) + ([PIZZASNURR] * 35) + ([Diett] * 15) + ([Buffe] * 72) + ([MARSIPANKAKE] * 439) + ([FLØTEKAKE] * 419) + ([SJOKOLADEKAKE] * 419) + ([MINERALVANN (0,5L)] * 30) + ([APPELSINJUICE (0,25L)] * 24) + ([EPLEJUICE] * 24) + ( [KAFFE (1L)] * 38) + ([TEPOSE] * 10) + ([Transport ]) + ([Emballasje])); 0 )

 

Here is the overview of the SP list: 

sp list.JPG

When I use a dynamic content reference directly in the e-mail, it looks like this when the responder receives an e-mail:

email.JPG 

 

This how it looks in the flow itself: 

flow email.JPG

 

 

 

The challenge here is the remove the extra zeroes in the e-mail message. 

 

I hope this has made it more clear. 

I have tried with initialize variable and compose, but I was not successful. I am not sure where in the flow I should put it and what "Value" I should give it. 

Jako
Level: Powered On

Re: Float with error

Thank you for your reply, @v-xida-msft

 

I have tried to make it work with the suggestions, but still no success. 

I am sure I did not provide with enough info, so I will start from the begining. 

 

So I have a flow where the information filled in the MS forms is gathered in the SP list. 

Then follows the approval with following emails, there is also update in the SP list. 

Here is the overview: 

overview flow.JPG

 

One of the coulmns in the SP list is not filled in by flow, but created to sum up other columns in that list. 

It is create as a Calculated colmn with number value. The formula inside multiplies the values in each column with spesific number, in other words the value in the column is the number of orders which is then multiplied with spesific price. There is also ROUND formula. It all looks like this: 

 

=ROUND( Value(([SMØRBRØD ASSORTERT] * 34) + ([HVERDAGSSKIVER ASSORTERT] * 31) + ([BAGUETT MED OST OG SKINKE] * 51) + ([SANDWICH MED KYLLING OG BACON] * 53) + ([CROISSANT MED SKINKE] * 43) + ([CROISSANT MED REKESALAT] * 44) + ([WRAPS MED KYLLING] * 45) + ([PASTASALAT MED BRØD (450g)] * 105) + ([LUNSJTALLERK (430g)] * 105) + ([FRUKT I BITER (180g)] * 31) + ([WIENERBRØD] * 28) + ([FORMKAKE] * 25) + ([RUNDSTYKKE MED OST] * 29) + ([RUNDSTYKKE MED SKINKE] * 29) + ([FROKOSTBRØD] * 46) + ([PIZZASNURR] * 35) + ([Diett] * 15) + ([Buffe] * 72) + ([MARSIPANKAKE] * 439) + ([FLØTEKAKE] * 419) + ([SJOKOLADEKAKE] * 419) + ([MINERALVANN (0,5L)] * 30) + ([APPELSINJUICE (0,25L)] * 24) + ([EPLEJUICE] * 24) + ( [KAFFE (1L)] * 38) + ([TEPOSE] * 10) + ([Transport ]) + ([Emballasje])); 0 )

 

Here is the overview of the SP list: 

sp list.JPG

When I use a dynamic content reference directly in the e-mail, it looks like this when the responder receives an e-mail:

email.JPG 

 

This how it looks in the flow itself: 

flow email.JPG

 

 

 

The challenge here is the remove the extra zeroes in the e-mail message. 

 

I hope this has made it more clear. 

I have tried with initialize variable and compose, but I was not successful. I am not sure where in the flow I should put it and what "Value" I should give it. 

Community Support Team
Community Support Team

Re: Float with error

Hi @Jako ,

Based on the Calculate formula you used within your SP list, I think the "Totalsum avrunder" column should return a Number value without decimal places, is it true?

 

If the result the "Totalsum avrunder" column returns is a Number value without decimal places, I think the string function and split function could achive your needs:
1.JPG

Within your Email body, you could take a try with the following formula:2.JPG

Within your the email body of your "Send Email" action, type the following formula:

split(string(body('Update_item')?['Totalsum avrunder']),'.')[0]

Note: The 'Totalsum avrunder' represents the Calculated column in your SP list.

 

Please take a try with above formula within your email body, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jako
Level: Powered On

Re: Float with error

Hi again, @v-xida-msft.

 

It is correct that "Totalsum avrunder" should return number value without decimals. This is also what I chose when I was creating it. 

 

I have no doubt that what you suggest is the solution, but I am not sure where do I place "Initialize variable" as a integrated part of my existing flow. I am also not sure what to put as "Value"

 

initialize variable.JPG

 

 

In the next part you have a update in SP. 

Is that a update in the SP list with refrence to calculated column? 

update and split.JPG

 

Highlighted
Jako
Level: Powered On

Re: Float with error

@v-xida-msft , one more thing. I see that you use E-mail "V3", while I dont. 

 

Do you know if this make any diffrence? 

Community Support Team
Community Support Team

Re: Float with error

Hi @Jako ,

On your side, it is not necessary to add a "initialize variable" action within your flow. On my above solution, I just want to show you how do convert the "Totalsum avrunder" column into the expected value you want.

Within your flow, you could directly use the following expression witin the "Send en e-postmelding" action (as that within my "Send an email notification (V3)" action):

split(string(body('Oppdater_element')?['Totalsum avrunder']),'.')[0]

 

If you want to add a "Intialize variable" action within your flow to store the converted "Totalsum avrunder" value, please add a "Initialize variable" action under your "Oppdater element" action.

 

Yes, the "Update Item" action within my flow represents a update in the SP list with refrence to calculated column.

 

In addition, the "Send an email notification (V3)" action is a preview version of the "Send an email" action. It would not make effect on the result within your flow.

 

More details about using expression in flow actions, please check the following blog:

https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/

 

Best regards,

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

View solution in original post

Jako
Level: Powered On

Re: Float with error

Success!!!

 

Thanks a lot, @v-xida-msft

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,162)