Blog - Recent Posts

Forms - How to add and edit records against SQL Server tables GUID primary keys

SQL Server tables can be set up with primary keys that are of data type GUID/uniqueidentifier. Power App forms do not work against these tables without some slight modification. This post describes how to add and edit records against tables with a GUID primary key column, using a form.

Model Driven Apps - How to display an automatic Power BI view of data from data grids

There's a new preview feature that allows users to display an auto-generated Power BI report from grids. This report includes charts and tables, and this post describes this new feature in more detail.

Firefox - The error "secure connection failed" SEC_ERROR_OCSP_INVALID_SIGNING_CERT appears when connecting to Power Apps

If the error message "Secure Connection Failed, Error code: SEC_ERROR_OCSP_INVALID_SIGNING_CERT" appears when attempting to use Power Apps with Firefox, here's how to diagnose and to fix the error.

Forms - How to highlight user modified field values on a form

This post provides a simple walkthrough of how to highlight form values that have been changed by a user.

Dates - How to convert dates from MM DD YYYY to DD MM YYYY and vice versa

This post describes how to convert dates in the US format "mm dd yyyy", to "dd mm yyyy" format.

Best Practice - Design and implement better solutions with the Northstar Architecture

If you're interested in finding out more about best practices, including what a good environment strategy looks like, and prescriptive advice on topics such as licensing, security, connectivity, business continuity/disaster recover, and DevOps, the Northstar Architecture is a great place to start, particularly for enterprise architects.

How does Microsoft update Power Apps?

If you're interested in finding out more about how Microsoft applies updates to Power Apps, here's a brief overview of the process.

Formula - How to format numbers with ordinal suffixes -  1st, 2nd, 3rd, 4th, etc

This post describes how to format a number with an ordinal suffix, or ordinal indicator. That is, the suffixes st, nd, rd, th that appears after a number (eg 1st, 2nd, 3rd, 4th, etc).

Mangage Power Automate Flows more easily from the Power App designer

The "Power Automate pane" offers a better way to work with Flows from the Power App designer. This post describes this preview feature.

Forms - How to append text to field in a data source

This post describes a solution to a question that occasionally arises - how to append text to a field when a user saves or edits a record through a form.

Settings - 2 Great improvements to settings area of the Canvas App designer

The settings area of the canvas app designer has now been improved. Changes to key settings don't require a restart, and it now provides better information for app builders. This post provides more details...

Notifications - How to send mobile notifications from a canvas app with SendPushNotificationV2

This post describes how to send push notifications to a mobile device by calling the SendPushNotificationV2 method of the PowerAppsNotificationV2 connector from a canvas app.

SQL - What to do when edit/add/delete options missing from an app, or edit controls unavailable in forms

If you're unable to add or edit data from a SQL Server table, the most likely cause is a missing primary key column. This post describes how to fix this issue.

Walkthrough - How to support multiple languages on model driven app pages

This week, Microsoft released in preview, support for localized model driven app pages. This post describes this feature by walking through the simple example of how to localize a text label.

Search - Applying multiple AND/OR conditions to the Search function- Workaround

The search function performs a partial match against multiple fields based on a single search term. Where we want to combine additional search terms with a logical 'And' or 'Or', there's no way to do this alone with the search function. This post describes a workaround to perform this task.