cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Automation

I have a Sharepoint List - very simple. With 3 Columns, Mentor, Mentee and Subject

Canadiansal_0-1614110142219.png

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?

2 REPLIES 2
Super User
Super User

hi @Canadiansal consider the list having Person (People) | Subject (Choice) |  Type (Choice)

when a user makes an entry it's for a subject and either mentor or mentee. if mentee is chosen you can fire an email to all the people which have type mentor for that subject in the list.

 

if this is what you are looking for, we can work on it. hope it helps

 
 
Helper V
Helper V

Yes, thats exactly what I am trying to do. Haven't been on one lately, but I suspect  dating sites work on the same principles😀

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (69,071)