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.
Solved! Go to Solution.
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
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
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!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
191 | |
67 | |
46 | |
41 | |
21 |
User | Count |
---|---|
254 | |
121 | |
84 | |
80 | |
73 |