Updating user status promote information from other tables

We have user integration that sync daily users from our HR system with the status, hire date, termination date and job title.
We need to trigger action when job title change happens:

  1. Table A: if the person has been listed as a responsible person we need to review that with new job title still can be responsible for that
  2. Table B: the person with changed job title has certain permission level for certain application and we need to review if this could stay or be changed

When triggering workflow it allows me to pick the initial table User as the source but I’d like to filter on current username in Table A and B (and maybe even more) and provide some additional output to review the user assignment.

Maybe it will be enough if I can use username from the trigger above as filter in the table…