1

I have a strange behavior in my SharePoint application. I am using a SharePoint list form in which fields must only appear when the right user is logged in with his/her account. The formula works fine using @me term but unfortunately not for all users. It seems that in some cases the information behind @me cannot be used. Does someone know why for some Accounts it is working properly and for others not?

Update: I found the solution for the issue. It seems that in some cases the email addresses retrieved from @me function show for whatever reason capital letters for the first letters in first name and surname. Keeping that in mind in my conditional formula it works perfectly.This behavior occurs by the way also in person/group column showing work email addresses.

Thanks to all of you for your comments and support.

10
  • Are those external / guest users? Can you show us the expression you have used and on which type of field you have added this expression? Commented Mar 24, 2023 at 4:40
  • All users belong to the same company. The conditional formula is used for a single line text field. I used an expression which checks @me against a substring of string provided via lookup column: =@me==substring([$lookup],1,50).
    – Jan
    Commented Mar 24, 2023 at 7:42
  • All users are having access to source list from where lookup column is used? Also, what are the contents in the [$lookup] column, user email or user names? Can you add screenshots if possible? Commented Mar 24, 2023 at 7:48
  • yes users have access to source list. Content in the look up column is calculated column showing a string containing amongst others the email address of the required Person coming from single line text column. Screenshots unfortunately not possible yet.
    – Jan
    Commented Mar 24, 2023 at 8:09
  • I observed another strange aspect while checking the Account of one person for which it is not working. It seems that the "me" content cannot be retrieved. I did that via a trick: 1. Create single line text column called "Me", 2. Create calculated column and refer to "Me" column, 3. Delete "Me" column. In the Not working Account I retrieve "0". In my Account which works, I retrieve the desired Information. Perhaps this helps
    – Jan
    Commented Mar 24, 2023 at 8:22

1 Answer 1

1

If the issue is with the capital/lower case, you can use toLowerCase() operator (or toUpperCase()) in JSON formatting to convert it to same case.

Example:

=if(toLowerCase([$AssignedTo.email]) == toLowerCase(@me), 'true', 'false')

Output:

Text field showing when task is assigned to me:

enter image description here

Text field not showing when task is assigned to someone else:

enter image description here

You can adjust your formula using toLowerCase() operator according to your requirements.

Documentation: Show or hide columns in a SharePoint list or library form

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.