Forum Discussion
SSantos
Aug 25, 2022Copper Contributor
JSON column formatting extract first and last name from @me
Can we extract other information from me? For example, rather than getting the email address, I'd like to only display the First and/or Last names. I tried @me.givenname and others but didn't work. ...
DoraL420
Jul 17, 2023Copper Contributor
This code worked brilliantly for me, however there was a slight issue. If the logged in user's email is not already capitalised in the format Firstname.Lastname@... the code won't capitalise the first letters. Is there possibly a work around that would capitalise the letters of a name from the email format firstname.lastname@... ?
ganeshsanap
Jul 17, 2023MVP
DoraL420 Currently, there is no default operator/function available in SharePoint JSON formatting to auto-capitalize first letter in the word.
SharePoint JSON formatting currently only supports toLowerCase() and toUpperCase() to convert string into all lower case and upper case. Also, these operators/functions are only supported in SharePoint Online and not in SharePoint 2019.
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.