web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Values are always mult...

Power Automate

Unanswered

Values are always multiplied by 100 in sharepoint list while updating from excel sheet

(0) Share

Report

Report

Posted on by DineshK_

205

Hi Flow Experts,

I am working on a flow which will copy the data from excel and updates into SharePoint list.

In the excel file i have a YTD CM% column which has a % value like 35% , 45% etc. ..

Once the flow is done , 35% was updated as a 3500% in the SharePoint list .

I don't know how it updating with multiplied by 100.

below the YTD CM% column settings from SP list :

Please help to solve this asap.

Thanks & BR

DK

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

v-mengmli-msft on at

Like (0)

Report
Hi @DineshK_ ,

What is the type of YTD CM% in Excel?

Please check the outputs of Excel YTD CM% column in the flow. If the value is always a hundred times the original, and I recommend that you use the expression to reduce it by a hundred times and then put it in the SP list.

div(<YTD CM% dynamic value>,100)

Best regards,

Rimmon

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Or format the Excel accordingly.
Why use a column called “YTD CM%” and not format it as “Percentage”?

Was this reply helpful? Yes No

Join the conversation