Excel: Sumifs Function
Sums the values that meet several conditions at once. All conditions combine with AND, not OR.
Blog
Tutorials, tips, and guides to level up your workflows
500+
Articles
2-5x
Per Week
N8N: On a Webhook Call Trigger
Starts a workflow instantly when an HTTP request hits its URL. Test and production URLs behave differently.
Power Automate: Office 365 Outlook - Export email Action
Exports an Outlook email as a binary EML file by Message ID. Attachments are included inside the file.
Power Automate: getFutureTime function
Returns the current timestamp plus a number of time units. Always counts from UTC now.
How to check optional values in a manual trigger?
Read optional manual trigger inputs safely with ?[] and avoid the missing-property error.
Time is strange
Timekeepers vote this October on replacing the leap second with a leap hour. The Earth is spinning faster.
Book: Dungeon Crawler Carl
Matt Dinniman's LitRPG novel about Carl and his cat surviving an alien dungeon crawl reality show.
How to save emails from an Outlook to a file in Power Automate
Saves an email as an .eml file, automatically as it arrives or manually in bulk from a folder.
You Might Not Need That Provider SDK
Provider SDKs often pull in dozens of dependencies when a simple HTTP request to the API would do.
SharePoint Copy File Action
Copies a file to another library or site. Version history and metadata don't carry over.
Power Automate: convertFromUtc function
Converts a UTC timestamp into a target time zone. Returns a string with no offset or Z marker.
Handle Large Files in Power Automate with Chunking
Move files past the 100 MB limit by splitting them into chunks, and know when to switch to Graph.