Category: Power fx

Using Power Platform Security Role membership to provide RBAC in canvas apps.

On the Microsoft cloud there are many ways to achieve the same result, and it’s no different when securing your canvas apps. Three ways spring to mind: Office 365 Groups Connector Shane Young has done a great video on using this connector. PowerApps Manage Access and Azure Security Groups from an app – YouTube Azure AD Connector A standard connector Has a great function CheckGroupMembershipV2, however this connector requires administrative privilege’s that you probably don’t want to give the general population of users. Power Platform Security Roles In this post we will demonstrate how to use the third option, Power ….

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 ….

Power Apps Menu Component

In this post we create the Power Apps Component for the Fluent UI Menu Builder, the collection that is output from the menu builder will be used as our collection for our menu. Our objective is to create a menu component using SVG icons and text, to meet the WCAG 2.1 Level AA standard for accessibility. Our Icon menu (Rail) on its own will not meet the standard we need to provide the text with the icon to meet Success Criterion 3.2.3 Consistent Navigation, Expanding navigation menus. To meet Level AA Non Text Contrast The visual presentation of the following have a contrast ratio of ….

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