I’ve been doing a lot of Power Automate training lately, and I always ask one of the new users to drive so that I don’t go thru the demo too quickly. This is a great idea if everything goes smoothly. Spoiler….everything did not go smoothly. The Microsoft Team/SharePoint site that we needed to work with did not exist in the user’s drop-down list in the action. Not only did it not exist for my demo user. It didn’t exist for a lot of people, so this was a big problem. There is an easy fix though! Read on to learn how to fix this issue.
SharePoint Site Missing
In training, we were building an approvals flow using SharePoint and Teams actions. The problem occurred in all SharePoint actions, but it was not a problem in Teams actions. Apparently, this is a known issue with 2 fixes/workarounds. Ultimately, I think the list of SharePoint sites shown in the action is NOT a list of all sites a user has access to but rather a list of the sites the user has visited recently or uses most often. I’ve seen similar filtering in Power Automate actions, so this logic wouldn’t surprise me.
Fix Number 1
The easiest fix involves going to the Teams site and uploading a file to a folder. This seems to put the site on Power Automate’s radar. I tested this out with a user, and after she uploaded a file to the Team’s Files and refreshed Power Automate, the site appeared in her drop-down menu.
Fix Number 2
If that doesn’t work, enter the site URL as a custom value. Note, because this worked, we knew it was not a permissions problem.
To find the URL for the SharePoint site that Teams sits on top of, go to the Files section of the team. Click on the Open in SharePoint option.
That will open a website that looks like this.
Grab the URL and put it into Notepad or Word. The URL is made up of your company SharePoint address, the Team name, and then a bunch of stuff that you don’t need. Copy and paste the part shown below.
In the drop-down list in Power Automate, scroll to the very bottom. Select custom value.
Then paste the URL into the Site Address box. You can even see how the sample URL matches the file structure I just described above.
And just for information, note that Teams sits on top of SharePoint, and if you are ever curious about that structure, you can open SharePoint using the link I showed above when in the Files tab of the team OR click the three dots and select Open in SharePoint.
And now you know what to do when a SharePoint site is missing from a list in Power Automate.
Other Sweet Power Automate Content
- Getting Oriented with Power Automate
- Exploring Power Automate Triggers & Actions
- Building & Developing in Power Automate
- Troubleshooting in Power Automate
- Combatting File System Frustration in Power Automate
- What Can You Do With Office 365 Triggers in Power Automate?
- Two Reasons to Keep Tidy Connections in Power Automate
- How to Decipher Dynamic Content in Power Automate