Seeking guidance on best approach to send bulk emails that requires review/approval before emails are released.
I have a "Send Email" button in my app with the below OnSelect formula.
I select multiple items in my gallery, the formula groups by email addresses, includes a table in body for item values in gallery based on grouping, and sends email(s).
It is now required to have these emails sent to a reviewer/approver for them to release them.
If I have to move this to PowerAutomate, what are the steps/screens required to replicate below but adding the approval requirement before release?
If I can keep it in PowerApps, what needs to be added to the formula to include that prior step of send to approver, upon approval, email is released.
Thanks in advance.
ClearCollect(colGrpClient,GroupBy(colClient,ContactID,GroupedItems)); ForAll(
colGrpClient,
Office365Outlook.SendEmailV2(
ClientEmail, // Use the email address of the current group
"Action Requested: Confirm Bookings today before 8p EST",
"Hello Team,<br><br>Please log-in to BookSuite to review and confirm the below before EOD today 8p EST. <br><br>" &
"<table border='1' cellpadding='5' style='border-collapse: collapse; border: 1px solid black;'>" &
"<tr style='background-color: lightgrey;'><th>Control ID</th><th>Book Ref</th><th>Dept</th><th>Acct</th><th>Date</th></tr>" &
Concat(
GroupedItems, // Use the current group of items
"<tr>" &
"<td style='border: 1px solid black;'>" & 'Control ID' & "</td>" &
"<td style='border: 1px solid black;'>" & BookRef & "</td>" &
"<td style='border: 1px solid black;'>" & Dept & "</td>" &
"<td style='border: 1px solid black;'>" & Acct & "</td>" &
"<td style='border: 1px solid black;'>" & Date & "</td>" &
"</tr>"
) &
"</table><br>Feel free to contact us directly with any questions or concerns. <br><br>Kind Regards,<br><br>Ops Team<br>ACME Inc.<br>US Booking Operations<br>Contact: +44 20 9999 9999<br>Group Email: us-bookings@acme.com<br>1st Escalation: Peter Pan peter.pan@acme.com<br>2nd Escalation: Teq Uila teq.uila@acme.com"
); ForAll(
GroupedItems,
Patch(
'ABC Books',
LookUp('ABC Books', ID = GroupedItems[@ID]),
{
LastNotificationSent: Now(),
NotificationCount: If(IsBlank(NotificationCount), 1, NotificationCount + 1),
BookingStatus: { Value: "Contacted" }
}
)
)
);
Clear(colClient);
Clear(colGrpClient);
ClearCollect(
myBooks,
'ABC Books'
);
Refresh('ABC Books');
Reset(chkAll);
Notify("Email(s) have been sent.") |
