Ippu

Copilot Studio

Exploring Variable Types and Scopes in Copilot Studio: Setting Topic Arguments and Return Values

I explored variables in Copilot Studio in detail.Variable Types The types of variables available in Copilot Studio are a...
Copilot Studio

Using Foreach Loops in Copilot Studio Conversations: Simplify Table and Array Operations

While researching loops in Copilot Studio, I came across an interesting article that I'd like to share.How to Create Loo...
Copilot Studio

Add Items Dynamically to Variables Like the Collect Function in Copilot Studio: An Alternative to Collections

Copilot Studio does not provide functions like ClearCollect or Collect, but since there are many situations where you wa...
Power Automate

Fixing the Power Automate Error: ‘The Specified Object Was Not Found in the Store’ When Accessing Room or User Calendars

When attempting to retrieve calendar events via Graph API (HTTP requests) from Outlook using Power Automate, the error "...
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...