Merge two or more columns after using the search option

Good day,

Please, I would appreciate if anyone can point me to how to achieve this requirement.

Using the Search option, I can include a constraint to get the list of objects but then, I want to display 2 columns of the list returned as 1 object.
For instance, I get a list of users and want to display - Surname and Firstname as one data. Unfortunately, what I have returned in the list gives me eachitem’s firstname, eachitems surname, e.t.c. Trying to put them together gives me a list of firstnames and then a list of surnames.
But what I want is a list of firstname surname each.

Any idea please?

@J805
Please, help review and advise. Thanks for your help.

Use the :Format as Text operator on the list of Users.

Set the ‘Content to show per list item’ to This User’s first name This User’s Surname, and put whatever you want to use as a delimiter.

2 Likes

Hey @yadeogun :wave:

What @adamhholmes advised is the way to do that. :raised_hands:

@adamhholmes @J805

Thanks so much. It worked perfectly. That’s a new learning that would help in some other aspects. Appreciated.

1 Like

it worked! thank you