web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Combine 2 Columns to S...

Power Apps

Unanswered

Combine 2 Columns to Single ComboBox

(0) Share

Report

Report

Posted on by Omkar360

25

Hello All,

I have 2 columns 1 is to select the Year, and 2 is to select an employee. I'm using SQL server view as a source.

And I'm trying to concatenate Email and FullName for the second combobox using the below formula.

Distinct(Sort(Filter(AddColumns('Emp.Emp',"Test",Concatenate(email1," ",FullName)),Year = ReqOn_C_SelectSem.Selected.Result),Test,Ascending),Test)

I want to display combined email and full name in the second combo box list.

What I'm missing here? Any suggestions?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Sort by

Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@Omkar360 I tried your code and it's working perfectly fine. can I know what is the error that you're facing?

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Omkar360,

Just speculating here, could it be that you didn't set 'Result' to 'DisplayFields' and 'SearchFields'?

Was this reply helpful? Yes No
omi18 640 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Bilakanti

There is no error I'm getting. It is just the dropdown is not displaying anything. When I click on the dropdown arrow, nothing happens.

Thanks,

Was this reply helpful? Yes No
omi18 640 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Akser ,

Yes, the display fields and search fields value is set to ["Result"]

Thanks,

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Then my second guess would be that something is wrong here:
Year = ReqOn_C_SelectSem.Selected.Result

Was this reply helpful? Yes No

Join the conversation