The ask, take a date value as input and output its calculated day of the year using Power Fx. Not a fancy request, but it is an ask. E.g., November 1, 2025, is the 305th day of the year. Figure 1 - Power Apps canvas app with date picker and label elements. Breaking down the … Continue reading Power Fx: Date Picker | Calculate Day of the Year
Power Fx Functions
Power Apps: User Defined Functions (UDF) | Calculate Days in Month
The ask, evaluate user-defined functions (UDFs), an experimental feature of canvas apps. Can the client's existing solutions benefit from UDFs whenever they become generally available (GA)? The short answer is yes. UDFs would allow app makers to create their own Formulas to be used throughout their respective canvas apps. This becomes helpful because as solutions … Continue reading Power Apps: User Defined Functions (UDF) | Calculate Days in Month
Power Fx: Unique Records w/ Duplicate Count
Scenario: I have a data source with thousands of addresses, and their street names need to be searchable in a canvas app. Problem: There are similar streets in other cities, so search results will contain duplicates. Workaround: Group similar addresses and display the NumberOf duplicates using the Power Fx's GroupBy function. Figure 1 - Canvas … Continue reading Power Fx: Unique Records w/ Duplicate Count
Power Apps: Canvas Apps | Office365Users – Profile Errors
The Office365Users connector gets tricky when makers are working with incomplete user profiles. Especially when trying to display user profile photos. Does everyone have a picture? Even the contractors? Unfortunately, everyone isn't guaranteed to have an uploaded profile photo. Making the assumption that they do only invites future problems. To be proactive, default to the … Continue reading Power Apps: Canvas Apps | Office365Users – Profile Errors
Power Apps: SharePoint | Delegation + AddColumn()
So yeah, this won't work for everyone, but it was a creative delegation workaround for me. In my scenario, I used several SharePoint Online (SPO) lists as data sources and needed to filter on a multi-line column of employee Names, separated by a semi-colon: Figure 1 - SharePoint Online new item form. This example SPO … Continue reading Power Apps: SharePoint | Delegation + AddColumn()
Power Fx: Calculate | Calculate Days in a Month
Power Fx is the Excel-like, formula language of the Power Platform. Akin to Microsoft Excel, most of the functions are only reasonably powerful on their own. When they're combined though, they become much more awe-inspiring. For example, calculating the number of days in a month. Calculating this, makers only need a handful of functions and … Continue reading Power Fx: Calculate | Calculate Days in a Month
Power Fx: Understanding | With()
Power Fx is the Excel-like programming language of the Power Platform, more specifically canvas apps. As with any of their programming offerings, Microsoft has bundled plenty of pre-built functions into Power Fx. Among these bundled functions, With() is easily a standout. If you haven't worked the With() function into your canvas apps yet, then you're … Continue reading Power Fx: Understanding | With()
console.log('Charles'); 