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 / Get items by ID and pu...
Power Automate
Unanswered

Get items by ID and put them into a mail

(0) ShareShare
ReportReport
Posted on by 2

Hi all,

 

I have a Flow that runs when a new Order is created in a SharePoint list. In another SharePoint list are the ordered items of the order, referenced by ID:

Order List:

ID      Name

15      Person1

 

OrderedItems List

ID       Item        OrderID

1         Item1         15

2         Item2         15

I would like to send out a confirmation e-maiil to the orderer with his ordered items.

 

I am really stuck here. Can anyone support?

Categories:
I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @Frankie701 You can use Get Items action to get items from OrderedItems List, in filter query of get items you can apply query as e.g. OrderID = 15

     

    When do you want to send email when new item is added to Order list?

  • efialttes Profile Picture
    14,756 on at

    Hi!

    For sure your challenge can be solved. JUst one question related to IrderedItems List. Is its OrderID field of type Lookup? Number? Text?

    Thanx!

  • Frankie701 Profile Picture
    2 on at

    Hi @efialttes ,

    thanks for asking. It is of type Text.

  • efialttes Profile Picture
    14,756 on at

    @Frankie701 wrote:

    Hi @efialttes ,

    thanks for asking. It is of type Text.


    No problema. @annajhaveri 's suggestion is a the best approach, sorry I didn't realize she answered first.

    In case you are not familiar with ODATA filters, you can also filter the OrderedItems List 'Get items' result by means of a 'Filter array' action block, just assign 'Get items' output as 'Filter array' input and configure the condition rule accordingly. 'Create HTML table' action block should do the trick and convert the filtered results into a simple HTML table you can insert in the body of your email

    Give it a try, and let us know your progress

     

     

  • Frankie70 Profile Picture
    384 on at

    Hi @annajhaveri

    I would like to send an e-amil when a new item is created in the Order List.

    Such as:

    Hi Person1,

     

    you just ordered:

     

    Item1

    Item2

    Total price: xxx EUR

     

    There will be some more columns for the items (such as amount and price)

    And finally the total sum (price) of all items.

    Thanks for supporting me!

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @Frankie70  you can configure the flow as follows:

     

    1. Use "When an item is created" trigger for the flow and add Get Items action and configure it as below screenshot

    annajhaveri_0-1615385945137.png

     

    2. Then add Create HTML table action to prepare list of order items to be send in email and configure it as follows:

    annajhaveri_1-1615386208592.png

    In the From property select from Dynamic content -> Value (list of items)

    in columns select custom option from dropdown and provide the column headers and column values which you want to include in email like Item Title, Price, etc

     

    3. Now add Send Email action, select output of create html table from dynamic content in the body of email.

    annajhaveri_3-1615386337106.png

     

     

     

  • efialttes Profile Picture
    14,756 on at

    @Frankie701
    did you solve the issue? If so, remember to mark @annajhaveri response as Solution

    Thanx for making this community great!

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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard