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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Receipt Flow Involving...
Power Automate
Unanswered

Receipt Flow Involving Multiple Items

(1) ShareShare
ReportReport
Posted on by 83

I have an app that exports a cart to a SharePoint list on submit. I am working on a receipt but I am having difficulty generating a single email. My current flow either sends multiple emails and/or fails because my Update Item conflicted with multiple concurrent changes. The app creates and populates an order number. The flow:

 

When an item is created

Delay: 5 minutes

Get Items: Where Order #=Order # of the item created

Condition: Title = Receipted

          If true: do nothing

          If false:

                  Create HTML Table:

                  Update Item (For Each): Title = "Receipted"

                  Send Email

 

Is there a better approach to this? I've tried writing a flow from inside of the app so it would be triggered by the order submission instead of the creation of an item but I was struggling to make that work on my button on select. My button on select wouldn't recognize the Office365Outlook connector, so I cannot use

Office365Outlook.SendEmailV2. 
 

I am posting separately on the Power Apps forum for this as well.

 

Can someone please advise? Thanks!

                

 

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,508 Moderator on at

    @ayattaw You might be interested in these YT Tutorials linked below. If you still run into issues with your flow, upload a screenshot of where you are stuck. Ensure that you have toggled off the New Designer and have clicked to expand all actions.

     

    Fix Infinite Loops: 3 Ways to Avoid an Infinite Loop in Power Automate

     

    In this Power Automate Tutorial I’m going to show you 3 ways to avoid an infinite loop. Keep in mind that there are more ways to avoid the infinite loop than what I’ll cover in this tutorial—choose the solution that works best for you. 

     

    IN THIS VIDEO:

    Understanding What Causes Infinite Loops

    Avoiding Infinite Loops with the Recurrence Trigger

    Filtering to Return Files Only in Power Automate

    How to Output a Total Count in Power Automate with the length() function

    Using Trigger Conditions to Prevent Flow Re-triggering

    Leveraging Service Accounts to Avoid Infinite Loops

     

    ---

     

    How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

     

    Building a Power Automate flow that will send an email with multiple SharePoint items can be a bit complex. In this video tutorial I’ll cover how to build a flow that will send a single email to each user with tasks that have been assigned to them. The logic in this flow can be applied to many different scenarios.

     

    First, I’ll show you how to use a Filter Query to return items from your SharePoint list that meet your criteria. Then I’ll show you how to return a list of unique email addresses so that each user receives a single email. Lastly I’ll show you how to compose an email that will contain an HTML table with a list of tasks for each user.

     

    IN THIS VIDEO:

     How to send multiple list items in a single email with a Power Automate Flow

     How to create a dynamic date range

     How to use the Convert Time Zone action

     How to use a Filter Query in the Get Items action

    How to count number of items in an array

     How to use the Select action to extract a users display name and email address

     How to create a unique list of email addresses

     How to use the Create HTML Table action

     How to customize the HTML Table with CSS styles

    How to use the Send an email (V2) action

    How to use the Append to String Variable action

    How to create a custom list of items for an email

    How to use the Send an email (V2) action

    How to display singular or plural text based on the number of items returned

     

    ----

     

    How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate

     

    In this Microsoft Power Automate tutorial I’ll cover how to create a flow that is triggered by selecting an item. This automation will send an email to all assigned users for the selected task. I’ll also show you how to adjust your flow so that you can send a message in Teams. Then I’ll show you how to collect a list of unique users that have been assigned to multi-person tasks. Using this concept, we’ll edit the flow from the previous tutorial so that it works with a multi-person column.

     

    IN THIS VIDEO:

      How to trigger a flow from a selected file

      How the multi-person column data outputs

      How to use the Select action to get all assigned to users of a SharePoint item

      How to use the Join action to convert an array of email addresses into a string

      How to send a single email to all assigned to users of a SharePoint item

      How to send an email to each assigned to user of a SharePoint item

      How to send a Teams message to each user assigned to a SharePoint item

      How to return a list of unique users from the multi-person column in a SharePoint list

      How to use a Filter Array action to return all SharePoint list items assigned to each user

      How to group Power Automate actions together with the Scope action

      How to edit a previous flow

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
  • Michael E. Gernaey Profile Picture
    53,969 Moderator on at

    Hi @ayattaw 

     

    Did you by chance go to your Data Tab in the App, and select Add DataSource and add the Office365Outlook connector?

     

    Also in your code, (which is just words.. Come on @ayattaw  hehehehe i know you can do better. share the code)

    My guess is you have the Send Email inside your Apply to each

     

    You should have an Array in your apply to each that captures all the line items you want in the email.

    Then outside the Apply to Each, do a Create HTML and put the outputs of that Array

    Then do the send email


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • CU12092006-0 Profile Picture
    83 on at

    Flow SS.PNG

    Is this sufficient? Please let me know if it is not legible or you need more info.  I left the email outside of the apply to each, my intention was that the delay would give time for the system to update the items so I didn't get the conflicting updates issue but to be honest, I think this setup is just too prone to error for my comfort. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard