I am building a pair of lists, workflows and forms for onboarding and offboarding.
I have a column in the offboarding list that is a lookup of the employee's name from the onboarding list, and when selected in the offboarding form, brings along additional fields like job title, manager's name, etc. I am trying to use the Query List action to grab those lookup values that are brought along with the employee's name, but they are not available as columns to select in the Query List action. Is there a different way to do this, or a workaround?
Thanks in advance.