web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown in form - sho...

Power Apps

Answered

Dropdown in form - show multiple column values?

(0) Share

Report

Report

Posted on by jpg89

9

Hi there,

I have a Sharepoint List as follows, which is acting as a data source for a field in form below.

I then have a Sharepoint List which is where I will submit my form data to. I have built a Power App which submits form data to here as a new item to the list. I have included a Lookup column here for Cost Centre which I want to store the Cost Centre Number only.

The problem is that the dropdown field on my form looks like this...

Only the number shows, so it is too vague for the user to know which item they're picking.

How can I make it so that it looks like

"12345 | Cost Centre A"

"23456 | Cost Centre B" etc

And then when the user chooses the item, it just stores the Cost Centre Number in the field??

I just want to show some secondary text here in the dropdown items, to assist the user in making their choice. Functionally it seems to be working fine as it is though.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LowCodeJim 314 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jpg89,

You should be able to do this by doing an additional call to your lookup list in the items property of your Cost Centre combo box. The items value of the combo box should look something like this:
AddColumns(Choices(<MAINLIST>.CostCentre),"ExpandedCC",Value & " | " & First(Filter(<LOOKUPLIST>,ID = Id)).'Cost Centre Name')

Replacing <MAINLIST> with the list the form is using and <LOOKUPLIST> with the AppData_CostCentre list which will need to be added to the app as the form list has been.

You should then be able to use the new column you have created, "ExpandedCC", as the value in your dropdown instead of the default "Value"

Hope that helps!

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.

Was this reply helpful? Yes No
jpg89 9 on at

Like
a
(1)

Report
Copy link

Link copied!

Legend! This did the trick perfectly well... thanks so much I will make my deadline now 😅

I used something similar to your formula to create the additional column, and was able to use this 'secondary text' column as my dropdown field ('Single' layout still, but choosing my new column)

I also submitted the form data and it was added to my master list with just the "12345" value which is perfect.

Was this reply helpful? Yes No

Join the conversation