Copilot Studio Agents cannot read files in a SharePoint document library over 7MB. But we also know that files uploaded as Agent knowledge have a much greater limit of 512MB. 📚 By using a recurring trigger Power Automate flow we…
Copilot Studio knowledge files can be added to an Agent with a Power Automate flow. This is helpful when SharePoint files are over the 7MB size limit. By uploading files from SharePoint and adding them directly to the Agent now…
Power Automate can extract tables from a PDF with the help of Azure AI Document Intelligence. Using the pre-built Layout model we can analyze any PDF document and get its information in a JSON. The output includes an array containing…
A Power Platform environment variable secret is a special type of environment variable. It makes a secure connection to Azure Key Vault to retrieve secrets. Only users who are assigned access to the key vault in Azure are able to…
Copilot Studio cannot use a SharePoint list as knowledge but there is a workaround with Agent actions that delivers excellent results. The Agent can call a flow to get information about the SharePoint list columns and data types. Then it…
SharePoint lists can’t be added as knowledge to a Copilot Studio Agent but you can use a little known hack with Agent actions instead. And the results are amazing 😎 The Agent can use a flow action to determine the…
Power Automate can be used to run an AI Prompt on a PDF document. It’s surprisingly easy to do. Just create an AI Prompt and add a document or file as an input. Then connect the AI Prompt to a…
Power Automate can copy files from a network drive to a SharePoint document library. Creating the flow to do this is simple. But the tricky part is installing the on-premises data gateway and configuring it properly. After the gateway is…
A Power Platform solution can be connected to a Git repo for tracking and management of changes to code. This is known as source control. To do this, a Git repo must be setup inside an Azure DevOps project. Then…
Power Platform pipelines can be enhanced to include deployment stage approvals. Although there are no-built-in pipeline approvals it is possible to create one using a custom Dataverse table and a Power Automate flow. Stage approvals are important because they help…