Send mail to multiple user when an item is created and with particular column grouping.

[Deseye]

I have a sharepoint list that i used as a dataSource to a PowerApp Application. 

When a user names a request on the App, they can make multiple request at the same time.

I have a RequestID - the default ID generated in Sharepoint. and i have a CartID, which i use to track the grouping ( to group requests per person, per time ).

I could just send a notification,  When item is created, but that will mean sending multiple notification for each item, from a single request. when a single person make over 5 request at a time. That wont be nice.

That is why i created the CartID to track each request group.

Now, I am stuck on how to send a single Mail, when request is made. that is, sending Mail when a new CartID is created, just 1 single mail all request made at a time.

I look forward to hearing from the community on this.

Thank you.

[ScottShearer]

@Deseye 

I suggest creating a Flow that is called from Power Apps when the order is complete - all items have been added, etc...

The Flow would take the cart ID as a parameter.  Then, the Flow would execute a Get items action with a filter query so that only items with a specified cart ID are returned.  You could create an HTML table from the Output and send an email at that time which includes the HTML table.

[Deseye]

@ScottShearer Thank you very much for the insight. I have tried as you suggested and it worked.

However, my setback with this is that I will be unable to use

1. "Send mail from shared Mailbox unless the App user is granted ability to send from Shared Mailbox, because if the Power App trigger ( Which i don't understand why that is). 

2. It will require I share ownership of the Power App triggered Flow with the App User too.

All of this is why I am trying to avoid using flows that are Power App triggered.

Please advice or clarify if my points stated above are wrong.

Thank you.