cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Livearus
Helper III
Helper III

Show Gallery Item - SharePoint Choice Field

Hi, everyone,

 

Unfortunately I can't get any further with the following problem.

 

I want to display a choice field from my SharePoint list in a gallery. Now there are already numerous posts where solutions like:

 

Concat(ThisItem.Schichtleitung;Value;",")
ThisItem.Schichtleitung.Value
Choices(ThisItem.Schichtleitung)
Choices([@Schichtberichte].Schichtleitung)

... are described. Unfortunately none of these work for me. My "Label" field just doesn't accept the column. Only the variant with "Concat" outputs a value of the respective element. Just doesn't help me when the element has 2 or more values stored.

 

Do you have a solution for the gallery? I think in form fields it is also easy with:

 

Choices([@Schichtberichte].Schichtleitung)

 

Hoping for feedback, thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
AmDev
Super User
Super User

Hi @Livearus 

 

So from your post I understand that this is a multi-select choice field, and you want to display the value or values chosen in this field within a label on each row of your gallery.

 

You mentioned you are currently using a Label control? - the only way to display these results in a label is as a text string. This can be achieved using the Concat method that you mentioned as concat combines values from a table (which is the data structure of your multi select choice field) - into a string with whatever deliminiter you have specified in your formula.

 

So where you have chosen the following in your dropdown:

Value 1

Value 2

Value 3

 

They would be displayed in your label like this - is this what you found with the Concat functuion?

Value 1, Value 2, Value 3

 

If you don't want them displayed like this, how do you want them displayed? - as a small nested vertical table in each row?

 

If so, you could insert a nested vertical gallery inside your main gallery, set its items property to ThisItem.Schichtleitung - add a label inside your nested Gallery and then set the Text for that label to ThisItem.Value 

 

Hope this helps

View solution in original post

3 REPLIES 3
AmDev
Super User
Super User

Hi @Livearus 

 

So from your post I understand that this is a multi-select choice field, and you want to display the value or values chosen in this field within a label on each row of your gallery.

 

You mentioned you are currently using a Label control? - the only way to display these results in a label is as a text string. This can be achieved using the Concat method that you mentioned as concat combines values from a table (which is the data structure of your multi select choice field) - into a string with whatever deliminiter you have specified in your formula.

 

So where you have chosen the following in your dropdown:

Value 1

Value 2

Value 3

 

They would be displayed in your label like this - is this what you found with the Concat functuion?

Value 1, Value 2, Value 3

 

If you don't want them displayed like this, how do you want them displayed? - as a small nested vertical table in each row?

 

If so, you could insert a nested vertical gallery inside your main gallery, set its items property to ThisItem.Schichtleitung - add a label inside your nested Gallery and then set the Text for that label to ThisItem.Value 

 

Hope this helps

Livearus
Helper III
Helper III

Hey @AmDev 

 

thank you very much for your very quick help. I'm an idiot, I presented the solution myself with the "Concat" function. However, I was wondering why only one value came from the respective element of the selection column in SharePoint.

 

I then looked into SharePoint and noticed that the gallery displayed the elements to be displayed in the wrong order, where only one value was stored in the selection column (SharePoint). (^^)

 

Now it is correct. Sometimes you just stand on the tube 😛

@Livearus - not to worry we've all been there and will all be there again multiple times 🙂 - we just have to accept it's part and parcel of this amazing Power Apps journey we are on! - The important thing is you get sorted and can move on 💪

 

Good luck with the rest of your build!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,440)