Hello,
I have a dropdown that holds the employee's ID concatenated with their display names, and a text field that populates the employee's ID's based on a dropdown that also populates the current user signed-in.

What I am trying to achieve is the following:
Once the ID is populated let's say "1000", I want the dropdown to look for this ID and auto select/populate directly the employee ID + Employee Name.
The Items property of the dropdown is below:
AddColumns('Employees Information',"EmployeeInformation",Concatenate('Employee Number',"-",'Direct Reporting Line Name'))
The Employee ID text field is dependant on another dropdown that populates the current user signed in as I mentioned above:
LookUp('Employees Information', 'Employee Name'.DisplayName = DataCardValue2.Selected.DisplayName, 'Employee Number')
I have tried to set the default selected items of the dropdown as below:
{EmployeeInformation:Concatenate(DataCardValue1.Text," - ",DataCardValue2.Selected.DisplayName)}
The above function pulls the data returned from the fields, concat both fields and add the above value to the dropdown but it's not a good solution, because I want to auto-select the value without creating new value in the dropdown based on the employee ID that means if I clicked on the dropdown directly it takes me to the value selected.
Is it possible to achieve the above scenario?
Can please someone explains in detail and provide an example?
Any help will be greatly appreciated.
Thank you!