Power Automate: toUpper Function
by 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 …
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 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 …
Power Automate: addToTime Function
Power Automate provides functions to add time-based on each of the units. For example, you can use the addSeconds Function to add only seconds, but …
Power Automate: formatDateTime Function
The formatDateTime Function allows you to turn a specific date in any format that you want. It’s quite useful since different countries represent dates differently. …
Power Apps: Mod Function
The Mod function is a mathematical function that calculates the remainder of a number divided by a divisor. It may not be apparent its usage, …
Power Automate: addSeconds Function
I’ve used the addSeconds Function in previous posts but never spent time to explain it adequately. This function adds the number of seconds to a specific …
SharePoint: REPT Function
“REPT function” will return a text value that has a specific string repeated X number of times. Usage It follows a simple pattern. String to …