Fix SharePoint Connection Shows 'No Items' in Power Automate
Question details
Users are unable to select SharePoint sites, lists, or resources because the connection dropdown displays '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.
Ensure your Power Automate account has the correct permissions (at least Edit access) to the target SharePoint sites and lists before troubleshooting the connection.
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.
Log in to the Power Automate portal, expand the left-hand menu, select 'Data', and then click on 'Connections'.
Locate your current SharePoint connection, click the three dots (More commands) next to it, and select 'Delete'.
Click 'New connection' at the top of the page, search for 'SharePoint', and follow the prompts to sign in with your Microsoft credentials.
Return to your flow in edit mode and check if the trigger or action dropdown now displays your SharePoint sites and lists.

Consult the Power Automate Community
Escalate the issue to the specialized Microsoft Power Automate community for advanced support if standard troubleshooting fails.
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. Download WPS Office: Visit the official WPS website and click the download button for your operating system.
- 2. Install the Suite: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Documents: Launch WPS Office and instantly open your existing Microsoft Office files without losing formatting.

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.




