Hello there,
I'm working on setting up Files Connect with SharePoint online.
After setup, currently, the External Source seems to be connected and Authenticated (as seen the External Data Sources entry Administration Authentication Status | Authenticated
However, as a User, when trying to Access the SharePoint, after clicking "Trust" to connect my account, I'm getting the common / Know Issue "Can't access external source. External data source is unavailable because of an error."
The Known issues page proposes two workaround.
I tried No 1, pretty small change in the Setup, but it did not work...
No 2 suggest to "create an external authentication record for the user" Is that something that the Admin must do on the Setup or is this something the end User must do?
I'm asking because its confusing. On this Help Page it says
Before you begin your administrator:
Sets up the external data source or named credential to use per-user authentication.
- Grants you access to the external data source or named credential.
- Verifies that your org can connect to the external system.
- Tells you the authentication settings to enter.
- Sets up the community, if applicable, by using the Salesforce Tabs + Visualforce template.If the community is built with the Customer Service template, only your administrator can set up and manage your authentication settings for external systems. You can’t complete these steps on your own.
Any guidance here is very welcomed
I know this is a very old question, but just in case it helps someone. The External Data Source should first be granted to the individual user via permset/profile. That is all it meant by the bolded line.
User should now see a banner they can follow to authenticate with that data source, or otherwise follow.
If you get to the point where you are seeing an error like this
"Can't access external source. External data source is unavailable because of an error" and you are using the Auth Provider approach, it is most likely a problem with the permissions granted on the Sharepoint (Azure Management Console's Web Application ) side. The SF help docs just say "add permissions", but it doesn't work unless you add a specific set:- AllSites.FullControl
- EnterpriseResource.Write
- MyFiles.Write
- Sites.Search.All
if you add all those, then resync the external source metadata and try again it should work
