SharePoint External Data Column

%3CLINGO-SUB%20id%3D%22lingo-sub-1141077%22%20slang%3D%22en-US%22%3ESharePoint%20External%20Data%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1141077%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20SharePoint%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20that%20tracks%20information%20about%20employees.%26nbsp%3B%3C%2FP%3E%3CP%3EMost%20columns%20are%20SharePoint%20list%20columns%20and%20will%20be%20updated%20manually%20by%20a%20user.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20there%20is%20a%20column%20that%20we%20need%20to%20pull%20in%20from%20an%20external%20system's%20data%20source%20(Azure%20SQL%20Database).%26nbsp%3B%20This%20column%20is%20called%20%22Active%22%20and%20will%20hold%20the%26nbsp%3Bvalue%20for%20whether%20an%20employee%20is%20active%20or%20not.%26nbsp%3B%20example%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEmployeeID%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BActive%3C%2FP%3E%3CP%3E1%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20yes%3C%2FP%3E%3CP%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20no%3C%2FP%3E%3CP%3E3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20maybe%3C%2FP%3E%3CP%3E4%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20yes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20using%20the%20BCS%20and%20creating%20an%20external%20data%20column%20in%20my%20employee%20list%20to%20pull%20in%20the%20%22Active%22%20value%20and%20align%20it%20to%20it's%20corresponding%20employee%20ID%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1141077%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eexternal%20data%20column%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi,

 

I'm using SharePoint Online.

 

I have a SharePoint list that tracks information about employees. 

Most columns are SharePoint list columns and will be updated manually by a user.

 

However, there is a column that we need to pull in from an external system's data source (Azure SQL Database).  This column is called "Active" and will hold the value for whether an employee is active or not.  example below:

 

EmployeeID         Active

1                            yes

2                            no

3                            maybe

4                            yes

 

Is it possible using the BCS and creating an external data column in my employee list to pull in the "Active" value and align it to it's corresponding employee ID?  

 

Thank you for your help

0 Replies