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 to use an app for offline and Optimize the offline profile.

Limitations and known issues

• 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.

• A canvas app not in a solution can't be used in offline mode.

• 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.

• The offline-first feature works with Dataverse tables only and doesn't support the following Power Fx functions:

  • Relate
  • Unrelate
  • UpdateIf
  • RemoveIf

• Filter on column look-up only supports one level of look-up when the app is configured for offline use.

• Many-to-many relationships aren't supported in offline mode.

• Non-Dataverse connectors, like Sharepoint, aren't supported in offline mode.

Note

If using offline mode and your data is in Excel or CSV files or SharePoint lists, we recommend creating a canvas app with external data, which uses Copilot to assist with the Dataverse table generation.

• Virtual tables and elastic tables aren't supported in offline mode.

• 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.

• An offline profile can't be used in two canvas apps.

• If the same offline profile is used in a canvas app and in a model-driven app, it will create two separate local databases.

• 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.

• 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.

• Data can only be synced regularly when Power Apps is running in the foreground of your device, with the screen unlocked. Learn more: Sync data offline in the background

Profile filters limitations

Profile details	Limitation
Relationship defined for each table	A maximum of 15 relationships is allowed. The 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.

See also

Troubleshoot offline sync errors in the Power Apps mobile app