TextColumn with nested relationships - How to display unique values?

Hi everyone!

I'm working with a TextColumn that displays data from a nested relationship (MorphMany → BelongsToMany), and I need to show unique user names.

My setup:
-

P2pStaffProcessInstance

P2pStaffProcessInstance

has

organizationalActivities()

organizationalActivities()

(MorphMany)
-

P2pProcessActivity

P2pProcessActivity

has

users()

users()

(BelongsToMany)

Current code:

TextColumn::make('organizationalActivities.users.name')
    ->label('Consultants'),
php

TextColumn::make('organizationalActivities.users.name')
    ->label('Consultants'),
php

This displays all user names separated by commas, but the same user can appear multiple times if they're assigned to different activities.
What I need:
Display unique user names (no duplicates) in the column.
What I've tried:

->formatStateUsing(function ($record) {
    return $record->organizationalActivities
        ->pluck('users')
        ->flatten()
        ->unique('id')
        ->pluck('name')
        ->join(', ');
})
php

->formatStateUsing(function ($record) {
    return $record->organizationalActivities
        ->pluck('users')
        ->flatten()
        ->unique('id')
        ->pluck('name')
        ->join(', ');
})
php

But it still shows duplicate names. Any suggestions on the best way to handle this?
Thanks!

Solution

fix with:
TextColumn::make('organizationalActivities.users.name')
->distinctList()
->searchable()
->sortable()