cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Display Sharepoint combo box values

Hello,

 

I have a combo box in Sharepoint list for "Market" column. Users can select multiple markets for their records for a vendor. The App I'm building allows the user to search for a vendor and if someone already added markets for it, it will display them. From home screen, user will search for a vendor. If the vendor is found, it takes them to a detail screen that shows the vendor name, their market, and other attributes in a Fetch gallery. All other attributes are displaying in the Fetch gallery except the market. I'm having trouble displaying the values in a Dropdown control box or a label (any would do).

 

I've tried "ThisItem.Market.Value" but it throws the incompatible table values error. I've also tried adding a dropdown control and gave said Items = Choices(VendorSource.Market) but that does not return anything in display mode. Can anyone give me guidance on how to solve this issue?

 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate III
Advocate III

Re: Display Sharepoint combo box values

Using Concat in a label (with concatenate to space separate the values) works for me inside a gallery control - I don't think it is possible to put a table inside a gallery. scrn.png

View solution in original post

7 REPLIES 7
Highlighted
Advocate III
Advocate III

Re: Display Sharepoint combo box values

Can you display them in a table control? Or their own gallery? Since this is a multiselect, I'm guessing the .Value is repeating....

Frequent Visitor

Re: Display Sharepoint combo box values

Tried, still not showing. It is multiple value though you are right.

Highlighted
Advocate III
Advocate III

Re: Display Sharepoint combo box values

So, I tried this in a simple sample app - in mine, I'm moving from a gallery to a form, and I had to put the data table outside of the form - but it did display my items. I set the items property to the .Value of my multi-select, and then had to select the "Value" field for display. Pardon my weird test data. 🙂

scrn.png

Highlighted
Advocate III
Advocate III

Re: Display Sharepoint combo box values

I should add - I just tried adding a display form to a new screen and my multi-select displayed correctly there too - are you using a form control for display?

Highlighted
Frequent Visitor

Re: Display Sharepoint combo box values

Aha! that was the missing piece. I was trying to fetch from data source instead of the gallery. GalleryList.Selected.Market works. Thank you!

 

However, it's only bringing in the Market values for a particular vendor if I click on it. Which is fine if there's only one vendor but I have multiple. Is there a way to make the Table go inside the GalleryList so each Vendor will display their respective market(s) along with the rest of their attributes?

Highlighted
Advocate III
Advocate III

Re: Display Sharepoint combo box values

Using Concat in a label (with concatenate to space separate the values) works for me inside a gallery control - I don't think it is possible to put a table inside a gallery. scrn.png

View solution in original post

Highlighted
Frequent Visitor

Re: Display Sharepoint combo box values

That worked. Thank you!!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,604)