SharePoint Online JSON View\Row Formatting - Show \ Hide Based on Filtered or Not

Question

Hello Community,

I'm working in SharePoint Online and I need to create a view that will hide or show data conditioned on whether or not a filter is applied. Is this possible? Has anyone else done this? If so please provide guidance and examples.

Thanks!

Tom

Answer 1

Hi @Tom Molskow ,

I don't know if my understanding is correct. You want to present the filtered data as a view, right?

If so, of course you can.

For example, in my test, I filter out the modified document from the modified by column.

Then select save view as, which I named by me. That is, when I choose the view by me, I can see all the documents I have modified.

For more information about view, please see:

https://support.microsoft.com/en-us/office/create-change-or-delete-a-view-of-a-list-or-library-27ae65b8-bc5b-4949-b29b-4ee87144a9c9

https://support.microsoft.com/en-us/office/create-a-custom-view-of-a-document-library-8f6b08e0-a9a0-4232-9b9b-b374a2ad3da7

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Sorry, I guess I didn't state my question very well.

I am working with two List View Web Part (LVWP) in SharePoint Modern.

Web Part A - a LVWP that, through dynamic filtering, provides a filter to Web Part B.

Web Part B - receives the filter from Web Part A, and displays the filtered view

For web part B, the web part is initially not filtered. Ultimately what I'm looking to do is to prevent any data showing in the web part B until after the dynamic filter is provided by Web Part A.

One way I thought to do this was through JSON formatting, where the format would hide all rows and\or columns until a filtered was applied.

Another way was to pre-filter Web Part A.

I'm also open to any other suggestions for resolving this issue.