The Issue SharePoint’s “Limited Access User Permission Lockdown Mode” feature introduces an unexpected side effect that can frustrate users and disrupt workflows. When this security feature is enabled, users who receive sharing links with edit permissions find themselves unable to edit files in desktop applications, despite having the necessary permissions. What Happens Expected Behavior: User receives an edit link, opens the file in Word/Excel/PowerPoint desktop app, and can modify the document.

Table of Contents Introduction Business Scenario CSV Data Structure Step-by-Step Implementation 1. File Upload Trigger 2. Get File Content 3. Parse CSV Data 4. Filter Data 5. Extract Unique Combinations 6. XML Grouping 7. Concatenate Users 8. Create SharePoint Items Complete Flow Overview References Introduction This guide demonstrates how to use Power Automate to group CSV data and concatenate users by Team and Channel using XML processing techniques to save to a SharePoint list.

Table of Contents Introduction Prerequisites Implementation Guide Creating Your Agent Configuring TypeSpec Files Setting Up Authentication Testing & Troubleshooting Conclusion References Introduction Following on my blog post Declarative Agents: Azure OpenAI API Key Auth with TypeSpec, I decided to try out how to authenticate to Ms Graph using sample Tasks Agent using TypeSpec for Microsoft 365 Copilot that connects to the Microsoft Graph APIs created by Sébatien Levert. Why This Matters: Copilot out of the box can not retrieve data from SharePoint List.