Introduction Recently, I was asked how to export the first-level folders in document libraries using PnP PowerShell site provisioning cmdlets. While Get-PnPSiteTemplate allows exporting SharePoint site configurations, it doesn’t directly cater to folders. After experimenting with various options, including Add-PnPDataRowsToSiteTemplate, I discovered the solution: the Add-PnPListFoldersToSiteTemplate cmdlet. The Challenge The initial attempt involved using the Add-PnPDataRowsToSiteTemplate cmdlet with a CAML query to filter folders and it did not work. Add-PnPDataRowsToSiteTemplate -Path Site.

Introduction During a discussion in a WhatsApp community group, a question arose about configuring a Copilot Studio agent for HR-related queries. The scenario involved country-specific policies stored in separate SharePoint folders. The challenge was ensuring that the agent dynamically retrieves content relevant to the user’s location. For example, if someone from the UK asks about maternity leave, the agent should only pull information from the UK folder, not from other countries.

Introduction Copilot Studio allows users to enhance agent functionality by integrating existing Power Automate flows. These flows can be added directly to topics or utilized as tools within an agent. This post explains how to add Power Automate flows as tools and use them effectively within Copilot Studio. Adding Power Automate Flows to Topics Within a topic added to an agent, existing agent flows can be seamlessly integrated. This approach enhances the agent’s capabilities as well as introducing more probablistic behaviour to the agent.