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
PowerApps Invoice Generator which automatically creates PDF invoice – App Demo / Overview – https://www.youtube.com/watch?v=K8I9Q4d0n0c&t=35s&ab_channel=WeTechCareOfYou
PowerApps – Clean Design Template for Form – https://www.youtube.com/watch?v=ct6MpU35Qm8&t=30s&ab_channel=WeTechCareOfYou
👉 Hey welcome to WeTechCareOfYou!
If you are a returning subscriber we wish to say thankyou!
If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email [email protected] or complete a form here: https://wetechcareofyou.com/contact/
Kind Regards,
The WeTechCareOfYou Team đź’™
We’re 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 affilliate 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:
https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0
👉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:
https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0
👉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:
https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0
*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. Take Care 🙂
Comments are closed.