I have a ordering app that places orders in a SharePoint list.
A order might have more than one item and each item would have the order number populated in the SharePoint list.
I want to set up a flow that will group all new orders and only send one email containing the details of all items with the same order number.
Currently it send an email for each item that is created in the SharePoint list.
So I basically want it to:
-check if a new item is created in the list
-check the order number
-if the order number doesn't exist, it's the first item for that order
-but if it does exist, add it to the group.
Only on the last item must the system send the email notification with all items added details.
Hope it makes sense
How can I do this using power automate
