SharePoint: Day Function
by “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 …
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.
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: Concatenate Function
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 …
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 …
SharePoint: Choose Function
“Choose function” will return the value for a specific index. For example, if you have a set of values like “banana,” “orange,” and “apple,” the …
Power Apps: TrimEnds Function
The TrimEnds function is one handy function that is often confused by the Trim function since it works closer to the way developers are used …