Convert Decimal in this Flow to Percentage and £ values for HTML Table

(0) Share

Report

Posted on by CU10111616-0

I have a flow that looks like this:

And it exports a table to email similiar to this:

I would like to change the values to £ and the GP to percetnage. Would the Format number fucntion be the best way? I have been trying to figure it out for some time.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

developerAJ 4,763 on at

Like (1)

Report
Copy link

Link copied!

{
"Sales Price": "concat('£', formatNumber(item()?['SalesPrice'], '###,##0.00'))",
"Cost Price": "concat('£', formatNumber(item()?['CostPrice'], '###,##0.00'))",
"GP %": "concat(formatNumber(mul(item()?['Gp'], 100), '0.00'), '%')"
}

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like (1)

Report
Copy link

Link copied!

concat('£', formatNumber(item()?['SalesPrice'], '###,##0.00')) //SalesPrice replace with your column name
concat('£', formatNumber(item()?['CostPrice'], '###,##0.00')) //CostPrice replace with your column name
concat(formatNumber(mul(item()?['Gp'], 100), '0.00'), '%') // GP replace with column name. i am multiplying by 100 but if this is not required

concat(formatNumber(item()?['Gp'], '0.00'), '%')

Was this reply helpful? Yes No
Verified answer

Tomac 4,048 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @CU10111616-0

Yes, the formatNumber() function is what you want.

To convert a number to a percent, use this format:

formatNumber(0.2200435,'P')

To convert to currency in GBP, you would use this format:

formatnumber(15.3,'C2','en-gb')

To get the information into an array using these formats, you'll use the Select action:

IMPORTANT NOTE: The data that comes from Excel will always be brought over as a string, so you'll need to wrap your values in the float() function, like this:

formatnumber(float(item()?['Sales Price']),'C2','en-gb') formatnumber(float(item()?['Cost Price']),'C2','en-gb') formatNumber(float(item()?['GP %']),'P')

Was this reply helpful? Yes No