SharePoint: Left Function
by The “Left function” is part of a group of functions that help us do text manipulation. The “left” gives us a hint into what it …
Category: Reference
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.
Power Automate: length Function
The length function is handy to get the size of a string or the number of objects of a collection. So you can use it …
Power App: Count Function
There are several count functions in Power Apps, and all of them draw inspiration from Excel. I will detail them all in this reference but, if …
SharePoint: ISTEXT Function
Following the “IS” functions theme, we have the ISTEXT function. This function doesn’t check for errors, but if the value is of a specific type. …
Power Automate: indexOf Function
The “indexOf” function is essential for data parsing. You’ll rarely parse some text and don’t use this function. It returns the first occurrence of a …
Power App: SortByColumns Function
Sorting is essential for any app’s good navigation, but most of the time, we want to define a column to be the “default” sorting column. …
SharePoint: ISNA Function
Following the “IS” functions theme, we have the ISNA function. This checks for the “#N/A,” an error that we know all too well in Excel. …
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. …
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 …