Power App: WeekNum function
by The week number is a function that represents the week’s count starting on the 1st of January. So the week that contains the first day …
Category: Power Apps Function Reference
This Power Apps function reference has two main objectives. First, to explore the fundamental concepts and understand them better. The second is to provide some feedback on how to use them efficiently.
I don’t want this Power Apps function reference to replace the excellent Microsoft reference, but I want to augment it with some information that you only find once you use the tools.
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.
Power App: ISOWeekNum function
Week numbers are useful but not for everyone, I reckon. They represent the number of the week of the year starting at the beginning of …
Power App: Color Function
Color makes everything better, and it’s an amazing way to help highlight elements, make the UI easier to use and read, and much more. The …
Power App: Choices Function
The choices function returns a table of elements that we can choose from. Note the return “table,” meaning that we can use other functions like …
Power App: Len Function
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 …
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. …
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 …
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. …
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 …
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 …