Power Automate: substring Function
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. …
Making your life easier with automation
Reference articles will contain information about specific functions and concepts for Microsoft Power Automate, Power Apps, and SharePoint for functions, Actions, and Triggers. It will teach you how to use them and show you pitfalls, limitations, and best practices on how to use them efficiently.
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. …
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 …
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 …
“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 …
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 …
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 …
Every programming language has a variation of the “concatenate function,” but I like a lot the Power App’s implementation of it. Concatenation means creating a …
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 …
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, …
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 …