Power Platform Community Forum Thread Details

I am trying to copy the content of an Excel file from a online Excel file into a sharepoint list. Both, the excel file and the list are part of the sharepoint tenant of an external organization. When I am logged in on the sharepoint site with a webbrowser I have write access to both.

When I use an excel online (Business) task to connect to sharepoint all works fine i get my groups the folders etc.

However when I do the same with a sharepoint task nothing is no locations no groups etc

If I manually put in the site location it cannot find the list.

I have also checked this behavior on our own tenant there again everything work without issue.

I assume this is a rights issue but which rights are actually needed to be set to get this working?

Hi @DK-13031057-0,

At the first place, it seems a permission issue. Let's troubleshoot the following areas:

Verify that your user account has the necessary SharePoint permissions on the external tenant.
Check Azure AD cross-tenant access settings and ensure your tenant/user is allowed.
Confirm that the Power Automate connectors have the required delegated or app permissions.
Review any Conditional Access policies that might block API or connector access.
Use Microsoft Graph Explorer or Postman with your credentials to test access to the SharePoint site and list.

When accessing SharePoint sites and lists across tenants using Power Automate, the following permissions and rights are typically required:

User Permissions on SharePoint Site and List : The user account must have at least Contribute permissions on the target SharePoint site and list to create or update items. Permissions can be granted via SharePoint groups or directly assigned.
Azure AD Consent and App Permissions: The Power Automate connectors use Azure AD authentication. The user or service principal must have consented to the required permissions. For SharePoint connector, delegated permissions like Sites.ReadWrite.All are needed to access and modify SharePoint sites and lists. If using an app registration or service principal, it must have the appropriate application permissions granted and admin consented.

Finally, it sounds like when you use the SharePoint connector in Power Automate to connect to the external tenant, it doesn't show any groups, sites, or folders, unlike the Excel Online (Business) connector which works fine. This usually happens because the SharePoint connector requires explicit permissions and proper configuration to access sites and lists in an external tenant, even if you have browser access. The Excel Online (Business) connector may be using delegated permissions tied to your user session, while the SharePoint connector might need additional consent or a different authentication context.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!