Lookup of single text type returns array

im having a table of locations that which record has location name( which is a single text type) and other parameters.
im having a columnn in another table which is a Look Up for the location’s name. The records in this column are arrays,even if records contain only single location name.
How can i change the type of the lookup column to be only single text and not returning the location name as a list/array?

The easiest way to do this would be to create another field that is a formula to coerce the “Location” into a string:

{Location Lookup Field} & ""

By pulling in the looked up “location” array, and then concatenating it with an empty string, it will coerce that array into becoming a string. Then you can reference that formula field from any other fields or API’s that you need to work with strings.

1 Like