Excel: Countif Function
Counts the cells in a range that meet one condition. Text matching ignores case.
TAG
Common Questions
Some questions come up again and again, so I gathered them here in one place. This tag pulls together the practical answers I keep reaching for: whether Power Automate can run Python or PowerShell scripts, how to fix the changes conflict error in SharePoint, how to stop an infinite trigger loop, and how the "Parse JSON" action really behaves. You will also find function walkthroughs like the Excel "Count" function, the Power Apps "LookUp" function, and the Power Automate "isInt" function. Instead of theory, each article answers a specific question with a concrete fix you can apply right away. If you have hit one of these walls yourself, chances are the answer is already written down here, waiting for the next time it trips someone up.
New Power Automate now requires connection references
Convert a solution flow from a direct connection to a connection reference and unlock the new designer.
SharePoint: YEAR function
Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.
Power Automate: Office 365 Outlook - Get emails Action
Returns an array of emails from a mailbox folder. Filter fields only scan the first 250 emails.
SharePoint Permissions in Power Automate
Which account really runs each action, and why a flow that works for you returns 403 for everyone else.
N8N: On a Webhook Call Trigger
Starts a workflow instantly when an HTTP request hits its URL. Test and production URLs behave differently.
How to check optional values in a manual trigger?
Read optional manual trigger inputs safely with ?[] and avoid the missing-property error.
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.
SharePoint Copy File Action
Copies a file to another library or site. Version history and metadata don't carry over.
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.
N8N: On a Schedule Trigger
Starts a workflow at fixed times or intervals, like Unix cron. Missed runs are skipped, not backfilled.
Power Automate: convertToUtc function
Converts a timestamp from a source time zone to UTC using Windows time zone names.