PowerApps Send Email - Bulk select items in gallery to send email but requires review/approval to be released by approver

[KatChi4]

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.")

[BhaskarDhone · Accepted solution]

yes you need to move to power automate.

1. Trigger of power automate will be 'PowerApps' with one parameter which will be string of emails to whom you need to send an email , may be semicolon separated string. E.g abc@x.com;zys@x.com

2. Add an approver action , 'Start and wait for an approval' send this to approver with details which you want to include.

3. Add condition which will check response of approval. If approved, the use compose to split your email addressed with semicolon. Output will be list of email address. Now add for loop , and inside the loop add send email action to send email to users. If rejected terminate the workflow.

[KatChi4]

BhaskarDhone,

I am a beginner user with PowerApps. Please bear with me as I may ask "silly" questions.

Can you share a visual of how this will look in PowerAutomate?

In last step, composing email, when approved, it is possible to group by email addresses or their unique ID to include a table as written in the formula version? The goal is to send one email to same email address in multiple rows of data, with a table.