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
Microsoft 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: Recreating as Dataverse Tables | Calculated Columns
The ask, help a power user recreate several of their SharePoint Online (SPO) lists as Dataverse data tables. For the most part, their column types map pretty well, but one of the SPO list columns is Calculated. So, what is the comparable Dataverse column type? Figure 1 - SharePoint Online settings screen. Create a new … Continue reading SharePoint Lists: Recreating as Dataverse Tables | Calculated Columns
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)
Microsoft Dataverse: Table Designs w/ Copilot
The ask, create new Dataverse tables for an upcoming initiative. There are several existing tables that could be used for this initiative, but the project requirements necessitated new tables be created. Because this is an upcoming initiative, business stakeholders aren't ready to build the solution UI, even though Microsoft Copilot could create everything for them: … Continue reading Microsoft Dataverse: Table Designs w/ Copilot
Microsoft Dataverse: Virtual Tables [ Pros ]
Unfortunately, Microsoft Dataverse isn't a data storage consideration for many Power Platform makers because their organizations are already using other data sources like SQL Server, Salesforce, SharePoint Online (SPO), etc. These other data sources are well-supported, but Dataverse is the foundation of the Power Platform, so there is native integration for it in Power BI, … Continue reading Microsoft Dataverse: Virtual Tables [ Pros ]
Power Query: Overview
The capabilities of the Power Platform wowed many organizations. Especially Power BI and its ability to extract, transform, and load (ETL) datasets from dozens of disparate data sources. At the same time, Microsoft Dataverse, the low-code data storage offering of the Power Platform, also supports ETL of disparate data sources. Though, this isn't unique to … Continue reading Power Query: Overview
Power Platform: Data Sources | SQL Tables or Dataverse Tables
The Power Platform is Microsoft's collective of no-code/ low-code solutions. To supplement this platform, Dataverse is Microsoft's secure, no-code/ low-code data storage solution. SQL Server is still a strong contender for data storage, but leveraging it requires some mastery of SQL. Dataverse, however, stores data in tables just like SQL, but doesn't require any proficiency … Continue reading Power Platform: Data Sources | SQL Tables or Dataverse Tables
console.log('Charles'); 