Can I make Workflow to select people without manual entry?

Question

For my workflow, I want to use the Action "Send Email" but as follows:

Column A holds the name of stakeholder Column B holds the condition (a status of task)

I want workflow to Send Email to Column A if Column B's status is "No"

What I have been doing is writing "If/Else" and manually entering multi-layered parameters as this: If Column A's value equals {Insert manually the name of a person} Then send email to {Insert manually the name of the person} Else If Column A's value equals {Insert manually name of the 2nd person} Then send email to {...2nd person} Else...

This is inefficient and I am exploring a better alternative as value of Column A can change depending on task assigned later. Thoughts?

Answer 1

I was able to answer my own question after researching different options as follows:

Step 1: Select Action "Send Email"

Step 2: click to edit the 'users' and click on the book icon of "To" field

Step 3: Choose "Workflow Lookup for a User..." and click on ADD

Step 4 and 5: From the "Lookup for Person or Group" window, choose the correct source in the source "Field from source"; in my case, the column titled "Dept. Stakeholder" Step 5: Choose "Return field as" field as 'Display Name' and click ok

End result should look like this:

The above steps created the correct algorithm engine to achieve my goal. In testing phase, I switched users for an assignment multiple times in the Column value in the Document Library. As long as the primary parameters to trigger the workflow met, SP activated the workflow and send out the email.