
Closed
Posted
Paid on delivery
I need a power automate flow which lists rows present in table, pulls unique values for manager and manager email, and then groups data to send staff names in one email
Project ID: 40547192
37 proposals
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
37 freelancers are bidding on average $32 AUD for this job

Hi, I’m Sahanaj. This is a straightforward Power Automate flow and I’ve built similar ones for HR and approval processes. I can create a flow that reads the table, extracts unique managers and email addresses, groups staff under each manager, and sends a single formatted email per manager with their team's details. I’ll also make the flow easy to maintain and document the logic for future updates. Budget: AUD 75 to 120 Timeline: A few hours, completed within 1 day. Happy to get this done today if needed.
$120 AUD in 1 day
6.1
6.1

I can create excel based automated tool which process the data and automatically sends required emails to staff with relevant data. I am an Excel & VBA Automation Expert with an MBA and 10+ years of experience delivering smart solutions to global clients (eg. Decathlon, E&Y, Schindler). I’ve successfully completed 100+ projects (4.9★ rating), helping businesses save time, reduce errors, and boost efficiency. Please have a look at my project portfolio to have a better understanding of my experience. Lets chat and discuss the details further. FREE Consultation before Project Starts I can deliver a fast, accurate, and customized solution for your requirements. Let’s discuss your project—I can start right away. Looking forward to working with you!
$30 AUD in 1 day
6.1
6.1

Hello there, I can build and optimize your Power Automate flow to group Excel table data by Manager and send a single consolidated email to each manager. Approach * Read rows from the Excel table. * Retrieve unique Manager and Manager Email values. * Group staff records by manager. * Generate an HTML table containing all staff names (and any required details). * Send one email per manager with their grouped staff list. * Add error handling and optimize the flow for performance. I have experience with Power Automate, Excel Online, SharePoint, Outlook, expressions, and data transformation, and can deliver a clean, reusable solution with documentation. Best regards, Samira
$100 AUD in 7 days
5.6
5.6

Hi, I can build this Power Automate flow so each manager receives one clean email with their grouped staff names instead of manual Excel sorting. I would start by checking your table columns and email format, then create the flow to list rows, find unique manager emails, group matching staff, and handle duplicates or blank values safely. This fits my automation experience, and I can keep the flow simple, easy to maintain, and ready for future table changes. Thanks!
$20 AUD in 7 days
3.9
3.9

The tricky part of this flow is grouping rows by manager without a native distinct action in Power Automate. I would build an array variable to collect unique manager values, then loop through each to filter the matching rows and send a targeted email per manager. Ready to start today and have it done by tomorrow. Pricing shown is based on the description as written and may shift once we discuss the full scope. Want me to send a quick plan?
$30 AUD in 2 days
3.6
3.6

Hi, I can build this exact workflow in n8n instead of Power Automate — n8n actually gives more control here since grouping/deduplication logic can be handled cleanly in a Code node rather than working around platform limitations. **Workflow design** 1. **Fetch table rows** — a node pulling your source data (Google Sheets, Airtable, SharePoint, MySQL/Postgres, Excel node, or whatever backs your table) to retrieve all staff records. 2. **Extract unique managers** — a **Code node** (JavaScript) to deduplicate manager name + manager email pairs in a few lines, far simpler and faster than the workaround patterns needed in Power Automate. 3. **Group staff by manager** — for each unique manager, filter the full staff array down to their direct reports (again cleanly done in the same or a follow-up Code node), then format the list into HTML or plain text for the email body. 4. **Send one email per manager** — a **Split In Batches** (or **Loop Over Items**) node feeding into an **Email/SMTP or google mail/Outlook node**, sending one message per manager with their staff list embedded. **A few details worth confirming up front**, since they shape the exact node setup: - Data source (Google Sheets vs. Airtable vs. SQL vs. SharePoint) — this determines which n8n node/credentials I use. - Expected row volume, so I can decide between simple in-memory grouping (fine for hundreds of rows) vs. a more paginated approach for very large datasets. - Trigger type — scheduled (Cron node), manual, or triggered by a webhook/form submission. - Email formatting — plain list vs. styled HTML table matching your branding. - Whether managers with no listed staff should be skipped or still receive an email. **Deliverables** - Fully built, tested n8n workflow, exported as JSON for easy import into your instance (self-hosted or n8n Cloud) - Clear notes/sticky-notes inside the workflow explaining each node's purpose - A short written walkthrough covering how to update the data source, manager field mapping, and email template later - Test run confirming correct grouping, no duplicate or missed staff, one email per manager **Timeline**: this is a compact, well-scoped workflow — realistically a **1–2 day build** including testing, assuming standard nodes (Sheets/Airtable/SQL + email) with no unusual custom API integration needed. Happy to start once I know your data source, trigger type, and the volume/formatting details above — I'll lock in a fixed quote from there.
$29 AUD in 10 days
3.7
3.7

