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
