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 …
Category: Reference
Reference articles will contain information about specific functions and concepts for Microsoft Power Automate, Power Apps, and SharePoint. I’ll include other platforms or apps, but for now, I’ll focus on these. I want to build on experience and explain the basic concepts behind some functions. Also, this is an excellent opportunity for me to gather in one place information that is currently scattered. I’ll use this reference for my daily tasks and hope it would provide useful for you too.
Articles will come out every Friday always 7 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: 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 …
SharePoint: IF Function
“IF function” will return something if the first value is “true” and something else if the second is false. The “If function” is the most …
Power Apps: Filter Function
The filter function searches in a collection for one or more conditions and removes all items that don’t fit that condition. Usage It follows a …
Power Automate: split Function
The split Function breaks down your string into an array of strings using the delimiter that you defined. Think of the delimiter as a border. …