cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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
Highlighted
Super User II
Super User II

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.

Highlighted
Community Support
Community Support

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
Post Patron
Post Patron

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

Highlighted
Post Patron
Post Patron

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

Highlighted
Community Support
Community Support

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.

Highlighted
Post Patron
Post Patron

Re: Email mutilple items from GroupBy View

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

Highlighted
Advocate III
Advocate III

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
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Users online (3,939)