Automatic Email When New Excel Data Is Added
With this Power Automate flow, you automatically send an email when new data is added to an Excel file. You create an automated flow with the Excel trigger 'When a new row is added', configure the correct table as the source, and add the Outlook action 'Send an email'. This way, all stakeholders are immediately notified of new data, without you having to manually check or send a message.
Goal: This flow automatically sends an email to a specified address when new data is added to an Excel file. This is useful for quickly sharing new information without having to manually check or send an email.
Goal: This flow automatically sends an email to a specified address when new data is added to an Excel file. This is useful for quickly sharing new information without having to manually check or send an email.
Benefit: By setting up this flow, you no longer need to spend time manually checking Excel files and sending notifications. All stakeholders are automatically notified of new data.
1. Create a new flow
-
Open Power Automate and click “Create flow”.
-
Choose “Automated flow” and give the flow a name, for example “New data in Excel - Email notification”.
2. Select the trigger
- Search for “When a new row is added” and choose the Excel connector. Select the file and the table where the new data is entered.
3. Add an action
-
Click “New step” and search for “Send an email (V2)”.
-
Fill in the fields:
Message: Add the data you want to receive in the email (for example the value of specific columns).
-
To: Fill in the email address where you want to send the notification.
-
Subject: For example “New data added to Excel”.
4. Save and test
- Save the flow and test it by adding new data to the Excel table. Check whether the email is sent.
Hopefully you have managed to automatically send an email when new data is added in Excel via Power Automate. In addition to this article, we have more articles in our knowledge base. Do you have questions? Feel free to contact us!
Our tip: Always store source files on SharePoint or OneDrive instead of a local drive. This ensures that the automatic refresh of Power BI also works outside the office.
Frequently asked questions
How do I create a flow that sends emails when new Excel data is added?
Open Power Automate and click Create flow. Choose Automated flow and give the flow a name. Select the trigger When a new row is added via the Excel connector. Choose the correct Excel file and the table where new rows are added. Then add the Outlook action to send the email and save the flow.
How do I set up the Excel trigger for a specific table?
In Power Automate, choose the trigger When a new row is added and select the Excel connector. Navigate to the correct Excel file and select the table for which you want to set the trigger. The Excel file must be on SharePoint or OneDrive; a local file is not supported by the Excel connector in Power Automate.
How do I add an email action to a Power Automate flow?
Click New step and search for Send an email (V2) via the Outlook connector. Fill in the To field with the desired email address, provide a subject, and fill in the message body with dynamic content from the Excel row, such as the values of specific columns. Save the flow and test it by adding a new row to the Excel table.
Why is the Excel trigger in Power Automate not working?
The Excel connector in Power Automate requires that the file be on SharePoint or OneDrive and that the data is in a structured table, not just a range. Make sure you have created a table via Insert in Excel. Also check that the connection to your Microsoft account is correctly configured. If the table is empty, the trigger only activates once the first row is added.