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
Microsoft Power Fx
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 Apps: Canvas App | Ranked Choice Voting (RCV)
This is likely to be a lengthy post because there was no ask today. I just wanted to stress test nested Power Fx With() functions a bit. My question, "Are there any performance concerns nesting With() functions?" To test this and maybe get an answer, I created a Power Apps canvas app to determine the … Continue reading Power Apps: Canvas App | Ranked Choice Voting (RCV)
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
Programming Concepts: Conditional Logic | If-Then vs Switch
High-code isn't the friendliest to new developers. Still, there are some high-code concepts that even low-code and no-code developers should be aware of. One such concept is conditional logic. Generalizing the idea, conditional logic helps the code determine its next steps based on data input. Conditional logic is universal enough that it's also leveraged in … Continue reading Programming Concepts: Conditional Logic | If-Then vs Switch
console.log('Charles'); 