I have a workflow running that looks at a Resource List A. When new starters arrive it sends the email which includes a Location field which is a lookup from List B. Within List A i also display Country and Region that are also pulled in from List B via the main link/lookup field Location.
I would like to also include the country field from List B in the email, but it doesn't appear as a field. Any ideas how i can include this without creating it as another direct lookup? Thanks