Answered

Feed a group of users to a Power Automate flow

(1) Share

Report

Posted on by Vamlack

Hello everyone!

I'm currently making a power Automate flow that automatically sends an email to a teacher when a student tries to change something on a sharepoint list.

The following function is working:

Approval.Run(User().Email; "teacher email")
// The contents are: Approval.Run( Sender; receiver), I've removed the other informations for clarity

However as you can see the theacher email is hardcoded and I would like it to be dynamic.

The students are stored in a sharepoint list called Students, one of its column is called "TeachersProfils" and contains the Office365 profiles of every teachers that are linked to a specific student.

I would like the mail to be sent to every teachers of the student who clicks the button. Unfortunately I truly have no idea where to start despite my research.

Does anyone have a hint on where to start or what to use?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Vamlack ,

Based on the values you have posted (you will need to adjust one field name here)

Concat( LookUp( Students, YourStudentEmailField = User().Email ).TeacherProfiles, Email, ";" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Vamlack 43 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello! Thanks a lot this was really helpful!
Here is a revised version of the code that works completely for me:
Concat( LookUp( Students, User().Email in YourStudentEmailField // this is what I changed ).TeacherProfiles, Email, ";" )

Thanks again and happy new year!