Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Send email with field data from other SP list

I am new to Automate.  I have a SP list called "HostSearch" which bring two other lists together.  "Hosts" and "Group".  I am making an email with options flow to send an invitation to each host using "HostSearch" as my List Name in the "Get list"  action in the flow with a Accept or Decline option.  In the body of the email I wish to reference fields from both child lists.  


Is there a way to access those fields using a lookup in flows or will I need to go back to my SP list "HostSearch" and create lookup fields for the information I am wanting to get from the Host and Group lists?


Hope this makes sense and look forward to a reply.

Community Support
Community Support

Hi @StuCundy 


If the data is only stored on the child lists, you for sure will need to query directly to those lists, but as you indicate it is better to modify the HostSearch list and include there the lookups, so when you use the Get List action, you will retrieve all the needed information since the beginning.


Best Regards,


If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution

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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,380)