Hi,
I am currently trying to create an email workflow where once an item is logged on a list, it will then look for the persons name it has been logged for in another list. This other list has that persons managers email, which is who I’m trying to get the workflow to send the email to. Â
Can anyone help?
Thanks,
Annie
It does make difference as Beau states above as to if you are working with Workflows in SharePoint designer or Flow. The other question is why aren’t you using the user’s profile information rather than a list?
In SharePoint designer workflow I would add the action Set Workflow Variable. Then clicking on Value and then fx button, change the Data Source to the list you want to search and fill in the details of the Workflow Lookup.
If its a flow I would use Get Items and specify the list details, click the advanced settings and add an Odata filter in to use as your search.