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?

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.

Thanks in advance!

​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? 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. Thanks in advance!  Read More

​

We have about 10x existing Logitech Rally bar devices enrolled in the Teams Admin portal.  They are not present in Intune.

When i sign-on to a new device I’m being diverted to InTune and ultimately failing with an error The device isn’t enrolled in device administrator.

I can see the device listed in the Teams admin centre.

Any idea why my recent registrations are attempting to go to InTune?

Thanks

​We have about 10x existing Logitech Rally bar devices enrolled in the Teams Admin portal.  They are not present in Intune. When i sign-on to a new device I’m being diverted to InTune and ultimately failing with an error The device isn’t enrolled in device administrator. I can see the device listed in the Teams admin centre. Any idea why my recent registrations are attempting to go to InTune? Thanks    Read More

​

It appears that a standard user no linger has the ability to change the Time Zone as they once did, and as a local admin still does – Settings -> Time and Language -> Date and Time -> Time Zone. 

Time Zone, and anything related, just isn’t there anymore – hidden from view – when trying to access this as a standard user.

I’ve tried giving the rights through User Rights Assignment, but that didn’t bear any fruit.  

Is there a way to give this right back to the user?

​It appears that a standard user no linger has the ability to change the Time Zone as they once did, and as a local admin still does – Settings -> Time and Language -> Date and Time -> Time Zone.  Time Zone, and anything related, just isn’t there anymore – hidden from view – when trying to access this as a standard user. I’ve tried giving the rights through User Rights Assignment, but that didn’t bear any fruit.   Is there a way to give this right back to the user?    Read More

​

Hi everyone!
I’ve recently integrated Spotify Premium features on my website, and I wanted to discuss how this has improved user engagement. Whether it’s through embedded playlists or seamless music experiences, the platform has added significant value to my digital content. I’m curious to hear if others have integrated Spotify Premium into their websites or platforms and how it has impacted their user interaction and retention. What challenges or benefits have you encountered?”

Looking forward to your thoughts!

​Hi everyone!I’ve recently integrated Spotify Premium features on my website, and I wanted to discuss how this has improved user engagement. Whether it’s through embedded playlists or seamless music experiences, the platform has added significant value to my digital content. I’m curious to hear if others have integrated Spotify Premium into their websites or platforms and how it has impacted their user interaction and retention. What challenges or benefits have you encountered?”Looking forward to your thoughts!  Read More

​

We deployed about 20 laptops in June with the ISO preview release available in late May / early June. Most of them have properly updated to 26100.1742 now. 4 are stuck at 710 though. They don’t show any pending updates. My only idea is to forcefully install 2024-09 Cumulative Update for Windows 11 Version 24H2 for x64-based Systems (KB5043080). Not sure what else to do?

​We deployed about 20 laptops in June with the ISO preview release available in late May / early June. Most of them have properly updated to 26100.1742 now. 4 are stuck at 710 though. They don’t show any pending updates. My only idea is to forcefully install 2024-09 Cumulative Update for Windows 11 Version 24H2 for x64-based Systems (KB5043080). Not sure what else to do?  Read More

​

I was having a conversation with a small business owner, and they mentioned wanting to have an emphasis on improving customer service and ratings, but the process of reading feedback and survey responses was taking up a lot of time. I often spend time analyzing questions and comments from customers, and it’s always a painstaking task dissecting verbatims and identifying themes and insights, let alone develop an action plan to resolve them. With the recent slate of enhancements announced, including Copilot in Excel being generally available, I thought it’d be appropriate to explore some ways Copilot could help make this a much simpler task. 

Tip 1: Use Copilot in Excel to summarize unstructured text in a table

Easily one of the best tips that could save you time when trying to dig into and get insights from feedback verbatims is to ask Copilot to do it for you! Whether it’s customer feedback, survey results, or focus group studies, you can simply ask Copilot to summarize the text data. 

In this example, I open my spreadsheet with customer ratings and feedback. I then open Copilot in Excel on the top right and ask it to “Please summarize the feedback in this sheet.” 

A screenshot of Copilot in Excel summarizing rows of feedback verbatims

Copilot provides a high-level summary of the feedback, group it into different themes. Very quickly, with little effort, we already have some insights that we could start working with!

Tip 2: Add specifics to your prompt to get more precise insights

As we’ve covered in previous editions, how you craft your prompt matters. Let’s say you want to drill down further and get more insights focused on more negative reviews and areas of improvement. 
 
Using the same example data here, you could then write a prompt like, “Hone in on Feedback with Ratings of less than 3, can you summarize this feedback and provide key themes and areas of improvement.” 

Copilot first explains what it’s doing: 

A screenshot of Copilot outlining how it’s going to summarize feedback from responses with a rating of less than 3

Then, based on the focused information, gives me back more detailed and specific information so that I can focus on specific aspects of customer service that I want to address, including tips on how to take action. 

A screenshot of more detailed insights focused on neutral to negative feedback analyzed
A screenshot of recommendations by Copilot on how to improve customer service based on the feedback analysis

Just like that, we were able to find insights from raw feedback that would’ve otherwise taken time to parse through manually, and I can instead focus on building an action plan to help address my issues! 

Let me know in the comments below how else you’ve been using Microsoft 365 Copilot, or if there are tips you’d like to see!

​Microsoft Tech Community – Latest Blogs –Read More