How to append a column value to a group header

Question

I have a list grouped by Name and I'd like to append their job title to the header. The Job Title column exists in the list and it is a lookup field.

So it would look like this:

John Smith - General Manager
[row]
[row]

Jane Brown - Executive Chef
[row]
[row]

Answer 1

You cannot use Lookup field as you mentioned. Unfortunately you are not able to use calculated fields too.

Solution can be:

1. Create another text field "Name and Job"
2. Create Flow starting o new/edited list item and fill "Name and Job" text field with text values from Name and Lookup Job fields as you wish to display them.
3. New "Name and Job" field select in view for grouping.

Hope it helps!

Mark answer as accepted solution, if it works.