cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Deseye
Frequent Visitor

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

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.

Deseye_0-1648739426743.png

 

 

 

I look forward to hearing from the community on this.

Thank you.

 

 

2 REPLIES 2
ScottShearer
Super User
Super User

@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.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Deseye
Frequent Visitor

@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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (2,210)