Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Creating a flow for multiple list items in one email

Hi All,

Many thanks in advance!!
I have two SharePoint lists:

list 1 (Parent list) has 2 items below:

 ID, Room, 
 1,  A
  2 , B
List 2 ( Children list) has 3 items
  First Name, Last Name, ContactID
  Lea, Smith, 1

  April, Paul, 1

  John, Zikta, 2

  Ger, Mude, 2

I want to create a flow :

if ID=ContactID, then like:



ID: 1

Room: A

Last Name:  Smith

First Name: Lea

Last Name:  Paul

First Name: April



I don't know how to get all names from list 2 and link to list 1,how to use array or string ? I used "Get Items" for list 2, got error message "Item Not Found".  


Multiple Items in one email_Nov24_2020.png


Hi @Linda777 


Please note that this forum topic is related to Power Automate Desktop. Since you are building an API flow, I suggest that you post your question here

to get a response faster 🙂


I did. thanks,

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,293)