Microsoft Dataverse tutorials: tables, columns, views, solutions, security, and working with Dataverse rows from Power Apps and Power Automate.
Almost every Power Apps job post I’ve read in the last two years mentions Dataverse. Yet many candidates who build great Canvas apps freeze once the conversation moves to the data layer. That makes sense. You can build a lot on SharePoint lists without ever thinking about security roles, relationships, or plug-ins. Then the interviewer … read more…
Our Asset and Asset Loan tables lived in the default solution, so there was no clean way to ship them to another environment. The service desk wanted them packaged, versioned and ready for a test environment before anyone built more on top. This Dataverse tutorial picks up where table-building lessons stop. A solution is the … read more…
Microsoft Dataverse is the cloud database built into Power Platform. It stores your app data in tables with typed columns, relationships, security roles and business rules, so Power Apps, Power Automate and Power BI all read the same data. Here’s a real formula from my canvas app. It reads a Dataverse table called Assets: With … read more…
Two people on your team want to build the same Power Apps request tracker. One says use a SharePoint list, the other says Dataverse, and both sound completely sure. In this tutorial, we’ll settle the dataverse vs sharepoint list question the way we do it for client projects: licensing first, then security, row limits and … read more…
Last week the SPGuides IT lead asked me for two extra columns on our Asset table: a status label showing who has each device, and the days since we bought it. Nobody should type either value. Typing them in a flow or a canvas app works until someone edits a row somewhere else. A Dataverse … read more…
Getting the “The JSON function cannot serialize tables/objects with a nested property called ‘_ownerid_value’ of type ‘Polymorphic’” error in Power Apps? I ran into this exact issue while building a Power Apps Canvas App against a Dataverse table. I was trying to extract column names from a collection using the JSON function — and out of nowhere, … read more…
When I first started working with solutions in the Power Platform, I mostly ignored the Preferred Solution setting. I created apps, flows, and tables directly in the default environment and didn’t think much about where those components were stored. Later, when the project grew, and I started organizing components inside solutions, I realized something important: … read more…
Six hundred twenty-three service requests sat in a SharePoint list, and the new Dataverse app couldn’t see a single one. The service desk asked me to move them without copy-paste and keep the door open for scheduled updates. In this tutorial, we’ll build a dataverse dataflow that loads that list into a new Dataverse table: … read more…
Our help desk asked for one small thing: let a technician snap a picture of a jammed printer and keep it on the service request. My first Patch failed with a type error, because an image column doesn’t take a plain picture value. In this tutorial, we’ll create a Dataverse image column, check its limits, … read more…
If you need a simple on/off flag in a Power Apps Dataverse table, like “Is this laptop still in service?”, use a Yes/No column. In your app, treat it as true or false: compare it to a toggle, flip it with !, and save it with Patch. Here’s where people get stuck. Dataverse shows the … read more…
“How big a PDF can a Dataverse file column hold?” Our SPGuides IT team asked that before storing warranty documents on asset records, and the answer depends on where you upload from. In this tutorial, we’ll create a dataverse file column on a real Asset table, set its size limit, add it to a form, … read more…
You store an asset tag or an ID in a Dataverse Whole Number column, and the grid shows 10,045,872 instead of 10045872. The commas aren’t in your data; they’re a display format, so you fix them where the number is shown. In this tutorial, we’ll remove commas from Dataverse number field values in a model-driven … read more…
The SPGuides service desk manager asked for a small change to the new-request email: show who logged the request. Every Service Request row in Dataverse already has a Created By column, so I expected one click in dynamic content. It wasn’t that simple. The Created By value a flow sees is a long GUID, not … read more…
A new teammate opens Power Apps, clicks New table, and gets a yellow banner instead of a table designer. The buttons are there, but they’re grayed out. In this tutorial, we’ll fix one or more commands are unavailable due to your current privileges for this environment the way we handle it for our own team: … read more…
