I am new to Power Apps . I am developing a Power Apps integrated with the PowerBI. In the Power Apps I have to provide checkbox selection to the manager and after selecting the records through the checkbox I need to send the email individually to the user mark as developer and tester with the line item containing details of their task.
I am storing the data in Collection with "Oncheck" functionality of checkbox coded as below
Collect(TASKCOLL,{taskid : ThisItem.Task_ID,TaskName:ThisItem.'Task_Name',Description:ThisItem.'Task_',Developer : "abc",Tester : "xyz",ChkValue:1})
I need to send email to all the developers and testers with HTML table containing task which is assign to them.
I am using FORALL function to send the email but it is sending email to all the developers and testers that are selected in collection also table is having all the collection data.
How to send email to each developer and tester and table which contain data about their task.
"" ForAll(TASKCOLL,Office365Outlook.SendEmailV2(Concat(TASKCOLL,Developer & "@abc.com"&";"&Tester & "@abc.com",";"),
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=768 style='width:575.75pt;margin-left:-.15pt;border-collapse:collapse'>
<tr style='height:15.25pt'>
<td width=324 style='width:243.0pt;border:solid windowtext 1.0pt;background:#7030A0;padding:0in 5.4pt 0in 5.4pt;height:15.25pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='color:white'>Task ID<o:p></o:p></span></b></p></td>
<td width=324 style='width:243.0pt;border:solid windowtext 1.0pt;border-left:none;background:#7030A0;padding:0in 5.4pt 0in 5.4pt;height:15.25pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='color:white'>Task Name<o:p></o:p></span></b></p></td>
<td width=324 style='width:243.0pt;border:solid windowtext 1.0pt;border-left:none;background:#7030A0;padding:0in 5.4pt 0in 5.4pt;height:15.25pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='color:white'>Task Description<o:p></o:p></span></b></p></td>
</tr>" &
Concat(
TASKCOLL,
"<tr style='height:15.0pt'>
<td width=324 nowrap valign=bottom style='width:243.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'><p class=MsoNormal align=center style='text-align:center'>"&taskid&"<o:p></o:p></p></td>
<td width=324 nowrap valign=bottom style='width:243.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'><p class=MsoNormal align=center style='text-align:center'>"&TaskName&"<o:p></o:p></p></td>
<td width=324 nowrap valign=bottom style='width:243.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt'><p class=MsoNormal align=center style='text-align:center'>"&Description&"<o:p></o:p></p></td>
</tr>"
) &
"</Table>
"
)) ""


Report
All responses (
Answers (