user based list gets concatenated

[baba_sawane]

Dear AppSheet community,

I face an issue with my user based list : 

In a parent table, there's an EnumList table where the user can add values.

In my child table, there's an TEXT* column where the user should see the list he made and select one value.

Scheme below : 

My issue is that it shows only one value, that concatenates all the values of his list.

This is the formula I'm using to select the list : 

Select(PDC_Zones[Bâtiment],[ZoneID] = [_THISROW].[Zoneliée])

Any guess ?

[Suvrutt_Gurjar · Accepted solution]

Maybe more details regarding column structure will be required. For now, could you try the following expression

SPLIT(TEXT(SELECT(PDC_Zones[Bâtiment],[ZoneID] = [_THISROW].[Zoneliée])), ", ")

[baba_sawane]

That's ingenious, thanks ! 

As long as it works 😁