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.
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?