SharePoint Document Issues

Fix SharePoint Connection Shows 'No Items' in Power Automate

Algirdas JasaitisAlgirdas Jasaitis Oct 19, 2026 869 views

Question details

Users are unable to select SharePoint sites, lists, or resources because the connection dropdown displays 'No items' in Power Automate.

How to Fix SharePoint Connection Showing 'No Items' in Power Automate
Product
Power Automate
Device & OS
not provided
Scenario
Attempting to select a specific SharePoint resource from a dropdown menu while configuring a Power Automate trigger or action.
Observed behavior
The dropdown list fails to load available items, showing a 'No items' message instead of the user's expected SharePoint sites or lists.
Before you start

Ensure your Power Automate account has the correct permissions (at least Edit access) to the target SharePoint sites and lists before troubleshooting the connection.

Solution 1Recommended

Reauthenticate and Verify SharePoint Connection

Refreshing your connection token and checking configuration settings can resolve dropdown loading failures.

Connection issues in Power Automate often stem from expired authentication tokens, insufficient permissions, or temporary backend sync errors. Deleting and recreating the connection forces the system to fetch a fresh token and re-establish access.

1
Navigate to Connections

Log in to the Power Automate portal, expand the left-hand menu, select 'Data', and then click on 'Connections'.

2
Remove Existing Connection

Locate your current SharePoint connection, click the three dots (More commands) next to it, and select 'Delete'.

3
Create a New Connection

Click 'New connection' at the top of the page, search for 'SharePoint', and follow the prompts to sign in with your Microsoft credentials.

4
Test the Dropdown

Return to your flow in edit mode and check if the trigger or action dropdown now displays your SharePoint sites and lists.

Reauthenticate and Verify SharePoint Connection
Manual Entry Alternative: If the dropdown still shows 'No items', scroll to the bottom of the list, select 'Enter custom value', and manually paste the full URL of your SharePoint site.
Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While resolving complex SharePoint and Power Automate integration issues, streamline your everyday document tasks with WPS Office. It provides a lightweight, free, and highly compatible alternative to Microsoft Office.

  1. 1. Download WPS Office: Visit the official WPS website and click the download button for your operating system.
  2. 2. Install the Suite: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
  3. 3. Open Your Documents: Launch WPS Office and instantly open your existing Microsoft Office files without losing formatting.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation ensures fast loading times and smooth performance on any device.Familiar and intuitive user interface ensures seamless migration with zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate fail to list my SharePoint sites?

This usually occurs due to expired connection authentication tokens, insufficient permissions on the SharePoint site, or browser caching issues that prevent the Power Automate interface from retrieving the data.

How can I manually enter a SharePoint site URL if it's not in the dropdown?

In the Power Automate dropdown menu, scroll all the way to the bottom and select 'Enter custom value'. You can then paste the exact URL of your target SharePoint site or list directly into the field.

Will deleting and recreating the SharePoint connection affect my other flows?

Yes. If you delete a connection, any other flows using that specific connection will fail until you update them to use the newly created connection.

What permissions are required to see a SharePoint list in Power Automate?

You must have at least Edit permissions on the specific SharePoint list and the site it resides in to view and interact with it inside Power Automate triggers or actions.