Microsoft Developer Network

Hi everyone,

I'm encountering some persistent issues with offline data synchronization in my Power Apps canvas application. Users report that data created offline is not syncing back to the Dataverse when they reconnect to the internet. I've followed the standard procedures for enabling offline profiles and offline capabilities in my app, but it seems something is still not quite right.

Here are some key details:

• App Type: Canvas App
• Data Source: Dataverse
• Offline Capability: Enabled
• Issue: Data entered offline does not reliably sync back upon reconnection. Some records sync, others don't.

I've checked the device logs, but I'm not seeing any explicit error messages related to synchronization. Has anyone faced similar challenges and found a resolution? Any tips or best practices for debugging offline sync would be greatly appreciated.

Thanks in advance!

Hello User123,

Thanks for reaching out. This is a common area for troubleshooting. Let's look into a few potential causes:

1. Data Relationships and Dependencies

Ensure that all tables involved in offline data collection have proper relationships configured and that the offline profile includes all necessary related tables. If a record depends on data from another table that isn't synced or available offline, it can cause sync failures.

2. Data Volume and Complexity

Very large datasets or complex data structures can sometimes strain the offline synchronization process. Try testing with a smaller subset of data or a simplified data model to isolate the issue.

3. Custom Logic and Controls

Are you using any custom connectors, Power Automate flows triggered by data changes, or complex JavaScript within the app that might interfere with the default synchronization mechanism?

4. Network Conditions

While you've mentioned reconnection, intermittent or unstable network conditions can also lead to partial syncs. Ensure users have a stable connection when attempting to sync.

Could you please provide more details on your data model and any custom logic you've implemented?

I had a similar issue last month! It turned out to be a problem with a date/time field. The offline sync was having trouble with the time zone conversion when syncing back to Dataverse. We had to explicitly set the time zone for that specific field in the app.

Check your date/time fields carefully!

Thanks for the quick responses, MSFT_Support and User456!

MSFT_Support:

• Data Relationships: We have a few related tables, and they are all included in the offline profile. Relationships are standard lookup fields.
• Data Volume: The primary table has about 5000 records, and related tables have fewer. This seems manageable.
• Custom Logic: No custom connectors or flows directly impacting these specific tables. We use a few on-save business rules in Dataverse, but nothing that should prevent basic data entry sync.
• Network: Users are typically in areas with spotty Wi-Fi, so the offline capability is crucial.

User456: That's a great tip! We do have a few date/time fields, including a "Last Modified" timestamp. I'll investigate how those are being handled offline and during sync. We're using the default Power Apps controls for these fields.

I'll perform some targeted testing on the date/time fields and report back.