Hi @SharePointDev ,
Do you mean that:
1)in employeemaster list, you have an employeeId column;
2)in Azure Sql table, you have a column to store selected ids;
3)use a combo box to display employeeId in employeemaster list, use a textinput to display selected ids?
If so, you should set like this:
In edit screen:
1)combo box's Items:
EmployeeMasterData
combo box's DefaultSelectedItems:
Filter(EmployeeMasterData,'Employee ID' in ThisItem.StEmployeeID)
2)textinput's Default:
If(Form3.Mode=FormMode.View,Parent.Default,
Concat(DataCardValue19.SelectedItems,'Employee ID'&",")
)
3)This datacard's Update:
TextInput7.Text
In view screen:
Do you want to display all related first names?
If so, you could set one label's Text like this:
Concat(
Filter(EmployeeMasterData,'Employee ID'in ThisItem.StEmployeeID),
'First Name'&","
)
Best regards,
