Can't display values from multi choice Choices field

[ingovals]

I have a global choice named Year.

As the name suggests its Label is a Year and the value is the numeric for that Year.

so:

2018	2,018
2019	2,019
2020	2,020
etc.	etc.

In one case a Table has a field that can pick multiple Years. I'm then displaying in a DataTable and a column for displaying this field I want to display everything in a comma separated way.

• Concat(ThisItem.Years, Text(Value), ", ")
• Concat(ThisItem.Years.Value, Text(Value), ", ")
• Concat(ThisItem.Years, Text(Years.Value), ", ")

All fail with the error Name isn't valid, 'Value' isn't recognized but evaluation the field indicates that it is a single column table with the column Value. What is going on?

I tried

[jcfDaniel]

Hi,

Try this Concat( ThisItem.Years, Value, " ,")

[ingovals]

---

@jcfDaniel wrote:

Hi,

Try this Concat( ThisItem.Years, Value, " ,")

---

Name isn't valid, 'Value' isn't recognized

It's like the value column just isn't there.

[jcfDaniel]

It worked for me...

What is the datasource, the type of column/data and the name of the column?

[ingovals]

Working with this property the Autocomplete suggests the Value property, the evaluation shows a single column table with Value column.

Create a new table, items = FirstTable.Selected.Years,

Add fields, suggested Field is Value, add it,

Error, Value isn't recognized

[ingovals]

Dataverse, the column is of type Choice, multiple picks allowed as mentioned in the original post.

The name of the Column is actually Rekstrarár but I didn't include it since it isn't English, but the schema name is star_years

[jcfDaniel]

Hi,

I found this solution and it works: Display Choices(Multi-select option set)column of dataverse in Canvas App Gallery – Vblogs

Maybe there is a better one but I tried a bunch of stuff and it didn't take.

[ingovals · Accepted solution]

Ok, I resolved this, and I think I know the potential issue I had.

Concat(ThisItem.Years.Value, Text(Value), ", ")

Worked, but possibly the issue was that I had a column Named Value, which probably was conflicting.

I changed that column name and now it works.

[jcfDaniel]

It works great. Nice one.

[ingovals]

@jcfDaniel Yeah, thanks for your help.