Mobile offline limitations for canvas apps
Before you set up the mobile app in offline mode, be sure to read through the following limitations. We recommend that you also review Best practices for developing an app for offline use and Optimize the offline profile.
Capabilities not supported in offline-enabled apps
| Area | Description |
|---|---|
| Canvas app types | The offline-first feature works for standalone canvas apps only. It doesn't work for embedded canvas apps, custom pages, or canvas apps in Teams. |
| Connectors | Non-Dataverse connectors, like SharePoint, aren't supported in offline mode. |
| Dataverse table types | Virtual tables and elastic tables aren't supported in offline mode. |
| Shared offline profile | If the same, offline profile is used in a canvas app and in a model-driven app, it creates two, separate local databases. |
Note
If your app connects to data from Excel, CSV files, or SharePoint lists, you can start with Copilot to import data to Dataverse. Once your data is in Dataverse, you can turn on offline support for your canvas apps with one selection.
Offline runtime limitations
| Area | Description |
|---|---|
| Offline record limit | The total number of records synced is limited to 3,000,000. Attempts to sync a larger number of records fail. This number also includes hidden tables used for offline capabilities. |
| Power Fx functions | The offline-first feature works with Dataverse tables only and doesn't support the following Power Fx functions: Relate, Unrelate |
| Relationship | Many-to-many relationships aren't supported in offline mode in canvas apps. Filtering on column look-ups only supports one level of the relationship when the app is configured for offline use. |
| Tables | Annotations aren't supported in offline mode in canvas apps. |
| Column types | Calculated and roll-up fields—that are part of rows synced to the client—aren't reevaluated by the client. The reevaluation happens on the server when the updated row is synced. When you run an app in offline mode, mapped fields aren’t prepopulated when you create a new record from a table that has fields mapped to another table. |
| Sort order | Items in a gallery may appear in a different order in an offline-capable app if no sort order is selected. Choose a sort order in the gallery control to make sure the app behaves consistently in mobile apps and web browsers. |
| Background synchronization | Data can only be synced regularly when Power Apps is running in the foreground of your device, with the screen unlocked. Learn more in Sync data offline in the background. |
Profile filters limitations
| Area | Description |
|---|---|
| Relationship defined for each table | A maximum of 15 relationships is allowed. There is a maximum of one many-to-many (M:M) or one-to-many (1:M) relationships within the 15 relationships. If any custom tables demand this scenario, then revisit the data model. No circular references or self-references are supported. |
| Images and files | Images and files are subject to the same limitations as any other table. Because of implicitly defined relationships, an offline profile can only contain up to 14 image columns, across all entities. |
| Auto-generated offline profile | The auto-generated offline profile doesn't handle filters. As a result, for each table used in the app, it downloads all rows to which the user has permissions. |
See also
Troubleshoot offline sync errors in the Power Apps mobile app