Summary The SharePoint “Move To” dialog can hang indefinitely with a spinning icon due to list view threshold (<5,000 items). The real issue: view aggregations (Totals) set to “Count” in the view schema. Fix: turn Totals to “None” in the view settings or set Aggregations Value="Off" in the schema. Use PnP PowerShell to inspect and confirm the view’s HtmlSchemaXml for the Aggregations property. Table of Contents The Problem Initial Investigation The Real Culprit: View Aggregations Inspecting View Schema with PnP PowerShell The Fix How to Disable Totals in SharePoint Verification Key Takeaways References The Problem We encountered a persistent issue where the “Move To” dialog in specific SharePoint document libraries would hang indefinitely with a spinning icon, preventing users from moving files.

Introduction When building solutions in Copilot Studio, you may use Adaptive Cards to collect multi-choice input from users. The selected values from a multi-select field are stored as a table variable. However, if you want to pass these values to an Agent Flow (for example, to create a SharePoint list item), you need to convert the table variable into a single string. This post shows how to concatenate the selected values from a multi-choice Adaptive Card field into a semicolon-separated string using the concat function in a Set Variable value action within your topic.

SharePoint Online has a list view threshold (LVT) of 5,000 items, which can cause performance issues if exceeded. This post provides a workaround through filtering libraries/lists to stay within this limit and avoid common problems associated with large lists. The Problem When a SharePoint library exceeds the 5,000-item threshold, various issues can arise. These include: Inability to Browse Folders Navigating through folders becomes challenging and sometimes impossible through desktop office apps (Excel, Word,etc.

Overcoming SharePoint’s List View Threshold with CAML Queries in PowerShell Encountering the list view threshold error in SharePoint when dealing with lists exceeding 5,000 items is a common challenge. Using CAML queries within PowerShell scripts offers a server-side solution to efficiently filter and retrieve data, yet is prone to the list view threshold error. Sample script This is the sample PowerShell script querying the specified SharePoint list using CAML query.