Power Platform Community Forum Thread Details

Hi,

I am working on a flow that will email status results to individual managers if the route step is Employee Signature or Manager Signature. I've checked some of the other post however they are not quite the same or more complex than I need.

These are the results I am trying to produce in an email:

Manager First Name	Manager Last Name	Subject First Name	Subject Last Name	Status	Current Route Step Name
Emily	Johnson	Samantha	Adams	Signoff Stage	Manager Signature
Michael	Smith	Christopher	Evans	Signoff Stage	Manager Signature
Olivia	Brown	Lily	Moore	Signoff Stage	Employee Signature

This is the flow that was shared with me however I can't get it to work:

Step 1.png Step 2.png Step 3.png Step 4.png

When I add Send an Email action I get up to 15 emails that are all the same.

The Excel file:

Subject First Name	Subject Last Name	Subject Work Email	Subject Position	Subject Location	Subject Hire Date	Manager First Name	Manager Last Name	Current Route Step Name	Overall Performance Rating	Status
Emily	Johnson	emily.johnson@example.com	HR Manager	Home-AC (0999)	5/30/1995	Samantha	Adams	Manager Signature	2	Signoff Stage
Michael	Smith	michael.smith@example.com	Marketing Director	Home-AC (0999)	4/14/2003	Christopher	Evans	Manager Signature	3	Signoff Stage
Olivia	Brown	olivia.brown@example.com	Financial Analyst	Home-AC (0999)	4/3/2003	Lily	Moore	Employee Signature	3	Signoff Stage

Thank you for your help/

Categories:

Using flows

@Jordanna Can you show a screenshot of your full flow? In the meantime this YT tutorial might be helpful: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

Although this tutorial covers how to send a single email with multiple SP items—the concept is the same and can be applied to your flow. I believe the logic in your flow needs to be adjusted slightly.

IN THIS VIDEO:

✅ How to send multiple list items in a single email with a Power Automate Flow

✅ How to create a dynamic date range

✅ How to use the Convert Time Zone action

✅ How to use a Filter Query in the Get Items action

✅ How to count number of items in an array

✅ How to use the Select action to extract a users display name and email address

✅ How to create a unique list of email addresses

✅ How to use the Create HTML Table action

✅ How to customize the HTML Table with CSS styles

✅ How to use the Send an email (V2) action

✅ How to use the Append to String Variable action

✅ How to create a custom list of items for an email

✅ How to use the Send an email (V2) action

✅ How to display singular or plural text based on the number of items returned

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram