Power Automate: and function
Returns true only when all expressions are true.
This is my reference library, the place I send people when they need precise, dependable answers about how a specific function, action, or trigger actually behaves. Tutorials teach you a workflow, but a reference tells you exactly what a piece does, what it expects, and where it bites. My Excel Function Reference breaks down worksheet functions like the "Count" function with clear syntax and examples. The Power Apps Function Reference covers the Power Fx functions you use to build canvas apps, and the SharePoint List Function Reference explains the calculated column functions that shape list data. For automation, the Power Automate Trigger Reference documents how each trigger fires, while the N8N Node Reference and N8N Trigger Reference do the same for the open-source world. An OData Reference handles the query syntax for filtering and sorting data. Every page delivers real syntax, real parameters, and the gotchas I have hit.
Returns true only when all expressions are true.
Rounds a number up. Negative values round away from zero.
Returns the files and subfolders inside a folder. Goes one level deep and needs the folder ID, not its path.
Fires when a Planner task is marked complete.
Evaluates a boolean expression and returns one of two values. Strict booleans only.
Returns true when the first value is greater than or equal to the second.
Returns all rows from an Excel table. Requires table-formatted data.
Runs a Flow from a Power App. Power Platform handles parameter passing.
Converts a string to a JSON object. Validates structure and formats output.
Fires when a SharePoint list item is created or modified. Polls on an interval, not instant
Returns the initial element of an array or the first character of a string.
Rounds a number down. Negative values round toward zero.