Hi @moerah,
The collection displays this field as a record since a SharePoint choice column (single-select) has the following structure:
//Record with 1 column called value, containing a text value
{
Value: string
}
Should you want to display the Text value of that choice, you could use the following ClearCollect:
//Saves a collection with 1 column named 'Value'
ClearCollect(
colAllValues,
ForAll(
NWAllocation,
//Should AllecatedTo be written with a space in SP use 'Allocated To'.Value
AllocatedTo.Value
)
)
Please note that displaying the value as text is not required to count certain choice occurrences:
//The code below assumes your current clearcollect code (record type)
//Example: only count the choices with value 'abc'
CountIf(
colAllValues,
AllocatedTo.Value = "abc"
)
If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
