I want to be able to lookup information from a list on another site collection, in order to update a list item in the site running the workflow.

Example.

I have a workflow that has a username as a value in a column. I want to use that username to lookup the employee ID which is stored in a different list on a different site collection.

list A: List running the workflow that wants to populate the column "Employee ID"

List B: List that has all employees and their ID. Exists on a different site collection in the same tenant.

Can this be achieved?