Power Automate

AI Builder

How to Use Structured JSON Output in AI Builder for Power Automate

AI Builder has added a feature similar to structured outputs, so I decided to try it out.What is JSON Output?Broadly spe...
Power Automate

Fixing the 1899 Date Issue: Handling Excel Time Data in Power Automate

I made a note of this because I was asked how to change a column containing only "time" to the time on the current date ...
Power Automate

Stop Initializing Arrays (In Single Loops): A Cleaner Power Automate Hack

Just a quick note: I found that Power Automate’s “Compose” action can handle arrays, which is pretty handy.The standard ...
Power Automate

Power Automate SharePoint Trigger Conditions: Ready-to-Use Formulas for Text, Date & User Fields

Following up on my previous article, I've put together a comprehensive collection of trigger condition formulas for diff...
Power Automate

The Ultimate Power Automate Trigger Conditions Cheat Sheet (2025 Edition)

"Below is a collection of copy-paste ready formulas. You don't need to memorize them—just bookmark this page and copy th...
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...
Copilot Studio

Building Hybrid CRAG in Copilot Studio: Combining SharePoint & Google Search (SerpAPI)

In this tutorial, we implement a Corrective Retrieval Augmented Generation (CRAG) system using Copilot Studio and AI Sea...
Copilot Studio

How to Create Self-Operating Agents in Copilot Studio Using Event Triggers: Email-Activated Automation (Preview)

In this article, I'll demonstrate how to create an autonomous agent that automatically responds to emails using the rece...
Copilot Studio

[2025 Update] Save Files from Copilot Studio to SharePoint (Standard Feature Guide)

2025 Update: Copilot Studio can now handle files using standard capabilities! Previously, this required a complex workar...
Power Automate

Fix “DateTime parameter is invalid” in Power Automate HTTP Request (URI Encoding)

When trying to specify Japanese time zone directly in an HTTP Request action URL query, I encountered a "DateTime parame...