Power App: Len Function
by The Len function is highly versatile and super useful. It is also a function used in all programming languages that I know since it serves …
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.
SharePoint: Right Function
The “Right function” is part of a group of functions that help us do text manipulation. The “right” gives us a hint into what it …
Power Automate: sub Function
I have to admit that the “sub function” and all the other analogous functions (add, mul and div) are quite strange. This function will subtract …
Power App: Table Function
Not all data lives in data sources and, once in a while; it’s useful to generate a table of objects that lives in your App. …
SharePoint: Left Function
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 …
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. …