Power Automate

Convert SharePoint List or Excel Columns to a Single-Dimensional Array Using Power Automate

I couldn't quickly find a method to convert a table (object array) retrieved from SPO (SharePoint Online) or Excel into ...
Power Automate

How to Use Power Fx Functions from Power Automate | Instant Plugin Guide

I discovered that you can use Power Fx from Power Automate with the Instant Plugin feature of the Dataverse Accelerator,...
Power Automate

Comparing Methods to Export Data from Power Automate to Excel: Office Scripts Recommended

I'm often asked about methods to export data from Power Automate to Excel, so here are my notes on this topic.What We Wa...
Power Automate

Power Automate Best Practice: Using Office Scripts for Fast Excel Data Processing

I was asked to quickly retrieve large amounts of data from Excel, so I implemented a solution using Office Scripts.Perfo...
Power Automate

The Ultimate Guide to Power Automate Excel’s ‘List Rows Present in a Table’: Delegation, Filters, and Row Limits

I was curious about the detailed behavior of the "List Rows Present in a Table" action that retrieves multiple data (row...
Power Automate

How to Manipulate Excel Files in Microsoft Teams Private Channels with Power Automate

Since I received a question about how to manipulate files in private channels, I'm sharing these notes.What We Want to A...
Power Automate

Complete Guide to Excel Sheet Operations in Power Automate: Add, Delete, Rename, Copy, and Move

I've been asked about detailed Excel operations frequently lately, so here are some notes.Office Script Office Script is...
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 Platform Manage

Power Platform ALM: How to Manage Solution Deployments with GitHub Pipelines

Using the pipeline we created in the previous article, I'll document the steps to commit solutions to GitHub.You can fin...
Power Platform Manage

Power Platform ALM: Building Basic Solution Deployment Pipelines – Step by Step Guide

I had an opportunity to use "Pipelines," a new management tool in Power Platform, so I'll document how to use it.What We...