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:
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:
When I use a dynamic content reference directly in the e-mail, it looks like this when the responder receives an e-mail:
This how it looks in the flow itself:
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.
