Hello,
i have created a leave request tool in Powerapps canvas, there i need one more feature.
if the manager accepts a leave request Information should be sent to a List of contacts.
I have one Sharepoint list to collect the leave request data and one Sharepoint-List with 3 Columns to get the connection between Employee and his Manager:
-Employee (Person/Group Field - single Value)
-Manager (Person/Group Field - single Value)
-Mail-Distribution (Person/Group Field - multiple Values)
I use the SendMailV2 with Lookup function (to get Mail Adress from dedicated Manager) to send a notification mail that there is a new leave request to dedicated Manager wich works perfect.
If manager Approves the leave request i want send confirmation to Employee + a group of contacts in CC - that's were i struggle,
I could imagine its required to create a collection from the Mail-Distribution Field and use Lookup on each row of the collection to geht e-mail adresses, and afterwards use concat() in SendmailV2 to feed the information into {CC: }
maybe some 1 could help me with that, i tried different things but im not able to get it running.
thanks
Thomas
