Displaying choice fields in a datatable as part of a collection

[lvdp]

I have a Sharepoint List with a choice field for Item status

I created a collection from the SP list called "MyCollection" and the choice field shows [order Order] when I display it in a Data Table

I need the collection so I can create a second collection and use AddColumns to format the dates correctly for Australia, but I don't know how to get the choice list options to display correctly.
I can't use a gallery as the real list I need this to work on has > 2000 items.

My Code on the Format button looks like this:

ClearCollect(MyCollection, 'Custom List');
ClearCollect(MyFormattedCollection,
AddColumns(MyCollection,
"CreatedAU", Text(Created, "[$-en-US]dd/mm/yyyy")
)
)

What do you need to do to fix the display of the Item Status column in the collection?

[aprildunnam · Accepted solution]

I've ran into this same problem.  I addressed it by created another column to hold the value of your choice field.  So for example:

ClearCollect(MyCollection, 'Custom List');
ClearCollect(MyFormattedCollection,
AddColumns(MyCollection,"ItemStatusFormatted",ItemStatus.Value,
"CreatedAU", Text(Created, "[$-en-US]dd/mm/yyyy")
)
)

The key is getting the column name and appending ".Value" to it to get the value of the choice column.

[lvdp]

Thank-you so much - fixed my issue!  I was stuck on the syntax for adding choice list values.

The only tip I'd give others is that you should generate your collection with the new columns and THEN add the data table based on the collection so you can select the newly generated columns for display!