Choices from single line of text from SharePoint?

[dlprentice]

Hi,

I'm trying to use the Choices() function to pull unique choices from a SP list column. The column has unique single line of text values.

I tried Choices('ESN Ticket Tracker'.Status), but this results in an error. "Invalid Arguments".

Any help is appreciated. 

[zmansuri]

Item Property of DropDown or ComboBox:

Distinct('ESN Ticket Tracker',Status).Result

[dlprentice]

This works, but my list is 4000+ items so not every unique status comes through 😞

[zmansuri · Accepted solution]

You will need to create a collection of those 4000+ records on OnStart property of the app. Then use the same formula i gave you on that collection. Because Distinct is not delegable function and it will only work if you have less than 2000 records