
I am attempting to set up a flow that will send an email notification from a custom entity to an identified recipient that includes details from that record. I can see how I can include dynamic content in my email from that originating record and I found this resource here, which shows that I can reach data from parent records. However, my dilemma is that I need to include data from child records. Is that possible?
I am also familiar with the Dynamics Marketing application where data from child records can be pulled into a Marketing Email using #each logic as described here. After some thorough testing, I don't think using marketing emails and customer journeys will work for my scenario, which is why I am now turning to Power Automate but am still running into this obstacle.
You can use the 'List Records' CDS connector to get the child records and return the data you want. Then, depending on what you need you can add an HTML table.