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. I’ll include other platforms or apps, but for now, I’ll focus on these. I want to build on experience and explain the basic concepts behind some functions. Also, this is an excellent opportunity for me to gather in one place information that is currently scattered. I’ll use this reference for my daily tasks and hope it would provide useful for you too.
Articles will come out every Friday always 7 pm Lisbon Time. Since I have three platforms to explore, you can expect Power Automate, SharePoint, and Power Apps articles every three weeks. Time permitting I’ll increase the frequency, but I think this is the right balance so that I can keep on delivering valuable information in a defined schedule.
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 …