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.

Dependent Assemblies with Power Platform Tools

In late July, Microsoft announced the preview of Dependent Assemblies, which would allow the ability to register individual assemblies, and upload a nuget package that contains both the plugin assembly and the dependent assembly. Previously, the only way this was available was the use of the ILMerge tool to manually merge dependent assemblies.

Dependent Assemblies with Plugin Registration Tool

In late July, Microsoft announced the preview of Dependent Assemblies, which would allow the ability to register individual assemblies, and upload a nuget package that contains both the plugin assembly and the dependent assembly. Previously, the only way this was available was the use of the ILMerge tool to manually merge dependent assemblies.