Converting table data as percentage for email body

(0) Share

Report

Posted on by GreatOne

Hi All,

As a heads up - I am very new to power automate.

Hopefully someone can advise me on below issue. I am trying to automate an email that gets its email body populated from SharePoint excel data table. One of the columns in excel is percentages and I am struggling to find a way to convert it in power automate as percentage as well so that on email body it would show same table as per excel file. I have tried the 'formatnumber' expression, but where it ask for the number in the expression I am at a loos how to reference tables data.

As an example - the expression is 'formatNumber(number,’P0′)' and my end goal is formatNumber("reference data in table",’P0′).

Is that achievable, or I have to work around it in a different way?

Flow FlowTable data selection

Categories:

General topics

All responses (4)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @GreatOne ,

Please try this expression

formatNumber(item()?['ColumnName'],'P0','uk-UK')

Best Regards,

Sunshine Gu
GreatOne 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sunshine Gu,

Tried and getting below error:
failed: 'The template language function 'formatNumber' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'.
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @GreatOne ,

Please use the float function to convert item()?['ColumnName'] from string type to floating point type.

formatNumber(float(item()?['ColumnName']),'P0','uk-UK')

Best Regards,

Sunshine Gu
GreatOne 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Had another error, but figured out it was due to some of the values being non-percentage, so fixed it. Other then that the float expression did the job and now works like a charm, thank you!