Power Automate: dayOfYear function
Returns 1-366 for any date.
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 1-366 for any date.
Returns the first non-null value from a list. Null if all are null.
Returns the highest value from numbers or arrays. Type mismatches break it silently.
Returns the remainder of a division.
Fires when a new email arrives in a shared Outlook mailbox.
Returns days.hours:minutes:seconds between two dates as a string.
Converts a timestamp from one timezone to another.
Returns the running Flow's name, ID, region, and run details at runtime.
Returns a SharePoint file by path as base64.
Returns a random integer within a range. Negative numbers supported; no floats.
Returns a SharePoint file by ID as base64.
Runs a Flow from a Power App with typed inputs: text, numbers, files, booleans.