Masking sensitive data in Dataverse

As part of the 2024 Power Platform Release Wave 1, Microsoft has released (currently in Public Preview) the ability to create secured fields and mask either all or parts of the field based on regular expressions. This would allow us to show parts of the secured fields (such as the last 4 digits of a social security number) on the form without having to deal with custom scripts and not having the ability to export the full data of those fields.

Connecting to other Dataverse environments from Microsoft flow

Although this feature might have been out for a couple of months (at least in preview), I recently noticed that the new Dataverse connector (non-legacy), has some new actions that can be performed against other environments, and not only the current environment as was previously named Common Data Services Connector (Current Environment).

Complex Exporting to Excel using Power Automate

While working on a recent project to replace a low code platform with the Power Platform, one of the requirements that we had was to replace some of the Excel export and import functionalities that the existing system had to be able to send large Excel files into various other systems to be analyzed and consumed.

AAD Users filtering limitations and workarounds

The AAD Users virtual table that was added to Dataverse has been a lifesaver for a lot of applications, especially when using Power Apps licensing as they provide the full subset of Active Directory users. When using Power Apps licensing, not all users are automatically synched to the Users table, so that is a great addition.

Changes to email storage in Microsoft Dataverse

Up until recently the email description field or the body of the email have been stored within the Microsoft Dataverse data store. This is going to be changing in the coming months where the email description field will be moved to an Azure Blob Storage

Modern Security Roles in Power Platform Admin Center (Preview)

In the last week or so, depending on your region, you might have encountered some changes in the way Security roles are accessed from the Power Platform Admin Center. While this seems to be available at this time in most Geographies, some of them might still be missing.

Virtual table creation in Maker Portal for SQL Server

As part of the 2023 Wave 1 Release Plan, Microsoft simplified the process of connecting to external data and creating virtual tables from within the Maker portal. This process makes creating these connections very easy, and results can be seen in a manner of minutes. Configuration is now at the fingertips of citizen developers as well.

Microsoft Dynamics 365 and Power Platform 2023 Release Wave 1 Plans

Yesterday (January 25, 2023), Microsoft release their plans for Microsoft Dynamics 2023 Release Wave 1. These release plans are available in various formats and can be accessed on the Microsoft Learn site, the Microsoft Release Planner or can be downloaded as PDFs.

Virtual table creation in Maker Portal

As part of the 2023 Wave 1 Release Plan, Microsoft simplified the process of connecting to external data and creating virtual tables from within the Maker portal. This process makes creating these connections very easy, and results can be seen in a manner of minutes. Configuration is now at the fingertips of citizen developers as well.