cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RustyNails
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

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
hilary_stoupa
Kudo Kingpin
Kudo Kingpin

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

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

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

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?

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?

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

That worked. Thank you!!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (4,026)