Power Automate: addSeconds Function
by 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 …
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: 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 …
Power Apps: Round Function
The Round function performs the mathematical round of a number to a specific number of decimal places. It uses the rules defined “Half Round-Up” where it rounds …
Power Automate: addDays Function
The addDays Function works just like the addSeconds Function and other similar functions. It adds the number of days to a specific date, based on a …
SharePoint: Today Function
The SharePoint Today function will return the number of elapsed days since a reference date, in this case, December 31, 1899 (serial number 1). These are …
Power Apps: RoundUp Function
The RoundUp function rounds a number to a specific number of decimal places, always to the nearest higher number. The round is still up regardless of …
Power Automate: addHours Function
The addHours Function works just like the addSeconds Function and other similar functions. It adds the number of hours to a specific date, based on a …