Table of Contents Issue Overview Expected vs Actual Behavior Steps to Reproduce Issue Overview When SharePoint document libraries are configured with the “Open in client application” setting, users may experience unexpected behavior where new files open in the same browser tab instead of launching the desktop application as intended. Issue Summary: Expected: Files should open in desktop applications (Word, Excel, PowerPoint) Actual: Files open in the same browser tab instead of launching client apps Affected: SharePoint document libraries with “Open in client application” enabled Scope: Potentially affects user productivity and workflow expectations Expected vs Actual Behavior Expected Behavior When a SharePoint library is set to “Open in client application”:

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.