The ask? Better report flow errors of Azure Logic Apps, like the better error reporting of a Power Automate cloud flow. But because this is an enterprise-level automation, generating emails could overwhelm the mailbox. Instead, log the run links in a Microsoft Dataverse table. Figure 1 - Microsoft Dataverse Link column with Azure Logic App … Continue reading Azure Logic Apps: Flow Errors | Log in Dataverse w/ Links
Dataverse
Solution Rebuild: Part #2 | Database – Access to Dataverse (Loading)
The ask? Load the extracted and transformed Microsoft Access data into Microsoft Dataverse. But before performing the actual import, ask the important questions, "Could the data model be improved?" During the transform process, "Were there any column types that could be changed?" Often enough, while auditing the data, it may come to light that a … Continue reading Solution Rebuild: Part #2 | Database – Access to Dataverse (Loading)
SharePoint Lists: Migrating to Dataverse Tables | Enforce Unique Values
The ask, help a maker scale their Power Apps solution. They created a canvas app some years back and being frugal, they chose SharePoint Online (SPO) lists as their app's data source. Now, three years later, that frugal decision is haunting them as they've hit the 2,000-item delegable limit. To rebuild their data source with … Continue reading SharePoint Lists: Migrating to Dataverse Tables | Enforce Unique Values
Solution Rebuild: Part #1 | Database – Access to Dataverse (Extracting + Transforming)
The ask, rebuild a legacy VB.NET desktop application as a Power Platform solution. The app was written maybe 17 years ago, hasn't been updated, and is a media tracker app, like a personal IMDb. Because it was a personal solution, not an enterprise solution, its data was stored in a Microsoft Access database, so this … Continue reading Solution Rebuild: Part #1 | Database – Access to Dataverse (Extracting + Transforming)