How to display multiple choice fields in gallery?

[Niels_T]

Hello,

I have made an app connected to sharepoint list with columns that use multiple choice.

I would like to display this information in a gallery as well, however I always get the error message that the formula uses scope.

I tried the following as well:

Concat(ThisItem.Prefix, Value, ", ")

This however also doesn't seem to fix the problem.

[v-qiaqi-msft · Accepted solution]

Hi @Niels_T,

Do you want to display the multi-select choice column in the Label?

Could you please tell me that if the Prefix is a Choice column allowing multi select?

Actually, if the Prefix is a Choice column allowing multi select, the formula you provided is correct.

However, if the Prefix is a Choice column allowing single select, you should modify your formula as below:

ThisItem.Prefix.Value

If the above could not help you figure it out, please post the specific error message by hovering over on the red wave line.

[Akash17]

Hi,

Your formula is correct "Concat(ThisItem.ColumnName,Value,",")"  it will works fine only make sure that you are applying this formula in Text property and for Vertical gallery

[chaule]

I tried this but it didn't work for me. It said "invalid argument types"

[Muni]

Thanks for giving me the solution, I was struggling to get solution for couple of days.

[Billy_C]

Hi,

I know that this is an old topic, but I am having the same issue here...

So I have a gallery that displays a list of projects now for every project in that list I want to display its topic.

Which is a choice column that allows multi-select, problem is that the above functions don't work.
So when I typed "ThisItem.Topics" it says that it is a table, which is true since it holds multiple values.
When I typed "Concat(ThisItem.Topics, Value, ", ")" it says: "Invalid argument type (OptionSetValue). Expecting a Text value instead.".

Do I need to do something extra to convert the OptionSetValue to Text instead, any ideas?

Thanks in advance!

[RicardoUnzueta]

Same issue with exactly the same message like you.

Concat(ThisItem.'Software_Type',Value,";")

Invalid argument type (OptionSetValue). Expecting a Text value instead."

[RicardoUnzueta]

I got it, please try 

Concat(ThisItem.'YourColumnName', Text(Value),";")

[Billy_C]

I just found out about it too, I was a bit too late to sent it to you.
Have been trying to get it right for a while now and at first "Text(Value)" wasn't working for some reason, but in the end it was actually valid it just didn't update correctly.