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?
Solved! Go to Solution.
hi @Canadiansal
I build a collection called mentorship to keep all entries, for both mentors and mentees.
ClearCollect(Mentorship,{Subject:"",Role:"",Applicant:""})
I added three dropdows
I added a button that saves the entries and when the roles are a mentee it emails everyone that is a mentor for that subject
Entry button onselect =
Patch(Mentorship,Defaults(Mentorship),{Subject: Dropdown1.SelectedText.Value ,Role: Dropdown1_1.SelectedText.Value,Applicant:Dropdown1_2.SelectedText.Value});
If(Dropdown1_1.SelectedText.Value = "Mentee",
ForAll(Mentorship, If(And(Role = "Mentor", Subject = Dropdown1.SelectedText.Value),Collect(_Email,Applicant & "@someplace.com"))))
below i added three mentors as can be seen in the gallery (item = mentorship) and below that is the email that will be send when i selected the mentee. notice that Lisa is not being emailed
Gallery1 Item = Mentorship
Gallery2 Item = _Email
Jope this helps
hi @Canadiansal you can replace the Collect in If(Dropdown1_1.SelectedText.Value = "Mentee",
ForAll(Mentorship, If(And(Role = "Mentor", Subject = Dropdown1.SelectedText.Value),Office365Outlook.SendEmailV2("emailaddress@some.com","Subject","Message here"))))
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
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😀
Did you say you have some insights into this?
hi @Canadiansal sure we can do this, i have to jump onto something else quick and can get to this in an hours' time
hi @Canadiansal
I build a collection called mentorship to keep all entries, for both mentors and mentees.
ClearCollect(Mentorship,{Subject:"",Role:"",Applicant:""})
I added three dropdows
I added a button that saves the entries and when the roles are a mentee it emails everyone that is a mentor for that subject
Entry button onselect =
Patch(Mentorship,Defaults(Mentorship),{Subject: Dropdown1.SelectedText.Value ,Role: Dropdown1_1.SelectedText.Value,Applicant:Dropdown1_2.SelectedText.Value});
If(Dropdown1_1.SelectedText.Value = "Mentee",
ForAll(Mentorship, If(And(Role = "Mentor", Subject = Dropdown1.SelectedText.Value),Collect(_Email,Applicant & "@someplace.com"))))
below i added three mentors as can be seen in the gallery (item = mentorship) and below that is the email that will be send when i selected the mentee. notice that Lisa is not being emailed
Gallery1 Item = Mentorship
Gallery2 Item = _Email
Jope this helps
Thank you - this is great. What would be the syntax of the email command? Can we do this using powerautomate as well?
hi @Canadiansal you can replace the Collect in If(Dropdown1_1.SelectedText.Value = "Mentee",
ForAll(Mentorship, If(And(Role = "Mentor", Subject = Dropdown1.SelectedText.Value),Office365Outlook.SendEmailV2("emailaddress@some.com","Subject","Message here"))))
User | Count |
---|---|
165 | |
90 | |
72 | |
64 | |
62 |
User | Count |
---|---|
211 | |
153 | |
96 | |
87 | |
66 |