Power Automate

Power Automate

How to Use “My Lists” from Microsoft Lists in Power Automate Flows

I wasn't sure how to use lists saved in "My Lists" on Microsoft Lists with Power Automate automatic triggers or actions,...
Power Automate

How to Include Multiple Attachments in Power Automate Approval Actions (with SharePoint Attachments)

I was asked how to attach multiple files to an approval action in Power Automate, so I’m sharing my notes here.Objective...
Power Automate

A Deep Dive into Power Automate Excel Filter Queries: Filtering Greater Than, Less Than, and Removing Blank Rows

I discovered that the "greater than or equal to" (ge) and "less than or equal to" (le) operators cannot be used in Excel...
Power Automate

How to Specify Time Zones like ‘+09:00’ in Power Automate HTTP Requests

When trying to specify Japanese time zone directly in an HTTP Request action URL query, I encountered a "DateTime parame...
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...