> ## Content Index
> Fetch the complete content index at: https://blog.lsonline.fr/llms.txt
> Use this file to discover other available public pages before exploring further.

# Microsoft List - Hide sensible column values
- URL: https://blog.lsonline.fr/2024/03/30/ms-list-hide-sensible-column-values/
- Published: 2024-03-30T15:48:00.000Z
- Updated: 2024-04-22T20:46:32.000Z
- Description: Simulate a password manager with Microsoft List by replacing string values with stars, then manage list and/or item permissions
- Author: Laurent Sittler
- Tags: SharePoint Online, Development, Getting Started, Modern Experience, Microsoft 365, SharePoint

In this blog post, we will see how it is simple to use Microsoft Lists/SharePoint lists to answer simple needs that could help you.

Do you never have some information that you want to store in a list rather than an Excel file but have one or several values that should not be "clearly" visible when you are opening the list?

Examples:

- You have some logins and passwords that you want to share with some people on your team. *Of course, a password manager is more appropriate*.
- You have a list of candidates with some personal information

I'm sure, you who are reading this blog post have another interesting use case (do not hesitate to share them via a comment).

What does it look like?

**Before**

![](https://blog.lsonline.fr/content/images/2024/01/Screenshot-2024-01-07-at-18.40.54.jpg)

**After**

![](https://blog.lsonline.fr/content/images/2024/01/Screenshot-2024-01-07-at-18.42.06.jpg)

![](https://blog.lsonline.fr/content/images/2024/01/Screenshot-2024-01-07-at-18.42.18.jpg)

Without taking more of your time, here is the JSON format to apply on a field/column of your list (any string field should work):

```json
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "forEach": "choiceIterator in split(@currentField,'')",
      "elmType": "span",
      "txtContent": "*"
    }
  ]
}
```

- **forEach**: need an array to loop on the index of it. This is why we are using `split` the current field for all chars `''`
- **txtContent**: rather than displaying the chars of the value, we are displaying a `*`

So simple isn't it? ?

Now you can manage permission to the list or by item if you want to share all or a part of the items with someone else.

Now it is your turn.
  
  
Hoping this post will help you ?