cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kprice1
New Member

Flow to send email using email addresses held in an excel file

Is it possible to create a flow to email a file saved on a SharePoint site to send to email addresses listed in another file (or within the same file) also on a sharepoint site?

 

The email addresses will change frequently and global distribution lists are maintained by IT so updating a global distribution list would not be an efficient solution (i.e. it would be quicker to update the email addresses in the flow)

 

Open to any ideas and suggestions

1 REPLY 1
mattias1172
Responsive Resident
Responsive Resident

While this is possible, in the long run, it would likely be easier to use either a standard Distribution List or a Dynamic Distribution List. This is ultimately what they are intended for. 

 

In a short text example, you'd need to first query that data in the "emails" excel sheet to get an array of emails, get a link or the contents of the file you want to send, and setup a loop to cycle through your emails array and send to each address. 

 

If you use a DL or DYL, you just need one single email action to send the file to every user, no loop required. 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,562)