Fetch a data from a specific field in an entity and return it as a list for a drop down field

Help Apps
,
1

Hi Everyone,

Please I have been having a little struggle with this . I am trying to fetch a data from a specific field in an entity and return it as a list for a drop down field. I have an entity with a field LocationName

The image shows a data interface labeled "SandataExceptionLocationNames" with a search bar and a list of location names, some of which are redacted. (Captioned by AI)
The image shows a data interface labeled "SandataExceptionLocationNames" with a search bar and a list of location names, some of which are redacted. (Captioned by AI)526×592 18.3 KB
.

my code below but doesnt work.

AppsDataSource.from(Fetch(of OfficesForSandataException)(Nothing, Nothing, Nothing, Nothing, New ExpansionFieldOption(){addExpansionFieldOption("CreatedBy", New String(){"Id","Name"}), addExpansionFieldOption("UpdatedBy", New String(){"Id","Name"})}).data.Select(Function(x)x.LocationName))

my drop down appears blank

The image shows a user interface element with a dropdown menu that includes a checkbox option. (Captioned by AI)
The image shows a user interface element with a dropdown menu that includes a checkbox option. (Captioned by AI)410×338 5.08 KB