I have a Flow set up to retrieve ant items matching a filter query, then email the Key Stakeholder of that list item. The idea is that the flow sends an email to each item key stakeholder about that list item. Then updates the list item to state an email has been sent. Simple right? NO.
The Get Items part works, and the update list item works, however the send email action sends an email for each item returned to each Stakeholder resulting in several emails sent to each person. Not what I want, the idea is that the Stakeholder receives an email for the item that is assigned to them. I have tried adding a Get user Profile step in to the Apply to Each stage instead of using email Key Stakeholder (the result returned from the list), but it falls down when I try to select send email for Current Item in the Second Apply to Each step causing the flow to fail. How do I tell it to get the user for the list item, then email that user about that list item only, not the other list items returned in the get items step?
Example of Flow
