cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oappdev
Level 8

Email mutilple items from GroupBy View

Trying to figure out the best approach to send a email every-time the users place an order with multiple items in a GroupBy View

 

Is it possible? For every new order containing multiples items.

Workflow.PNG

 

Thank you in advance. Always Learning!

7 REPLIES 7
Super User
Super User

Re: Email mutilple items from GroupBy View

Hi,

 

Flow can be triggered each time an item is created.

 

Group by is just a representation of the data in a SharePoint list.

 

You would need to run a flow each time an item is created and do some queries yourself using get items to see if multiple items exist with the same criteria you are after.

Community Support Team
Community Support Team

Re: Email mutilple items from GroupBy View

Hi @oappdev,

 

Under what conditions do you want the Flow to be triggered?

If you want to trigger it when a new item created, You can use the Odata Filter query in Get items action to find these items which have the same requestor name, for example:Annotation 2020-01-13 134829.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
oappdev
Level 8

Re: Email mutilple items from GroupBy View

@v-litu-msft @Gristy Thank you for the response

 

This is my Flow

Workflow.PNG

WorkflowPart2.PNG

 

 

 

 

 

 

 

 

Thank you in advance

oappdev
Level 8

Re: Email mutilple items from GroupBy View

Well the good news the flow run successfully from what @v-litu-msft  explain to me

Success.PNG

 

Still getting separate email per each Item submitted by user.

Order.PNG

 

Example if a user submit an order with 3 Items i will receive 3 separate email.

 

 

EmailOrder.PNG

 

Need to figure out what @Gristy explain 

 

Thank you in advance

Community Support Team
Community Support Team

Re: Email mutilple items from GroupBy View

Hi @oappdev,

 

You can create a delay action after the trigger, such as 5 minutes. Then get items to get lasted created item, if the lasted item create time is less than 5 minutes, not send the email, or send an email.

If a number of items created by a user, it will make sure just one email sent, but it will have 5 minutes delay.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

oappdev
Level 8

Re: Email mutilple items from GroupBy View

@v-litu-msft  Will give it a try and circle back. Thank you in advance

DanyElHoyek
Level: Powered On

Re: Email mutilple items from GroupBy View

You can have a yes/no field in your list something like "Is Emailed", then before you send the email check the value of this fields, and after you send the email you can update this field to yes. 

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (8,663)