Jul 30 2019 06:50 PM
I'm trying to create an external SharePoint list to a SQL Table (Done this before). However, when trying to complete the step of External Content Type I am having no luck
Connecting to SharePoint Online through the Designer tool then navigating to External Content Types is not working for me.
I first get:
The Business Data Connectivity Metadata store is currently unavailable.
Then I get the following when clicking "External Content Type":
The HTTP Service located at https://<org>.sharepoint.com/_vti_bin/BDCAdminService.svc is unavailable. This could be because the service is too busy or because no endpoint was found listening at the specified address. Please ensure that the address is correct and try accessing the service again later. (The remote server returned an error: (503) Server Unavailable.
Jul 30 2019 11:19 PM
SolutionJul 31 2019 05:15 AM
@Juan Carlos González MartínThanks Juan. The problem was on Microsoft's side they actually have a notification message in the Info centre. Their support was really quick getting back to me (5min) after putting a ticket in through the portal.
Do you know any other method of pulling a table from Azure SQL to populate a SharePoint column without using BCS?
Jun 02 2021 11:27 PM
@myke_deabreu one option could be you can use Power Automate to connect to Azure SQL and then update the SharePoint list with required data.
Dec 20 2021 10:54 PM
Apr 28 2022 04:02 PM
Jul 30 2019 11:19 PM
Solution