Microsoft Dataverse tutorials: tables, columns, views, solutions, security, and working with Dataverse rows from Power Apps and Power Automate.
Many older guides say the Dataverse Update a row action quietly creates a new row when the Row ID doesn’t exist. That may have been true once, but when I tested it this week, the action stopped with a 404 Does Not Exist error. So here’s the better way to update a row in Dataverse … read more…
You click Sign in on a dataflow connection and nothing opens. Instead, a yellow line says your pop-up blocker must allow this site. The fix is to allow pop-ups for the Power Apps site in your browser, then click Sign in again. You don’t have to turn the blocker off for every website. In this … read more…
Our service desk tags every device with a numeric Asset Tag, and techs wanted to type it into a canvas app instead of the Dataverse grid. The catch: a text box gives you text, and the column wants a number. In this tutorial, we’ll patch a Dataverse number field in Power Apps: update a row, … read more…
In this Dataverse tutorial, We will discuss what is Dataverse in Power BI, and how to use Power BI with Microsoft Dataverse data. Also, We will see some more topics below related to Dataverse Power BI: Read: How to Patch Dataverse Number Field in Power Apps Dataverse Power BI With Power BI Desktop and Microsoft … read more…
Someone changed the status on a customer request last week, and now nobody remembers the old value. Dataverse can tell you who changed it, when, and what it was before, but only if auditing was on. In this tutorial, we’ll set up Dataverse version history the way Microsoft builds it: auditing at the environment, table … read more…
The SPGuides IT desk lead asked me how many service requests were still open, and nobody could answer. The status lived in a text column where people typed Open, open, OPEN and Opened, so every count disagreed. In this tutorial, we’ll create a Dataverse choice column on a Service Request table, then build a canvas … read more…
If you’ve tried counting a Dataverse table in Power Apps with CountRows, you’ve probably seen a 0 while the table holds 8 rows. To get data from Dataverse in Power Apps reliably, add the table, then read it with Filter, LookUp and CountIf. Why the 0? CountRows on a Dataverse table reads a cached count … read more…
Typing a request straight into the Dataverse grid is fine for one row. The SPGuides service desk wanted more: techs logging requests from a canvas app, quick test rows, and a path for their spreadsheet. In this tutorial, we’ll cover how to add data to Dataverse four ways: New row in the table editor, the … read more…
