Power Automate How to Access Excel Files in Teams Private Channels with Power Automate (Fix)
Since I received a question about how to manipulate files in private channels, I'm sharing these notes.The Problem: Priv...
Development
Power Automate 
Power Automate [Office Scripts] How to Copy, Rename & Move Excel Sheets in Power Automate (Workaround)
Why you need this:Power Automate's standard Excel connector cannot copy, rename, or move worksheets. To do this, you nee...
Copilot Studio Copilot Studio Explained: The Difference Between ‘End All Topics’ and ‘End Conversation’ | Topic and Conversation Management Guide
I was confused about the difference between the "End All Topics" node and the "End Conversation" node in Copilot Studio,...
Power Apps [Dataverse] Can We Sort Formula Columns with Related Tables? Verifying Sort Behavior vs Limitations
UPDATE (Verification): According to Microsoft documentation, sorting is limited for columns referencing related tables. ...
Dataverse Complete Guide to Dataverse Formula Columns: Functions, Operators, and Parent Table References
Since calculated columns are being deprecated, I conducted a detailed investigation into formula columns as their replac...
Power Automate How to Fix Relationship Errors in Power Automate’s ‘Update Row’ Action for Dataverse
When trying to establish a relationship in Dataverse using the "Update Row" action in Power Automate, I encountered the ...
Power Apps How to Build Bulk Checkbox Selection (Select All) in Power Apps Gallery
Checkboxes are commonly used in groups, but Power Apps doesn't provide a native way to group classic checkboxes. This ca...
Power Apps Power Apps: Upload Files to SharePoint Document Library (V2 Trigger Method)
Directly uploading files from Power Apps to a SharePoint Document Library isn't supported out-of-the-box. However, using...
Power Automate [Solved] Fix “File is locked for shared use” in Power Automate: The Simple 6-Minute Delay Method
Have you ever encountered the frustrating "File is locked for shared use" error when trying to delete an Excel file in P...
Copilot Studio Adding SharePoint to Copilot Studio: Permissions Behavior & Setup Guide (2025 Update)
Note: As of mid-2025, Copilot Studio also supports SharePoint Lists as knowledge sources. This article focuses on adding...