Help with Query String Filter and Web Part Connection – Stuck with 5000 Items Threshold

Hi everyone,

I’m encountering a frustrating issue with dynamically filtering data on Web Part Pages in SharePoint using the Query String (URL) Filter Web Part, and I’d love some guidance.

Setup:

• I have a document library with over 15,000 items (and growing). Two relevant columns are School and Archived—both of which are indexed.
• No single school will ever have more than 5,000 documents, so I assumed I could bypass the 5,000-item threshold when filtering the document library on the web part page.

My Configuration:

• I’m using a Query String (URL) Filter Web Part to dynamically filter multiple Document Library Web Parts based on the "School" parameter passed via the URL (e.g., ?School=XYZ).
• This works perfectly without any filters applied to the document library web part views.

The Problem:

• As soon as I add a filter in the document library view (e.g., Archived = Yes), I hit the infamous “cannot exceed 5000 items” error.
• This makes me believe that the archived filter in the document library web part triggers before the URL query string filter, causing the list view threshold error.

My Goal:

• I need to figure out how to make the Query String (School) filter apply first, before any additional view filters like “Archived = Yes” get applied.

Previous Working Setup (SharePoint Designer):

• When SharePoint Designer (SPD) was available, I could set up parameters using “Get Parameters From” rather than filters, allowing me to prevent the 5,000-item error by filtering inside the document library web part. 
• I’ve used this setup on other pages successfully in the same environment, but I no longer have access to SPD.
• Now, I get the error: “The consumer Web Part did not provide schema information.”

Ideas and Solutions I’ve Tried (and where I’m stuck):

• Parameter-Based Filtering: I want to be able to add a parameter like School = {Param1} inside the document library view filter. This used to work when I could use SPD. Does anyone know of a way to enable parameter-based filtering now that SPD isn’t available?
• Script Editor/Web Part Sequence: I think the problem might be that the Archive column (with over 5,000 items) loads before the School filter gets applied. Is there a way to force the School filter to load first, possibly using a Script Editor Web Part to control the filter sequence? I had AI try and help me, but I didn't have the results.
• 

Constraints:

• I cannot install any custom solutions like SPFx, and I have to use Web Part Pages because the modern experience doesn’t support the Query String URL Web Part in the same way.

Willing to Pay for Help:

• If anyone has expertise with these issues and could offer support or guidance, I’m open to hourly consulting, as I’m really stuck and this is impacting a large part of my site’s functionality.

Thanks in advance!