Expression for multiplying an item (Excel percentage column)

(0) Share

Report

Posted on by WorkingRicardo

818

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)

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Hi @WorkingRicardo ,

Please try this expression:

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

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No