How to Fix SharePoint Lists Not Refreshing in Power Apps and Access
Question details
The user needs to resolve an issue where SharePoint list data intermittently fails to update in Power Apps and Microsoft Access, leading to connection errors or missing data.

- Product
- SharePoint, Power Apps, Access
- Device & OS
- not provided
- Scenario
- Syncing and viewing SharePoint list data using external database and application building tools like Power Apps and Access.
- Observed behavior
- SharePoint lists fail to refresh across two applications: Power Apps returns no-connection messages or empty data, while Access silently fails to update data without throwing an error message.
Verify your network connection and check the Microsoft 365 Service Health Dashboard to ensure there are no ongoing service incidents affecting SharePoint or Power Apps data connectors.
Troubleshoot Power Apps and Access Connections Separately
Because the refresh issues manifest differently in Power Apps and Access, isolating the connections and treating them as separate troubleshooting paths is highly recommended.
While it may seem like a unified SharePoint error, Power Apps and Access handle data connections differently. Power Apps often requires session re-authentication, whereas Access relies on linked tables that might quietly drop their connection.
In your Power Apps studio, navigate to the Data pane, find your connected SharePoint list, click the ellipsis (...), and select 'Refresh'. If it throws a 'no-connection' error, you may need to re-add the connection.
Open your Access database, navigate to External Data, and open the Linked Table Manager. Select your SharePoint lists and click 'Refresh' to force a manual sync. Note any hidden error messages that pop up during this manual process.
If Power Apps continues to fail, capture the session ID and exact error messages to post in the Microsoft Power Apps Community, as specialized network diagnostics might be required.

Verify SharePoint Site Collection Limits
Ensure that your SharePoint environment has not exceeded the maximum threshold for lists and libraries, which can cause synchronization bottlenecks.
Manage Your Data Seamlessly with WPS Office
Troubleshooting complex data connections between SharePoint, Power Apps, and Access can be time-consuming. If you are looking for an easier, offline-friendly way to track data, manage lists, and create professional reports, consider switching to WPS Office. It provides a highly compatible and lightweight alternative to Microsoft Office.
- 1. Download and Install: Visit the official WPS Office website to download the free installer and follow the quick setup instructions.
- 2. Open Your Data Files: Launch WPS Spreadsheet and instantly open your exported .xlsx or .csv list data without any formatting loss.
- 3. Edit and Manage Safely: Use powerful built-in formulas, pivot tables, and data filtering tools to analyze your information without relying on complex database connections.

Frequently Asked Questions
Why does Power Apps show a 'no connection' message for my SharePoint list?
This usually occurs when the authentication token between Power Apps and SharePoint expires, or there is a temporary Microsoft cloud service disruption. Removing and re-adding the SharePoint data connector in Power Apps often resolves this.
Why doesn't Microsoft Access show an error when my SharePoint list data fails to update?
Microsoft Access linked tables can sometimes drop background connections silently or fail due to cached data. To see actual error messages and force an update, manually refresh the list using the Linked Table Manager in Access.
Is there a limit to how many lists I can have in SharePoint?
Yes. A single SharePoint site collection supports up to 2,000 lists and libraries combined. Approaching this limit can cause performance degradation and data refresh issues across connected applications.
Can I automatically force SharePoint lists to refresh in Power Apps?
Yes, you can use the Refresh() function in your Power Apps formulas. For instance, binding Refresh(YourSharePointList) to a button allows users to manually fetch the latest data directly from the app interface.




