I have a JSON customized list view with about 15 columns. For the end user only about 5 of them are useful or should be available for sorting/filtering.

If I hide a column from the view, the information is also missing in the JSON customized list view.

How can I show only these 5 filters but keep all the info in my list?

  • Can you add a screenshot of how you are using filtering/sorting using JSON formatting? Is this a SharePoint default sorting/filtering? Sep 27, 2021 at 7:20

2 Answers 2


When the column you want to hide is also used in the JSON formatting, then JSON formatting will be invalid. It's by default.

As a workaround, I suggest you create two views. One is for JSON formatting, one is for end users filter.


This is by design, if you want to refer the column in JSON formatting, you have to show that column in list view.

If you remove the column from list view, JSON formatting will not work in this case.

Documentation: Use column formatting to customize SharePoint

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.