SharePoint: CONCATENATE Function
by “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 …
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: 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 …
Power Apps: Now Function
The Power Apps Now function will return the current moment’s date, including the time. Power Apps converts the value automatically to the user’s regional settings when …
Power Automate: addMinutes Function
The addMinutes Function works just like the addSeconds Function and other similar functions. It adds the number of minutes to a specific date, based on a …
SharePoint: Now Function
The SharePoint Now function will return the token serial number of the current date and time. Dates are stored internally as sequential serial numbers to enable …