cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate V
Advocate V

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
Resident Rockstar
Resident Rockstar

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
Community Support

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.

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

 

This is my Flow

Workflow.PNG

WorkflowPart2.PNG

 

 

 

 

 

 

 

 

Thank you in advance

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

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.

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

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (7,315)