Power Automate: toLower Function
by 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 …
Tag: Function Day
Function Day is where I’ll explore the basics of some functions and provide some recommendations on how to use them. I’ll focus on Microsoft Flow, SharePoint, and PowerApps since there’s a lot to explore there, but there may be other references showing up in the future.
Please don’t expect an exhaustive list of all functions. You can find that on Microsoft’s excellent reference. I’ll focus on the most common ones and build from there, but I want to make Function Day a thing on this site.
Articles will come out every Thursday, always 1 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.
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 …
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 you want. It’s pretty helpful since different countries represent dates differently. Another …
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, …