Power Automate: substring Function
by The substring function is widely popular and widely used. We have the need all the time to parse the string to get sections of it. …
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.
Power Apps: Concat Function
It’s funny that there are two functions to perform concatenation of “stuff.” Some people get confused when thinking about using one or the other, but …
SharePoint: ISNUMBER Function
The “ISNUMBER” function relates to a group of functions called the “IS” functions. These validate if the contents are of a specific type or returned …
SharePoint: Day Function
“Day function” will return the day part of a date in a numeric format. For example, in the data 21st of January 2020, it will …
SharePoint: ISBLANK Function
Showing errors to the end-user is quite ugly, so we should be careful in protecting our formulas so that no ugly #Value! are displayed on …
Power Automate: replace Function
The “replace” function is one that shows up frequently in every programming language. The usage is simple but extremely powerful. Usage It follows a simple …
Power Apps: StartsWith Function
The StartsWith is a handy function that allows you to check if a text string starts with another. Usage It follows a simple pattern. Text …
Power Automate: join Function
The join function is handy although I, don’t see many people using it. It converts an array in a string with a delimiter. At first, …
Power Automate: int Function
The int Function does something super simple. Convert a string into an integer value. That’s it. But, as always, we need to be careful while …
Power Apps: Trim Function
The Trim function is one handy function that most don’t understand the proper usage since it only serves one purpose. It is removing spaces. It …