I have a Sharepoint List - very simple. With 3 Columns, Mentor, Mentee and Subject
Is there a way to automate the process so that when a User Selects that they are a Mentee, that an email will be sent to the Mentors ? So in this case there are 2 persons who are willing to be mentors for Accounting, and 1 person wants to be mentored (Mentee), any ideas? Is this the best way to set up my data or Should I have a Single Column with a Mentor/Mentee Choice?