Display multiple columns in a Lookup Combo Box Form

(0) Share

Report

Posted on by JoshBog

I have a form (tbl_Incidents) with a data card with employees. The table that it is pulling from has a lookup value to the employees table.

I am trying to add a row in tbl_Incidents which has a lookup column pointing to tbl_Employees. When I create the edit form, the primary key from tbl_Employees shows up and I can change it to one other column (first_name). I want to have it display "first_name, last_name".

I tried Concatenate(["cr4ac_first_name"],", ",["cr4ac_last_name"]) in the DisplayFields but it just shows blank rows.

Thanks for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @JoshBog

Another option is to change the Layout of the combo box from Single to Double and display First Name and Last name.

Example
Now your DisplayFields of the combo box should be

["cr4ac_first_name","cr4ac_last_name"]

Thanks,
Stalin - Learn To Illuminate

1 people found this reply helpful.

Was this reply helpful? Yes No