This has been working well for quite some time. Suddenly, I have one (new) manager where it fails to look them up. Any suggestions as to where I begin troubleshooting?
Using a set field value, equals "user profiles", source "account name - email address when account name equals workflow data variable that is the manager's email address. We use a SQL query to populate the variable from our HR org chart system.
See photo for the detail.
The manager's profile does indeed exist in Sharepoint and it contains the correct email address. Works for every other manager...