Category: PowerApps

Refactoring your Power fx code to support Explicit Column Selection

Every had that feeling your going mad, as the Canvas app worked yesterday worked fine but today most of the data is missing when using the Dataverse as a data source? One recent update to Power Apps did just that, the culprit, a preview feature that MS enabled by default, if you weren’t aware of the change, because the Power Platform teams comms are just well non existent on the updates and fixes being released, is Explicit Column Selection. What this means if your filters and collections don’t explicitly request the column you will no longer get it in the ….

Checking Colour Contrast in PowerApps for accessibility with Power Fx functions.

Recently during a team meeting we were discussing how we can bake in accessibility features into our delivery processes, as a little fun project I was in the process of creating an Fluent UI Icon generator based on the work of Matthew Delaney fabulous post providing 2000 icons and the Office UI Icon Generator by R3dKap, and because I wanted the team to start using the Fluent UI iconography first in all our apps, I decided to extend the app to check the colours being used would meet WCAG 2.1 standards. In the post Accessible colors for canvas apps in ….

Formatting UK Dates in Canvas Apps from CDS date columns.

I have been working with Canvas Apps and CDS recently this page is dedicated to all those things I keep looking up about formatting dates. Display CDS date column as UK date as text Displays as 25/10/2020 Displays as Sunday April 1976, notice only the day of the week shows, to show both the number and the text of a day use the following: This displays the date as Monday 22 October 2018 Displays as 04 Apr 1976 Displays as 04 April 76