SharePoint Document Issues

How to Fix SharePoint Lists Not Refreshing in Power Apps and Access

Khadija KhanKhadija Khan Nov 3, 2026 869 views

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.

How to Fix SharePoint Lists Not Refreshing in Power Apps and Access
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.
Before you start

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.

Solution 1Recommended

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.

1
Refresh Power Apps Data Source

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.

2
Check the Linked Table Manager in Access

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.

3
Gather Diagnostics

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.

Troubleshoot Power Apps and Access Connections Separately
Microsoft Community Support: Power Apps connection behaviors are updated frequently. The official Microsoft Power Apps Community is the best resource for diagnosing app-specific connection timeouts.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS Office website to download the free installer and follow the quick setup instructions.
  2. 2. Open Your Data Files: Launch WPS Spreadsheet and instantly open your exported .xlsx or .csv list data without any formatting loss.
  3. 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.
Manage massive data lists effortlessly using WPS Spreadsheet without dealing with complex cloud connector dropouts.Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) file formats.A completely free, lightweight suite that runs smoothly on Windows, Mac, Linux, and mobile devices.Familiar interface ensures a seamless transition with zero learning curve for existing Microsoft Office users.
microsoft office alternative - wps office

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.