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?
