Sharepoint List Column Choices from SQL table

%3CLINGO-SUB%20id%3D%22lingo-sub-1087147%22%20slang%3D%22en-US%22%3ESharepoint%20List%20Column%20Choices%20from%20SQL%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1087147%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20if%20it%20is%20possible%20to%20put%20SQL%20table%20values%20in%20the%20Sharepoint%20List%20Choices%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EJuli%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1087147%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1087497%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%20Column%20Choices%20from%20SQL%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1087497%22%20slang%3D%22en-US%22%3EYes.%20You%20can%20either%20%3CBR%20%2F%3E%3CBR%20%2F%3EA.%20Utilize%20PowerApps%20to%20do%20this%20by%20creating%20a%20custom%20form%2C%20and%20pulling%20the%20choices%20from%20a%20sql%20table.%20This%20requires%20PowerApps%20full%20licenses%20since%20SQL%20is%20a%20premium%20connector.%20%3CBR%20%2F%3EB.%20Setup%20Business%20Data%20Connectivity%20to%20connect%20to%20the%20sql%20source%2C%20which%20will%20allow%20you%20to%20pick%20data%20from%20defined%20table%2Fview%20you%20connect%20to.%20See%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fmanage-business-connectivity-service-applications%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fmanage-business-connectivity-service-applications%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all,

 

I would like to know if it is possible to put SQL table values ​​in the Sharepoint List Choices values.

 

Thank you,

Juli

2 Replies
Yes. You can either

A. Utilize PowerApps to do this by creating a custom form, and pulling the choices from a sql table. This requires PowerApps full licenses since SQL is a premium connector.
B. Setup Business Data Connectivity to connect to the sql source, which will allow you to pick data from defined table/view you connect to. See: https://docs.microsoft.com/en-us/sharepoint/manage-business-connectivity-service-applications

From a SharePoint pure point of view, BCS is the answer to this question...but:
(1) It requires the SQL Server you need to connect is accesible on the Internet (of course, SQL Azure is OK for that scenario)
(2) Microsoft has not invested in BCS for years so I would think carefully if BCS is your option here