Since the SharePoint site you're trying to access is in a different tenant, you do need to authenticate correctly across tenant boundaries.
Here’s what you can do:
1. Use a Connection with Cross-Tenant Permissions
In Power Automate, when you need to access a SharePoint site in a different tenant, the connection you use to authenticate needs to have proper permissions. If you're getting an "unauthorized" error, it might be because the connection is only valid within your tenant.
2. Use a Service Principal or Azure AD App (for Advanced Scenarios)
If you're working with automated flows and need to set up cross-tenant access programmatically, using an Azure AD app (service principal) can be a solution.
- Solution: Set up an Azure AD app in the external tenant and grant it the necessary permissions to access SharePoint files. This method involves more setup, but it allows for seamless integration between tenants.
3. Workaround Using External Sharing
If you're encountering issues even with proper access, check that the external SharePoint site allows external sharing or guest access. Sometimes, SharePoint sites restrict access to users outside their tenant.
Steps for Direct Access:
- Go to Power Automate > Data > Connections.
- Create a new SharePoint connection.
- Choose the account that has access to the external SharePoint site.
- Ensure you are using the correct SharePoint site URL for the external tenant.
Key Considerations:
- Make sure your account is granted permission specifically on the SharePoint site in the external tenant.
- Check with the SharePoint admin if there are any restrictions on accessing the site from outside the tenant.
- When using a service principal, you may need admin consent to allow cross-tenant authentication.
----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!
