SharePoint: IF Function
by “IF function” will return something if the first value is “true” and something else if the second is false. The “If function” is the most …
Category: Reference
Reference articles will contain information about specific functions and concepts for Microsoft Power Automate, Power Apps, and SharePoint for functions, Actions, and Triggers. It will teach you how to use them and show you pitfalls, limitations, and best practices on how to use them efficiently.
Power Apps: Filter Function
The filter function searches in a collection for one or more conditions and removes all items that don’t fit that condition. Usage It follows a …
Power Automate: split Function
The split Function breaks down your string into an array of strings using the delimiter that you defined. Think of the delimiter as a border. …
Power Automate: toLower Function
The toLower Function sets all items in a string to lowercase. There is the toUpper function also, and these functions are super useful, mainly if …
SharePoint: ISERROR Function
Showing errors to the end-user is quite ugly, so we should be careful in protecting our formulas so that you don’t display to the user …
Power Automate: toUpper Function
The toUpper Function sets all items in a string to uppercase. There is the toLower function also, and these functions are super useful, mainly if …
Power Automate: min Function
The min Function finds in an array of numbers the lowest number. Quite simple and handy. Usage It follows a simple pattern. An array of numbers …
Power Apps: DateDiff Function
The DateDiff function returns the difference between 2 dates in the specified unit. DateDiff function defaults to Days, but you can choose between Milliseconds, Seconds, Minutes, Hours, …
SharePoint: CONCATENATE Function
“CONCATENATE function” will group a series of values into a unique string. I like the concatenate function since you can use more than strings. Usage …
Power Apps: Today Function
The Power Apps Today function will return the date for the current day with the time as 00:00:00. Power Apps converts the value automatically to the …