My formula filters the employee names that appear in the drop down based on whether or not the employee has a status of active. After that it concatenates the employee name and id and displays it as one in the drop down. But the concatenation does not work because it relies on the Display and Search fields of the drop down being ["Employee Name'] which is the added column. Instead when I try to change it, it defaults back to ["Value"]. The statement works, it is just the Display and Search fields that need to be changed. Any help?
Sort( AddColumns( Filter( Choices('Attendance Tracker List'.TeamMemberID), LookUp('Employee Info', ID = Id).Status.Value = "Active"), "Employee Name", Concatenate('Employee Info'.TeamMemberName, " | ", 'Employee Info'.TeamMemberID) ), "Employee Name" )