Hi, I can build your Power Automate flow to read table rows, extract unique manager names/emails, group staff names by manager, and send one clean email per manager automatically.
$15 AUD in 1 day
3.5
3.5

I understand you need a Power Automate flow that reads Excel table rows, identifies each unique manager and manager email, groups all staff under the correct manager, and sends a single consolidated email instead of multiple messages. I will build the flow to handle the grouping logic efficiently, ensuring every manager receives one email containing only their team's staff names. The flow will be clean, easy to maintain, and work reliably with your existing Excel table structure. If you already have the workbook prepared, share the sample file and I can tailor the flow to match it exactly.
$20 AUD in 1 day
3.7
3.7

Hello, I can build the Power Automate flow you need to automatically group staff by manager and send a single email to each manager containing all of their team members. The flow will read all rows from your Excel table, identify unique Manager and Manager Email values, group the corresponding staff records, and generate one consolidated email per manager instead of sending individual emails. The email body can be formatted as a table or list, depending on your preference. I have experience working with Power Automate, Excel Online, Office 365, expressions, filtering arrays, Select, Compose, and Apply to Each loops to create efficient, scalable workflows. The flow will be well-structured, easy to maintain, and designed to handle future additions to your Excel table without requiring modifications. I'll also ensure the flow is properly documented so you can edit or extend it later if needed. I'm available to start immediately and can deliver a fully working solution with testing and any minor adjustments required after deployment. Best Regards, Sajjad
$30 AUD in 1 day
3.7
3.7

As a seasoned full-stack developer, I am confident in my ability to create a robust Power Automate flow that meets all your requirements. With extensive experience in C# programming, Power Automate, and Sharepoint, I have successfully delivered numerous automation solutions for various clients, automating their business processes for increased efficiency and productivity. Moreover, my proficiency in Microsoft technologies including C#, .NET Core, ASP.NET, and Web API Development ensures that I am well-equipped to handle the data manipulation aspects of this project with ease. This includes listing unique manager names and their corresponding emails, grouping data appropriately, and sending email notifications to the staff - all in a succinct and seamless manner. Having actively contributed to modern JavaScript frameworks & tools, I bring an innovative approach to problem-solving and automation. Coupled with my thorough understanding of REST APIs and effective use of databases like MongoDB Atlas, you can trust- me to deliver a clean, high-performing solution tailored specifically to your needs. Let us make this process as smooth as possible; contact me now!
$13 AUD in 7 days
2.6
2.6

Hello I can build this Power Automate flow to list Excel table rows, extract unique managers, and group staff under each manager for a single consolidated email. I have experience building Power Automate workflows with Excel Online, SharePoint, Outlook, and dynamic data grouping using arrays, filters, and expressions. I will: * Extract rows from your table * Identify unique manager + email pairs * Group staff names per manager * Build clean email bodies automatically * Send one structured email per manager The flow will be efficient, scalable, and easy for you to maintain or extend later. I can start immediately. James.
$10 AUD in 1 day
2.6
2.6

Hi, I can build your Power Automate flow to efficiently group staff by manager and send a single consolidated email to each manager. The flow will read the Excel table, retrieve unique manager names and email addresses, group all associated staff records, and generate one personalized email per manager listing their team members. I will ensure the solution is optimized, easy to maintain, and thoroughly tested for accuracy. I have experience with Power Automate, Excel Online, SharePoint, and Outlook integrations, and can deliver a reliable, production-ready workflow with clear documentation and support for any required adjustments after delivery.
$20 AUD in 2 days
1.5
1.5

Hi, I'm Armin Nikdel. I can build this Power Automate flow for AUD 30 with delivery in about a week, using the Excel table as the source and sending one grouped email per manager. I’ll set it up to list rows from the table, collect unique manager and manager email pairs, group the related staff names, and format them into a single email for each manager. I’ll also add checks for blank manager emails and duplicate sends so the flow is reliable. Is the Excel table stored in OneDrive or SharePoint?
$30 AUD in 8 days
1.3
1.3

Hi, I’m a full-stack engineer with 7+ years of experience working with Power Automate, Excel automation, and workflow integrations across Microsoft 365 environments. I can build your flow to correctly extract rows from the Excel table, group data by manager, and send consolidated emails to each manager with their respective staff list, ensuring reliable and repeatable execution. I can start immediately. Best regards.
$20 AUD in 1 day
0.5
0.5

