Access Microsoft Organization to Add Emails

[hsparg008]

I'm trying to send an email notification when a new SharePoint list item is added. In the SharePoint list, there's a section for whether or not the email notification should include the lead engineer's manager and director.

If this is selected "yes," I want to be able to access the engineer's manager and director through the organization that pops up when you hover over a contact. Is there a way to do this?

I attached a screenshot to show the contacts I want to grab.

[hsparg008 · Accepted solution]

I figured out how to accomplish this and wanted to add in case someone looks in the future. There's a "get manager" option you can select:

In this function, enter in the user's email. I entered in the Lead Engineer's email since this is the manager I wanted. This will retrieve that user's manager.

To get the director (the manager's manager), I did the same thing, but this time pulled in the "mail" from the previous function. 

To decide whether or not to send, I created two variables and initialized them with a blank email "noreply@noemail.com"

Then, there are two parallel conditional statements. If the user selected that they wanted to contact the manager or director, the box in the SharePoint list will have a checkmark, or not be blank. Therefore, if the entry isn't blank, the email will be changed to the pre-defined manager or director's email.

Finally, in the email the manager and director are always cc'ed; however, if they're not filled in, it will be sent to a blank email (noreply@noemail.com).