web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Email mutilple items f...
Power Automate
Unanswered

Email mutilple items from GroupBy View

(0) ShareShare
ReportReport
Posted on by 901

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!

Categories:
I have the same question (0)
  • Gristy Profile Picture
    2,429 on at

    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.

  • v-litu-msft Profile Picture
    on at

    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.

  • oappdev Profile Picture
    901 on at

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

     

    This is my Flow

    Workflow.PNG

    WorkflowPart2.PNG

     

     

     

     

     

     

     

     

    Thank you in advance

  • oappdev Profile Picture
    901 on at

    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

  • v-litu-msft Profile Picture
    on at

    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 Profile Picture
    901 on at

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

  • DanyElHoyek Profile Picture
    91 on at

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard