Expression for multiplying an item (Excel percentage column)

Like (0) Share

Report

Posted on 11 Jun 2024 11:31:56 by WorkingRicardo

774

So I have this Excel file that I use to send data to a Sharepoint number column. One of the Excel columns is of Percentage type, so even though in Excel is shown as 70%, in PowerAutomate this is processed as 0.7. For ease I want to at least have updated to Sharepoint column a 70 (I do things to this number in PowerApps so it is handled correctly as a %, so don't mind that part: i just need to have written a 70).
And no, I cannot edit the Excel file to change the type of column.

So, I need an expression that multiplies by 100 this: items('Apply_to_each_1')?['Discount Project']

(Discount Project) is the name of the Excel column.

I ChatGPTed this query but got an expression that led to an error, but maybe this serves as the begining:

mul(items('Apply_to_each_1')?['Discount for Project Business'], 100)

All responses (1)

Answers (0)

v-yetonggu-msft on 12 Jun 2024 at 01:56:36

Like (0)

Report
Re: Expression for multiplying an item (Excel percentage column)

Hi @WorkingRicardo ,

Please try this expression:

formatNumber(items('Apply_to_each_1')?['Discount for Project Business'],'P0')

Best Regards,

Sunshine Gu