cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dustinmhodges
Level: Power Up

Retrieve email addresses from Excel sheet in Sharepoint and send emails automatically?

Hi Flow Community,

 

Dustin here...total noob. I have a process which involves a user uploading a new Excel Sheet each week with the same nomenclature, but with the date adjusted for the week it was sent. This spreadsheet is hosted in a shared document library and contains a column of email addresses. I am looking for a flow that could retrieve the email addresses from the column in the sheet, and send an email from Office365 to those emails listed. It will be the same standard template email each week.

 

Is this possible? Many thanks to all in advance!

 

Regards,

Dustin

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Retrieve email addresses from Excel sheet in Sharepoint and send emails automatically?

Hi @dustinmhodges,

 

For Excel stored in SharePoint library, it is not available for the Excel connector to work with it.

Check:

https://docs.microsoft.com/en-us/connectors/excel/

"

Microsoft Excel is a spreadsheet developed by Microsoft. Connect to your Microsoft Excel spreadsheets in your file services like OneDrive for Business, OneDrive, Dropbox, Box, etc. You can perform various actions such as create, update, get, and delete on rows in a table.

The Excel Connector currently connects to Tables only. It will insert a column called __PowerAppsId__ to the Table if there is no such column. This column is used to keep track of changes in the row.

"

A possible workaround should be:

1. First, Add the SharePoint trigger-.When a file is modified (to make this work properly, please create a special folder for the Excel file),

2. Copy the Excel file into OneDrive for Business,

3. Add the Excel connector, choose the Get rows action, 

4. After that, take use of the Outlook Send Email action to work with the Email address.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Retrieve email addresses from Excel sheet in Sharepoint and send emails automatically?

Hi @dustinmhodges,

 

For Excel stored in SharePoint library, it is not available for the Excel connector to work with it.

Check:

https://docs.microsoft.com/en-us/connectors/excel/

"

Microsoft Excel is a spreadsheet developed by Microsoft. Connect to your Microsoft Excel spreadsheets in your file services like OneDrive for Business, OneDrive, Dropbox, Box, etc. You can perform various actions such as create, update, get, and delete on rows in a table.

The Excel Connector currently connects to Tables only. It will insert a column called __PowerAppsId__ to the Table if there is no such column. This column is used to keep track of changes in the row.

"

A possible workaround should be:

1. First, Add the SharePoint trigger-.When a file is modified (to make this work properly, please create a special folder for the Excel file),

2. Copy the Excel file into OneDrive for Business,

3. Add the Excel connector, choose the Get rows action, 

4. After that, take use of the Outlook Send Email action to work with the Email address.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

dustinmhodges
Level: Power Up

Re: Retrieve email addresses from Excel sheet in Sharepoint and send emails automatically?

Hi Michael,

 

Thank you so much for the detail. I am going to play with this workflow, and I will report back if I find any success or challenges worth noting. Thank you!

 

Regards,

Dustin

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,925)