SharePoint - Filter stacking

I reviewed the question and got answers most of my previous queries. However, I’m still unclear on how the link is added or generated in the list.

I assume there is a text field where values are entered, and JSON formatting is used to generate the cross-reference link.

• I created a library where all documents are stored, and it includes a Document_ID text column. I assign an ID to each document as needed.

• I also have another list that contains the same Document_ID column (configured as a text column rather than a hyperlink), where the Document ID value is entered. Using JSON formatting, I generate cross-reference links from the list to the library.

  This JSON works for filtering a single ID; handling multiple IDs would require a different approach.

The URL structure contains the following components:

• MSTrainings – Site name
• CMS – Document library name
• CMS DS Content Type.aspx – Library view name

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "white-space": "normal"
  },
  "attributes": {
    "class": "sp-css-backgroundColor-warningBackground"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "margin-right": "2px",
        "margin-left": "5px",
        "font-size": "18px"
      },
      "attributes": {
        "iconName": "FileSymlink"
      }
    },
    {
      "elmType": "a",
      "attributes": {
        "href": {
          "operator": "+",
          "operands": [
            "https://YOURTENANT.sharepoint.com/sites/MSTrainings/CMS/Forms/CMS DS Content Type.aspx?FilterField1=Document_ID&FilterType1=Text&FilterValue1=",
            "[$Document_ID]",
            "&DefaultItemOpen=1"
          ]
        },
        "target": "_blank"
      },
      "style": {
        "color": "#0078d4",
        "text-decoration": "none",
        "font-weight": "600",
        "padding": "2px 4px",
        "border-radius": "3px",
        "transition": "all .2s ease-in-out"
      },
      "txtContent": "[$Document_ID]"
    }
  ]
}

If my post solved your issue or answered your query, please mark it as a Solution and give it a Like.

Virendrak,

Thank you for your quick response. I was able to find out the issue here, someone had gone in and added some filtering on the list.  I have since removed and locked down the list. 

I am however having another issue with filtering on another list.

1. The list has 9,444 items; I have a filter set on the Start Date: Today or later and Status: Accept on a grouping for the Start Date
2. The label (Start Date:  6/1/2026 (18) the count is off, it's not 18, it's actually 26 items, so the label is not matching the items when I'm directly in the list and selecting all the items for this date
3. I also cannot export the file to excel anymore; it's throwing a "You do not have permission to view the entire list because it is larger than the list view threshold enforced by the administrator"; this just started happening on the filter and the export just recently

Any help would be appreciated.

Hi, I have a few clarifications regarding your setup:

• When you mention Document ID, are you referring to:

  • The SharePoint Document ID feature (enabled at the Site Collection level),
  • OR A custom column, or
  • OR The out-of-the-box ID column in the library/list?
• How are you constructing the URL for filtering?
  • Is it manually entered?
  • Generated through some automation (Power Automate, custom approach, etc.)?
  • Or created using JSON column formatting?
• This hyperlink column - is the intent to:
  • Open a specific document directly, or
  • Navigate to the document library filtered to show one or more documents (based on the ID)?

Understanding this will help identify why multiple filter values are being applied or stacked.