Power Apps: DateTimeValue function
Converts a string into a date-time value.
CATEGORY
Reference
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.
Power Automate: Initialize variable Action
Declares a variable. Required first step before any other variable action.
SharePoint: Round Function
Rounds a number to a given number of decimal places.
Power Automate: or function
Returns true when any expression is true.
Power Automate: string function
Converts booleans, integers, floats, and arrays to text. Arrays become JSON; null becomes empty.
Power Automate: equals function
Compares two values. Case-sensitive for strings, cross-type for ints and booleans.
Power Apps: IsToday Function
Returns true when a date-time falls on today.
Power Automate: endsWith function
Checks if a string ends with specific text. Case-insensitive, space-sensitive, strings only.
SharePoint: Int Function
Converts a value to an integer by rounding down.
Power Automate: greater function
Returns true when the first value is greater than the second.
Power Automate: ticks Function
Converts a date to 100-nanosecond intervals since year 0001.
Power Apps: GUID function
Generates a GUID, or converts a string into a GUID.