web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Make Power Automate, t...
Power Automate
Unanswered

Make Power Automate, to pick 80 entries from a sheet, copy, change color, And paste in Outlook New Email and into BCC paste it. This needs to Automate uptil the whole list is color changed.

(0) ShareShare
ReportReport
Posted on by 8

Make Power Automate, to pick 80 email addresss from a sheet, copy, change color, And paste in Outlook New Email and into BCC paste it. This needs to Automate uptil the whole list is color changed.

I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @zeenatailors 

     

    could you explain your question properly 🙂 

  • zeenatailors Profile Picture
    8 on at

    Hello Sir,

    I have an Excel file with multiple sheets, those sheets contain email address which I use for Marketting. I wanted Auotmate to pick 50 email addresses from that sheet, and change the color of those selected email addresses.

    Then compose email with pre defined text and attachment and send email using MS Outlook

     

     

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @zeenatailors 

     

    so this step you have to repeat for every sheet right?

     

    Also does the data in excel is shown in table format ?

     

    Did you meant coloring the cells ?

     

    Also do you want to send indiviual emails for marketing , or all at once for emails present in sheet ?

     

    Let me know 🙂

  • zeenatailors Profile Picture
    8 on at

    Hello

    The data is as i the file attached.

     

    The first Column is for category, second email address and the third is a formula applied where it checks with emails which has bounced back and maintained in another sheet in same file

     

    Now we have over 5000+ emails, we use gmail to send email which is 80 limit per day, 

     

    So we want automate to run daily to send email to 80 people and turn those emails to another color

    the next day it looks for emails not in that color and then completes the list 

     

    Get me?

  • zeenatailors Profile Picture
    8 on at

    The daily sending limit will be 80 only.

     

     

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @zeenatailors 

     

    Got your requirement, so one question there is a last column having value as sent, is it to record which email to which we have send to ?

     

     

  • zeenatailors Profile Picture
    8 on at

    That is just for a record that email had been sent.

     

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @zeenatailors 

     

    Assuming that the below highlighted column name is Status, which is just a record whether an email is sent or not.

    Nived_Nambiar_0-1683944030374.png

     

     

    Now let's use flow to send emails to top 80 email id to which emails need to be sent 

     

    Use list rows to list all rows in the table like below

    Nived_Nambiar_1-1683944086249.png

     

    here we have used Filter query as Status ne 'Sent' , so to filter the rows whose status is not equal to sent and then we specify Top parameter to capture only top 80 emails.

     

    Once we capture it, we will use send email action to send the email and update Status column as sent accordingly.

     

    Nived_Nambiar_2-1683944202159.png

     

     

    Hope this helps you !

     

    Mark it as solution if it resolves your query 

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 419

#2
Vish WR Profile Picture

Vish WR 314

#3
David_MA Profile Picture

David_MA 260 Super User 2026 Season 1

Last 30 days Overall leaderboard