Email from sharepoint Excel to concerned

Question

Dear Team,

Is there a way to send email from Excel which is in sharepoint.

If we enter a person's name in a cell, that particular row details should be sent to that person's email.

Please advise.

Thank you

Best Regards,

Krishnakumar

Answer 1

Hi @KRISHNAKUMAR J ,

Yes, it is possible to send an email from an Excel file that is stored in SharePoint. You can use Microsoft Power Automate (previously known as Microsoft Flow) to create a flow that sends an email when a user updates the data and provides an email in the assigned to column inside the Excel .

Here are the steps to create a flow that sends an email when an email is provided in the assigned to column inside the Excel file:

1. Create a new flow in Power Automate.
2. Select the Excel file that is stored in SharePoint as the trigger.
3. Add a condition to check if an email is provided in the assigned to column inside the Excel file.
4. If an email is provided, send an email to the assigned person using the “Send an email” action in Power Automate .

Here's a simple example for your reference:https://powerusers.microsoft.com/t5/Building-Flows/Flow-from-excel-placed-in-sharePoint-and-send-email-when-email/td-p/845192

Since Power Automate is currently not supported in the Q&A forum, and my knowledge of it is limited, it would be great if this solves your problem. If this doesn't solve your problem, or if you have a more complex problem, it is recommended that you start a new discussion via the Power Automate Community to get more targeted support.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.