Power Apps: Trim Function
by The Trim function is one handy function that most don’t understand the proper usage since it only serves one purpose. It is removing spaces. It …
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.
SharePoint: Choose Function
“Choose function” will return the value for a specific index. For example, if you have a set of values like “banana,” “orange,” and “apple,” the …
Power Apps: TrimEnds Function
The TrimEnds function is one handy function that is often confused by the Trim function since it works closer to the way developers are used …
SharePoint: IF Function
“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 …
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 …