Nov 23 2020
I'm not a SharePoint dev, but have some experience with SharePoint lists and also SQL.
However not in combination.
While researching this, I notice "Business Connectivity Services" seems to be the answer.However it seems BCS isn't really actively worked on? Is using this future proof?Lets take this simple example:In a Azure SQL database we have a list of clients.In a SharePoint list I want a choicefield with a dropdownlist populated with the names of these clients.