Sharepoint List Email on submission

I have a sharepoint online list, where someone would fill it out selecting an appropriate case manager from the "people or groups" column type in Sharepoint. I then would like to have an email generated to that case manager and their supervisor automatically when the list item is submitted. I'm having trouble finding a way to automatically pull the AD manager data based on that case manager selection, and then generate an email.
Nick MartunasI.T. ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IsaacSharePoint Client Side DeveloperCommented:
Can you use SharePoint designer with SharePoint online?  You can use a SharePoint designer workflow to achieve this.  When an item is submitted, you can look for the case manger that was selected and create your generated email.
1
Nick MartunasI.T. ManagerAuthor Commented:
Is there a way to pull the manager info with a workflow also?
0
Keyboard CowboyCommented:
Not really - if you're on prem and have access to the profile - you might be able to get to the person's manager IF it's is populated in the profile - which is frequently is not.  Otherwise, you can build a separate list with all of the users and their manager and then lookup on that list - but usually those kind of lists don't get updated properly when people move around, leave, etc.
You could have the user enter their manager on a field - which is probably the most reliable.

IN a workflow - be sure to test a value to be non-blank before using in an email address - SP gets mad with null fields on emails in particular
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Keyboard CowboyCommented:
question answered
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.