Concatenate two SharePoint list columns in a dropdown

(0) Share

Report

Posted on by HarishaAkkil

144

Hi Team,

I have a SharePoint list Employee, having columns, EmployeeName and EmployeeID. In PowerApps I need to display EmployeeName and EmployeeID in a single dropdown.

Below is the display Format:

The dropdown should display EmployeeName and in brackets EmployeeID -> EmployeeName (EmployeeID).

Also, I need it in sorting order based on EmployeeName and should satisfy the condition, SystemStatus = "Pending".

Already, I have a dropdown displaying only Employee Names in sorting order. And additionally, we allow searching the dropdowns based on the text in the search box.

Sort(Filter(EmployeeList,StartsWith(EmployeeName,SearchBox_Ename.Text) && SystemStatus<>"Pending"),EmployeeName,Ascending)

Now, could you please help me with the same condition, but displaying with both EmployeeName and EmployeeID?

Thanks,

Harisha

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
Hi @HarishaAkkil ,

If you just want to display the one field in the dropdown

Sort( Filter( AddColumns( EmployeeList, "NameID", EmployeeName & " (" & EmployeeID & ")" ), StartsWith( EmployeeName, SearchBox_Ename.Text ) && SystemStatus <> "Pending" ), EmployeeName ).NameID

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

HarishaAkkil 144 on at

Like (0)

Report
Thankyou @WarrenBelz. It did work for me. Thank you so much.
The one thing in the formula is, that a comma is missing after the "NameID".
Sort( Filter( AddColumns( EmployeeList, "NameID", EmployeeName & " (" & EmployeeID & ")" ), StartsWith( EmployeeName, SearchBox_Ename.Text ) && SystemStatus <> "Pending" ), EmployeeName ).NameID

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

Hi @HarishaAkkil ,

Now fixed - that tends to happen free-typing code in Notepad without the "red lines" you have to show errors.

Was this reply helpful? Yes No