Power Automate

Power Automate

Excel Formatting with Power Automate: How to Make Negative Numbers Red Using Office Scripts

Looking to highlight negative numbers in Excel using Power Automate?Standard Power Automate actions can't change font co...
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...
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...
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

6x Faster Excel Reads in Power Automate: Office Scripts vs “List Rows” [Benchmark]

Are you struggling with Power Automate timeouts when reading large Excel tables?The standard "List rows present in a tab...
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...