
I’m Aaron, and I’ve been consulting in the Power Platform & Dynamics 365 “CRM”, as well as their predecessors for 10+ years now! I am currently the Head of Power Platform at a Change Management organisation and I love to make digital work better for end users.
Latest Posts

Customise Data Shown in Dropdown Controls in Canvas Apps
When you use a dropdown control within a Canvas App it can be surprisingly tricky to show exactly what you want as an option unless the data already exists as a value in your data source. I assume that the reason for this is that dropdown controls are most commonly used within forms, and therefore…

Calculate ‘Total Days This Month’ Using Power Fx
New year, new challenge! This week I was asked to adapt one of our internal Canvas Apps that was used for an exercise challenge in December to track miles, so that the leaderboard resets to ‘0 miles’ at the beginning of each month. Our team’s goal is to log the miles run or walked within…

Handling Missing User Profile Photos in Canvas Apps
Lately I’ve been spending a lot of time working with photos in Canvas Apps in order to create more of a visual impact in my user interface design. Often this photo can come from the Office 365 User’s profile photo upload but we can’t necessarily predict or control whether the end user will definitely have…

Create a Rolling Calendar Year in Canvas Apps
Earlier this week I had a requirement to create a screen that would help others forecast an activity for the next 12 months. Whilst I was happy working with the data model, ensuring that the year was based on this month and the next eleven was more difficult than I anticipated. I suspect that this…

Visualise Your Day’s Meetings in Canvas Apps
With Microsoft expanding their suite of apps every month, it can be difficult to create the right view of data for you to personally consume without context switching. Recently I have been exploring the Office365Outlook Connector in Canvas Apps to bring a day view of my calendar into a Power App alongside information from other…

Choosing The Right Data Source for Power Apps & Power Automate
One of the biggest challenges that we face when building apps and automations is the decision on where to store my data. Sometimes this choice may be dictated to us based on licensing and architectural factors, however, if you have a choice of options then this blog post is for you. Think about the way…

Consistent Y-Axis in Model-Driven App Charts
This week I faced a very old school problem with model-driven apps from the days of working on-premise with Dynamics CRM, I needed to show two different series on the same graph, but every time I would view the chart it would show me two different scales on the same Y-Axis! As this chart was…

Reduce Columns Created in a Collection in Canvas Apps
One of the first lessons when getting to grips with Canvas Apps was that you should always use Collections where possible to reduce the number of calls to the original data source, and with any luck, you may see a performance increase as a result too. However, I often find that the data source I’m…

Keeping Calm Whilst Troubleshooting Software Bugs
As a manager of a team of consultants, I no longer have my own configuration problems anymore, so troubleshooting is a theme that plays into every single working day. When I started 10+ years ago, seeing an error would fill me with dread, sweat, and stress that I just couldn’t shake, and today I see…

How to convert UTC into Your Local Timezone in Canvas Apps
One of the technical challenges we have in the UK is that for half of the year we are in the UTC time zone that we’re all familiar with, and the other half we’re in British Summer Time (BST). Those lucky few that keep the same time zone all year don’t know how easy they…
Loading…
Something went wrong. Please refresh the page and/or try again.