Author: pen

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

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

Sorting Galleries in Power Apps with up and down arrows.

I have recently been working with Galleries in Power Apps and needed a simple way to re-order the items before saving back to the Tables in the Dataverse (been dying to use that). In our example we have a QuestionsCollection that we want to order, we have and Field in the Table called ‘Response Order’, we use this to maintain the order state. In your Gallery add Up and Down icons. UP Icon Properties. In the OnSelect property of the icon add the following expression: As we dont’t want the Up icon to be visible on the first item in ….

Filtering Collections for events this week.

Recently building a calendar control in Power Apps I wanted to show events for the selected week. Luckily it’s fairly easy to calculate thanks to the Weekday function. To calculate the start date of the week: This assumes our week starts on a Sunday, you can add which ever day you want. Saturday or Monday for example. Then to find the end of the week: So now we have the start of the week date and the end of the week date we can use these in our filter.

Using Trigger Conditions in Power Automate

If there are reasons we don’t want to run a flow the most efficient way is to use trigger conditions, this stops the Flow from executing thus saving Flow runs. Here we use expressions rather than Formulas we use in Power Apps, another script language to learn…. In the following example, the Flow will only run if the FieldName is equal to true. Using Not.

Using CDS views in Filters

In canvas apps using CDS views are an efficient way of populating collections. In this example we are filtering by the Entity Associated View and that the status is active, when comparing true/false fields or lookup’s you need to use the lookup ‘Status (Entity)’.Active in studio intellisense will provide the options available once you enter, ‘Status (Entity)’. Active or Inactive if its a true/false (2-options) then the options will be Yes or No. Remember when using views to make sure all the columns you require are included in the view.

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