Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Using Power Automate t...
Power Automate - Building Flows
Unanswered

Using Power Automate to automatically send email from excel spreadsheet

Like (0) ShareShare
ReportReport
Posted on 21 Nov 2022 09:41:46 by Robinofwicken 7

Hi all,

 

I hope you're well!

 

I am having trouble building a flow for sending emails using power automate by using an excel spreadsheet. I have tried to follow the advice in the article below, however I am experiencing some problems:

 

Power Automate Flow - Sending emails to list of pe... - Power Platform Community (microsoft.com)

 

The flow doesn't give the correct inputs (the addresses I would assume) to the 'send an email function' and so the flow stops working. I have no idea what I am doing wrong and I've checked it many times.

 

Failing a solution, is there another way to pull email addresses from an excel and send emails? 

 

Thanks all in advance! 

  • Robinofwicken Profile Picture
    Robinofwicken 7 on 21 Nov 2022 at 12:42:15
    Re: Using Power Automate to automatically send email from excel spreadsheet

    Hi,

     

    I actually managed to get it to work after sending this! Please see screenshot below:

     

    Robinofwicken_0-1669034450262.png

     

    I was missing the 'Append to string variable' step which prevented an error I was receiving which mentioned the data needing to be treated as an 'array'. 

     

    In summary, I don't entirely understand why but it does now work! If anyone else can offer insights then please do.

     

  • grantjenkins Profile Picture
    grantjenkins 11,059 Super User 2025 Season 1 on 21 Nov 2022 at 12:21:00
    Re: Using Power Automate to automatically send email from excel spreadsheet

    Can you share a screenshot of your Excel file to see how you've stored the emails, and also screenshot(s) of your flow?

     

    Are you setting up a scheduled trigger that runs daily, or some other trigger? Any extra info you have can help to work out what you're after.  

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

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans