Microsoft Dataverse tutorials: tables, columns, views, solutions, security, and working with Dataverse rows from Power Apps and Power Automate.
Service requests don’t always arrive in English. When a Spanish or French ticket lands in the queue, someone has to notice it before the right agent picks it up. In this tutorial, we’ll detect text in Dataverse using AI Builder: a Power Automate flow reads each row’s description, finds its language, and writes the code … read more…
You built a Dataverse table, and now everyone types loan numbers by hand into the primary column. Some say LOAN-7, some say loan 7, and nobody knows which number comes next. In this tutorial, we’ll set up a Dataverse primary column autonumber on a real Asset Loan table, explain why you can’t swap the primary … read more…
The SPGuides purchasing team tracked eight vendors in an Excel workbook that got emailed around for every update. They wanted it in Dataverse, with no retyping. In this tutorial, we’ll create Dataverse table from Excel data in Power Apps: upload the workbook, check the AI column types, fix the table properties, then import more rows … read more…
Say you’re the IT lead tracking five devices worth $3,216.98 in a spreadsheet nobody trusts. The fix is a Dataverse table: in Power Apps, open Tables > New table > Table (advanced properties), name it, and save. In this tutorial, we’ll go through every create Dataverse table option on the Tables page, build a real … read more…
When you work with Power Apps, you usually start with Canvas Apps, where you design the layout and user experience from scratch. However, if you want to build apps that focus more on your data and business processes, consider Model-Driven Apps. Model-Driven Apps let you build powerful, data-centric applications without writing much code. Instead of … read more…
A client finished user testing and wanted their Service Requests table empty before go-live. Selecting test rows one page at a time isn’t a plan when there are thousands of them, and one wrong click deletes real data. In this tutorial, we’ll delete all records from a Dataverse table four ways: a bulk delete job, … read more…
Many guides still say the fastest way to move a SharePoint list to Dataverse is the “Create with SharePoint list” wizard. It’s quick when it works, but in my tests it failed twice. A Power Query dataflow is the method that actually delivered. My dataflow copied 623 SharePoint items into a new Dataverse table in … read more…
If you need your team to see only the open, high-priority service requests, create a Dataverse view with the right columns, filters and sort. A view is a saved query on a table. People get stuck because the designer has two Status columns, related columns hide on a separate tab, and nothing reaches the app … read more…
Our IT manager keeps new hardware purchases in a spreadsheet and saves it as a CSV file in SharePoint. She wanted those rows in the Dataverse Assets table without anyone retyping six laptops and monitors by hand. In this tutorial, we’ll build a power automate import csv to dataverse flow that reads assets.csv, splits it … read more…
Your flow pulled rows from a Dataverse table, and now you need to know how many came back. Wrap the List rows output in length() inside a Compose action, and you get the count as a number. In this tutorial, we’ll walk through each Power Automate count rows case you’ll hit in a real flow: … read more…
Our help desk lead wanted every phoned-in problem saved as a Dataverse service request the moment someone logs it, with the customer and the assigned tech already linked. The Add a new row action in Power Automate does exactly that, and it hands back the new row’s ID. In this tutorial, we’ll build a power … read more…
Your manager wants the service request list in Excel every Monday. Clicking Export by hand works once, but it gets old fast. In this tutorial, we’ll export dataverse table to excel using power automate, and also cover the built-in Export to Excel options for one-off exports. The short answer: List rows reads the table, Select … read more…
Our service desk lead wanted a Teams message whenever a request changed status. The first test run posted “Status: 770700001” to the channel, and nobody on the team knew what that meant. If you come from SharePoint, you’d reach for ?[‘Value’] on the choice field. Dataverse doesn’t work that way. It stores the option’s integer … read more…
A flow knows exactly which service request it needs, yet the Dataverse step keeps failing with BadRequest or Does Not Exist. Nine times out of ten, the value in Row ID isn’t the row’s real ID. In this tutorial, we’ll use get a row by id power automate flows on a real Service Requests table. … read more…
