Forum Discussion
SharePoint List changing percentage value after input
Hi,
We have a SP List incorporated on out SP site to collect data.
Two of the column are formatted as Number columns with "Show as percentage" checked.
For the past two months, input was as expected.
When we enter value: 74, in the Form; 74% is displayed in the list.
As of June 08, 2024 the behavior of the column in the List has changed.
Now, if we enter the same value of: 74, in the Form, it displays as: 0,74%. (or just 0,5% depending on how may decimal places we use)
When we troubleshoot, no explanation can be found for this error.
Also, historical data from previous months is unchanged and still shows a whole number in percent.
We have also tried to add a new Number column, showing as percentage, and the error still prevails.
Footnote: After submitting the Form, for a second only, 74% is shown before it changes to 0,74% in the List. view.
I should mention that the list is used in a PowerBI report.
Have there been any changes to SP List or could the PowerBI formatting override the List column formatting?
6 Replies
A resolution to this issue was identified below. It involves changing the Offline Client Availability to 'No'.
Microsoft Sharepoint List percentage value changes with no reason - Microsoft Community- This workaround worked for me
- Anuwar
J_Sonn - have you by chance found a fix yet? I'm having a similar issue. I copied a list from one SharePoint site to another. The original list works fine. However, percentages entered into the copied list have the same strange behavior you mentioned. If I enter 11%, it looks good for a few seconds, then it changes to 0.11%.
mgs5046 - Still no permanent fix.
Only workaround atm is to add 00 to the end of the number. (15% would be 1500).But I do not consider it to be a fix, as it is not supposed to be entered like that.
Still strange and puzzling is the fact that old entries do not change or require “00” even when I Edit them. Do you experience the same?So still open for suggestions.
Could it be a global list setting that could trigger this to happen?
J_Sonn - yes, I have the same experience. Old entries remain unchanged.
I also wondered about settings. I'm not very familiar with SharePoint, so I'm sure I could have easily overlooked something, but I wasn't able to find a setting that made a difference.
I'm using entries from my list in a Power Automate flow. So for now, I've changed all percent columns in the list to numbers, and I am just dividing by 100 in the flow. This works, but it's less intuitive for users when adding entries to the list.
