Jan 30 2020 09:56 AM - edited Jan 30 2020 09:58 AM
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