Unanswered

Send single email with data from 'Parent List' and 'Child list' connected by a lookup column

(1) Share

Report

Posted on by NC-21080606-0

I'd like to send a single email that is comprised of data from 2 separate SharePoint lists that are connected via a lookup column. The first list contains products, and the second list contains tests performed on the products. The lists are connected by a lookup of the product name from Product list. I'm able to separate each product, but the tests that are reported are all tests, not just the ones associated with the product listed.

Example of Product List:

Example of Test List that has a Lookup column of the ProductName on the Product List

I'd like to send a single email that lists each Product and directly below each product will be a table of the associated tests. I want something like this:

I'm using Filter array and Compose in my current flow but it is sending an email with all tests in list, and not the tests associated to each product.

Categories:

General topics

All responses (2)

Answers (0)

Sort by

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Paige07

Please make sure to put in the actual Code and Expressions you are currently using. If your Get items isn't working we can't tell you why without it, or honestly anything else for that matter.

Add Pictures from a Run, as the pictures of the flow are great above for understanding that part.

For each Action, open them up and show up what the Code is its trying to run, inputs and outputs.

Especially your Selects etc and the Create HTML.

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
NC-21080606-0 18 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Mike - thank you so very much for your reply. Below are all the expressions for my flow. The flow is currently sending an email for each Product from the product list (HTML 1st Table), but the test list for each product (HTML 2nd Table) is a compilation of all tests across all products, not just the single product in the email. I want just the tests associated for that single parent product listed in each email.