Forum Discussion
SharePoint list column auto capitalizes single words
N_MCLEOD I am unable to reproduce this issue. When I add 'false' in a single line of text column, it retains the same value with lower case:
However, if you have access to edit the power apps, for safer side you can use Lower() function to convert any uppercase letters in the string to lowercase.
Documentation: Lower, Upper, and Proper functions in Power Apps
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hi ganeshsanap, thanks for the info. I've done some more testing today and I'm sure that the cause of the capitalization is a sync issue - changes not saving properly whilst using Modern UI and 'Edit in Grid View'. This save issue appears to be a common bug repeatedly raised on this forum
e.g. https://answers.microsoft.com/en-us/msoffice/forum/all/sharepoint-edit-in-grid-view-issue/017c778e-666b-42e6-aed4-30e309b7324d?page=2
In classic UI, quick edit, no problems saving. In Modern UI, Edit in Grid View, changes don't save - spinner spins forever. I'm having to force refresh the browser in order to see the changes I made. Forcing the refresh before it has finished saving is very likely to be why the entry becomes capitalized, but obviously can't prove that. I'm going to stick to using Power Automate or Power Apps to update my lists - sad state of affairs!
- ganeshsanapSep 15, 2022MVP
N_MCLEOD How many items are you trying to add at a time using grid view?
I just tried adding 5-10 items with lower case text and it got saved in list without any issue.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- N_MCLEODSep 15, 2022Copper ContributorThanks. Just trying to do one! Like you, this has been working fine for me up until the past week or so. I've tried clearing all my cache and signing out of office, tried using In Private mode - all the same. If anyone has had these sync issues and found a way to resolve, I'd love to hear!