How to send one Power Automate email when multiple items are created in SharePoint online

Nozipho Chiliza 21 Reputation points


Please help.

I developed a shopping cart using PowerApps and the SharePoint Online as a container for these items.

I then created a Power Automate workflow for notification to the created by.

The issue is that, when multiple items get submitted, multiple emails get generated for each item and that is not what I want.

How can I add all the created items to one email?


SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
479 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Yi Lu_MSFT 17,366 Reputation points

    Hi @Nozipho Chiliza

    If we want to run the flow automatically, the trigger could only be "when an item is created or modified", there is no such function to run a flow after multiple items are created.

    In this situation, you could only run the flow manually after multiple items are created. Use "Get items" action to get the new created items, then add the value to your mail.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.