I have a flow that is taking data from a table column in excel that is calculated from two others (essential working out an NPS score). When I attempt to include this data in an email its using the format like 00.0123456789. How do i convert that so that it is just a whole number? I have searched and searched and just cannot find a solution. Any helps appreciated 🙂
Unfortunately, Power automate does not yet include a round() expression. I suggest adding a column to the Excel table and use Excel expressions to do the rounding - you can hide the column if you want. Then, have Flow retrieve the rounded column for the email.
The value in excel is already rounded up:
to 0 decimals but it still converts to
But in the email it still does this:
The number in Excel is just formatted to show a whole number - the actual value is still a decimal. See my example below using the roundup() expression on Excel.. Add a column, use roundup() and refer to it in Flow.
Ah yea so it works to add the data into a random cell but not into a cell that is part of a table. In the table it just doesn’t seem to work. And then there’s no way of pulling the data from the cell outside the table (unless I’m missing something)
While I did not explicitly state it, my suggestion is to add the additional column with the roundup() expression immediately next to an existing column. If you do so, the new column will automatically become part of the table. If it isn't automatically added, you can extend the table to include it. Once it is in the table, you can reference it in your Flow.
I know how to add a column... as you can see in the screenshot above I’ve added it, added the formula and the formula in “column 4” isn’t working....
Ty referencing the cell directly (by row and column) rather than using the @ operator.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!