Forum Discussion
SharePoint List changing percentage value after input
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.
