# Moving Power Apps from SharePoint to Dataverse: the gotchas

> What breaks when a Power Apps canvas app moves from a SharePoint list to Dataverse: licensing, maker rights, column types, IDs, choices, and delegation.

[( Insights)](https://tenantcraft.ca/insights)

When one big SharePoint list and its lookups stop holding the shape of your data, Dataverse is the next step that keeps you inside Microsoft 365. The move changes your licences, your admin rights, your column types and half your formulas. Here is what breaks, and the order to deal with it.

Stage

Execute

Topic

Power Platform

Published

Oct 28, 2026

Written by

[Geri Crroj](https://tenantcraft.ca/about)

Tested in a live tenant, October 28, 2026

(Short version)

Price the premium licences first, because Dataverse is a premium connector. Get System Customizer in the target environment before you plan anything. Then rewrite every formula that compares a choice to text, filters on the numeric ID, or reads a person column, because none of those survive the move.

It starts as one list. An asset register, say: a title, a status, who has it, what it cost. Then someone wants locations, so you add a second list and a lookup. Then suppliers. Then a history of who held each laptop, which a list can’t really do, so you fake it with a text column and a flow.

I’ve watched one big SharePoint list with one or two lookup lists get more complicated every time the business asks for something, when what you need is a permanent home for the data that still stays inside Microsoft 365, not SQL.

That home is Dataverse. Same Power Apps, same Microsoft 365 sign-in, real tables with real relationships and row-level security. But the move is not a data source swap. It changes what you pay, who can build, what your columns are, and how half your formulas read.

The 5-minute version

1.  **Dataverse costs money that SharePoint didn’t.** It’s a premium connector, so every app user needs a premium Power Apps licence.
2.  **Being a tenant admin isn’t enough to build.** Creating tables needs **System Customizer** in that environment, on top of **Environment Maker**.
3.  **Columns don’t map one to one.** There’s no Person column, the ID becomes a GUID, and currency adds a second column on its own.
4.  **Choice formulas break quietly.** Dataverse compares choices by an enum, not by the text label your SharePoint formulas use.
5.  **Delegation gets better, not unlimited.** Non-delegable formulas still stop at 500 rows by default.

## When a list has stopped being enough

A SharePoint list is a good back end for one flat table with a few people editing it. It stops being enough when the data has shape: one asset with many assignments, a supplier shared by many assets, rules about who can see which rows.

A list can’t hold that shape on its own, so you work around it. You add a lookup column to point at another list. You type a supplier name into a text column because the lookup won’t do what you need. You build a flow that copies a value from one list to another whenever it changes. Each workaround is fine by itself. After five of them, nobody wants to change anything, because nobody is sure what else will break.

Dataverse gives you the shape directly: tables, relationships, choices, business rules and security roles. If you’re choosing between Dataverse for Teams and a list for a new app, I compared them in [Dataverse for Teams vs SharePoint list](https://tenantcraft.ca/insights/dataverse-for-teams-vs-sharepoint-list). This post is for the app you already have.

## Gotcha 1: the licence changes first

An app built on a SharePoint list runs on the Power Apps rights that come with Microsoft 365. Microsoft puts it simply: “Standard connectors don’t require special licensing.” SharePoint is a standard connector.

Dataverse is not. Microsoft’s connector reference lists it as **Premium** in Power Apps. Once your app connects to Dataverse, every person who runs it needs a premium licence, not just you.

The cheaper per-app option is shrinking too. Microsoft’s licensing overview says the Power Apps per app SKU stopped being available to new customers through some purchasing channels on **January 2, 2026**. Ask your reseller what you can still buy before you budget around it.

Price the licences before you touch a column. It’s the gotcha most likely to stop the project, and the cheapest one to find out.

## Gotcha 2: your admin rights don’t carry over

The next wall is permission, and it hits tenant admins too. On my own admin account, the Tables page in the Default environment showed “One or more commands are unavailable due to your current privileges for this environment.” Selecting **Create with SharePoint list** opened this:

![The Power Apps Tables page in the MSFT default environment. A banner says one or more commands are unavailable due to your current privileges, and a dialog titled Create in new environment says You don't have permission to create here and offers to create a free developer environment.](https://tenantcraft.ca/images/dv-01-no-permission-default-env.png)

Power Apps > Tables > Create with SharePoint list

A tenant admin account with only Environment Maker in this environment. Power Apps offers a developer environment instead of creating the table.

The account had **Environment Maker** and **Basic User** in that environment, nothing else. Microsoft’s security role docs explain why that’s not enough: “Users who make apps that connect to the database and need to create or update entities must have the **System Customizer** role in addition to the Environment Maker role.”

So before planning the build, ask whoever runs your Power Platform environments to give the maker **System Customizer** in the target environment. A tenant admin can add themselves as a system administrator through **Membership** on the environment’s page in the Power Platform admin center. That’s broader than you need, so take it off when you’re done.

Don’t select **Create** on that dialog to get around it. Unmanaged developer environments are suspended starting **December 15, 2026**, so a new one is a poor place to build something you plan to keep. See [where to build now](https://tenantcraft.ca/insights/power-apps-developer-environment-deprecation).

## Gotcha 3: your columns don’t map one to one

I rebuilt a five-column SharePoint asset list as a Dataverse table. Here is what the same columns became:

![The Columns view of a Dataverse table called Asset in Power Apps. Assigned To has the data type Lookup, Cost and Cost (Base) are both Currency, Name is a single line of text and the primary name column, Purchase Date is Date only, and Status is Choice.](https://tenantcraft.ca/images/dv-02-dataverse-columns.png)

Tables > Asset > Columns

Assigned To is a lookup to the Users table, not a person column. Adding Cost as currency also created Cost (Base).

| What it holds | SharePoint list | Dataverse table |
| --- | --- | --- |
| Item name |
Title Single line of text

 |

Name Primary name column. Rename your references.

 |
| Status |

Choice (text) Saves the words, like In use

 |

Choice (number) Saves a number under the label. Compare with the enum.

 |
| Who has it |

Person or Group Has .Email and .DisplayName

 |

Lookup to Users Read fields on the user row

 |
| Cost |

Currency One column

 |

Currency plus (Base) Base holds your base currency

 |
| Row ID |

ID Shown as a number

 |

GUID No integer IDs. Add an autonumber.

 |
| Link to other data |

Lookup to a list Points at another list

 |

Lookup to a table A real relationship

 |

Strong on this point A limit to plan for

There’s no Person column type in Dataverse. People live in the **Users** table, and your column points at a row there.

## Gotcha 4: formulas that break, and how to fix them

Three patterns break first when you point the app at the new table.

### Choices: stop comparing to text

In SharePoint, a choice is text, so this works:

```
Filter('Asset Register', Status.Value = "In use")
```

In Dataverse, Microsoft says a choice is “backed by a number.” The label is for display, and you “can’t compare the labels directly.” You compare against the choice’s enum instead:

```
Filter(Assets, Status = 'Status (Assets)'.'In use')
```

The enum name for a choice that belongs to one table includes the table name in brackets, which is why it needs single quotes.

### IDs: stop treating them as numbers

SharePoint’s ID looks like a number in Power Apps. Microsoft notes its “underlying type is actually Text,” and only `=` delegates on it. In Dataverse the row key is a **GUID**, so a SharePoint formula like this has no direct equivalent:

```
LookUp('Asset Register', ID = 42)
```

If people quote asset numbers out loud (“ticket 42”), add your own number column, such as an autonumber, and filter on that. Don’t use the row key for anything a person reads.

### People: read the user row

A SharePoint person column gives you `AssignedTo.Email`. In Dataverse, **Assigned To** is a lookup, so you read a field on the related user:

```
ThisItem.'Assigned To'.'Primary Email'
```

To set it, pass a user row, not an email string. `LookUp(Users, 'Primary Email' = User().Email)` returns the current user’s row.

## Gotcha 5: delegation improves, but it still has a ceiling

Dataverse delegates more than SharePoint does. **In**, **CountRows** and **Sum** all delegate to Dataverse, and none of them appear in Microsoft’s delegation table for SharePoint. That alone fixes a lot of apps that silently showed partial lists.

The ceiling is still there. When a formula can’t delegate, Power Apps fetches the first **500** rows and works on those. You can raise the **Data row limit** in app settings to **10,000**, but rows past the limit never show up.

The warning is easy to miss. Microsoft says a non-delegated formula over 500 records gets a **blue underline**, and the control gets a yellow triangle. It’s a warning, not an error, so the app still saves and runs.

While you test a migrated app, set **Data row limit** to 1. Microsoft suggests it too. Anything that isn’t delegated returns one row, and you’ll spot it on the first screen.

## Moving the data itself

The table is the easy part. Moving the rows is where the lookups bite.

In testing, the preview **Import a SharePoint list** option on the Tables page returned “The connections could not be loaded. Please try again later.” on every attempt. I built the table directly instead. Don’t plan a go-live around a preview button.

Whether you load with a dataflow, a flow or an Excel import, go in this order:

1.  **Tables with no lookups first.** Locations, suppliers, anything other rows point at.
2.  **Then the main table,** matching each lookup by a value both sides share, such as a location name.
3.  **People last,** matched by email to rows in **Users**. Anyone who has left the organization won’t have a row, so decide now what those items show.

Keep the SharePoint list read-only until the app has been live on Dataverse for a full business cycle. If something’s wrong, you still have the original.

## Before you flip the data source

1.  **Licences priced and approved** for every user who runs the app.
2.  **System Customizer** granted to the maker in the target environment.
3.  **Every column mapped,** using the table above, with a decision for Person and ID columns.
4.  **Formulas searched** for `.Value = "`, `ID =` and `.Email`, which are the three patterns that break.
5.  **Data row limit set to 1** for one full test pass.

## What this does not fix

-   **A messy list stays messy.** Dataverse won’t clean up duplicate suppliers or free-text locations. Clean them before you load, or you’ll build real relationships on bad keys.
-   **Flows need rework too.** Flows triggered by the SharePoint list stop firing for new rows. Rebuild them on the Dataverse trigger.
-   **Security roles are a new job.** Dataverse controls access per table and per row through roles, not through list permissions. Someone has to design those.
-   **Storage is metered.** Dataverse database capacity is pooled across the tenant. Check it in the Power Platform admin center before you load years of history.

## The bottom line

Move when the shape of your data has outgrown lists, not because Dataverse sounds more serious. Price the premium licences first and get **System Customizer** in place. Then map every column and rewrite the choice, ID and person formulas before the app sees real data.

The licence change is the line item that sinks Dataverse moves. The cost scoping guide helps you price it before anyone rebuilds a table.

SharePoint Migration Cost & Scoping Guide

PDF · 7 pages

[Email me the PDF](https://tenantcraft.ca/resources/guides/migration-cost-scoping-guide)

---

_Canonical HTML: https://tenantcraft.ca/insights/power-apps-sharepoint-to-dataverse-migration · Agent guide: https://tenantcraft.ca/llms.txt · Site map: https://tenantcraft.ca/sitemap-index.xml_
