PowerApps - 2 ways to populate dropdown / combobox with multiple fields concatenated from SharePoint

In this video I will show you how to populate your dropdown or combobox with concatentated values so you can display more than one field in the dropdown results.

Code Used:
Straight in the dropdown:
SortByColumns(AddColumns('Test Vendors', "FullDescription", Concatenate(Title, " - ", Department.Value, " - ", 'Contact Email')),"Title")

Creating from a collection:
ClearCollect(ItemCollectionCol, AddColumns('Test Vendors', "FullDescription", Concatenate(Title, " - ", Department.Value)))

Links mentioned in this video

Hey welcome to WeTechCareOfYou!
If you are a returning subscriber we wish to say thankyou!

We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts:

✅Express VPN - Get a 30-Day Money Back Guarantee with our link.
A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider:

✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage:

✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint:

*Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well.

Kind Regards,
The WeTechCareOfYou Team 💙

[cliverussell]

Great video, thanks really helpful and much appreciated. I’m trying to run a ‘searchinput’ formula that works fine when the data source is a list, not so when its an excel table. Any thoughts?

[gregoirepesenti]

Hi there, you help me a lot, but I need to go further down :

At first, in the items property of my combobox, I had this function :



Basically, I'm filtring through my sharepoint document library document(s) that start with the same name that is populate in a label "Material.text"

But, I would like to had multipied fields as you did, in my combobox, si I went with this one :

-

It works, has you shown in the video, but I am not filtering anymore, very annoying, so I tried this one :

-

If I understand correctly your technique, the old "starwith(NumArticle)" should be know the brand new column "ArticleDate" right ? But nothing appear in my combobox. I tried to go back to starwith(NumArticle)", but still, nothing happen.

SO, is it possible to filter over an addcolumns ? If yes, what did I do wrong ?

Thanks you very much for your help