Having garnered close to a decade of relevant industry experience, I am confident that I am the ideal choice to create a power automate flow for your Excel email needs. My forte lies in building AI-powered workflows and scalable eCommerce systems which just happens to be exactly what you need for your project. My profound understanding of data processing, along with my extensive knowledge with Excel is paramount for the success of this task. Due to my well-rounded experience with Shopify, WordPress, and WooCommerce, I have developed an innate ability to combine modern technology with practical solutions to improve user experience and increase customer trust. Your requirement for pulling unique values for managers and their emails aligns seamlessly with my skillset, asover the years, I have developed highly performance-driven workflows that pull information from complex data sets without compromising efficiency. Moreover, working with me promises clear communication channels throughout the project, fast turnaround times without compromising on reliability or quality, clean and maintainable code, and focus on business results. In addition to the required technical skills, my dedication towards creating mobile-first and SEO-friendly platforms aligns perfectly with a modern business setup such as yours. To ensure streamlined operations for your business, I look forward to integrating AI technologies in order to automate repetitive tasks while minimizing any scope of errors. ług
$30 AUD in 2 days
0.0
0.0

Hi! I’ve built several Power Automate flows like this. I can create a flow that reads your Excel table, extracts unique managers, groups staff by manager, and sends a single email to each manager with their team list. The flow will be clean, easy to maintain, and fully documented. I can start right away and deliver quickly.
$65 AUD in 1 day
0.0
0.0

Hi, I hope you're doing well. I have carefully reviewed your project, Power Automate Excel Email Flow, and I'm confident I can deliver a high quality solution tailored to your requirements. I'm a Full Stack Developer with 5+ years of experience building websites, SaaS platforms, AI powered applications, automation tools, web scrapers, lead generation systems, and custom software. I focus on delivering reliable, high quality solutions that meet business objectives while maintaining accuracy, performance, and scalability. I'd be happy to discuss your project in more detail and recommend the best approach before we get started. I look forward to working with you. Best regards, Adnan Hussain Full Stack Developer | Technical Fixes | AI Automation | Lead Generation & Extraction Expert | Websites Dev
$10 AUD in 1 day
0.0
0.0

Hi, I understand you need a Power Automate flow that lists rows from an Excel table, extracts unique manager values and emails, and groups staff names to send them in a single email. Here’s how I plan to tackle this: - Set up the Power Automate flow to connect with your Excel file. - Use the "List rows present in a table" action to retrieve data from your Excel sheet. - Implement the "Select" and "Union" functions to extract unique manager names and email addresses. - Group staff names by manager using the "Group by" feature. - Use the "Send an email" action to dispatch a consolidated email to each manager with their respective staff names. - Test the flow thoroughly to ensure accuracy and reliability. I can start immediately and will keep lines of communication open for any adjustments or questions you may have. Looking forward to working together! Best, Artem
$10 AUD in 7 days
0.0
0.0

LET'S MAKE SURE YOU ONLY BUILD THIS ONCE. Managing Excel data efficiently can be challenging. With a Power Automate Excel Email Flow, we can streamline the process for you. My approach involves creating a flow that extracts unique manager details and groups staff names for seamless emailing. With a 5-star rating and a focus on long-term relationships, I guarantee strong communication and fast response times throughout our collaboration. I aim to understand your unique needs and deliver a solution that exceeds your expectations. Would you like to explore how this Power Automate solution can enhance your Excel data management? Best, Kurt
$15 AUD in 7 days
0.0
0.0

Hi, I can surely assist you with creating a Power Automate flow to streamline your Excel email process. I will design a flow that extracts rows from your table, retrieves unique manager details, and organizes data to send staff names efficiently in a single email. The final result will be a professional, well-structured email flow that is easy to use and enhances your workflow. I will deliver the project in a user-friendly format, ensuring easy navigation and understanding. Revisions will be provided to guarantee the flow aligns with your requirements. The estimated timeline for completion is within one week. One question: Do you have any specific preferences for the email layout or additional information to include? Regards, Valerie
$12 AUD in 14 days
0.0
0.0

Brisbane, Australia
Payment method verified
Member since Mar 4, 2015
$30-250 AUD
$2-8 AUD / hour
$15-25 AUD / hour
$250-750 AUD
$10-30 AUD
₹12500-37500 INR
£250-750 GBP
₹400-750 INR / hour
$30-250 USD
$10-30 AUD
₹12500-37500 INR
$1500-3000 USD
$30-250 USD
$750-1500 USD
$10-30 USD
$10-30 USD
₹12500-37500 INR
$10-30 USD
₹12500-37500 INR
₹750-1250 INR / hour
$10-30 AUD
£20-250 GBP
€30-250 EUR
$10-30 USD
$30-250 USD