Microsoft Power Automate | Add data to Excel, get data from Excel, Conditions and Send Email | Guide

In this tutorial, it is shown, how to add data to Excel (add row via input form in Power Automate), get data from Excel to Power Automate and then use a for each row on the data in a table. Finally send an email based on the results of the conditions.

You could also watch:
? Microsoft Power Automate Tutorial for Beginners –
? Microsoft Power Automate Cases –

00:06 Intro to this Power Automate Tutorial
Today’s tutorial is about Power Automate, Excel and Outlook. In the first use case we update Excel tables with Power Automate and in the second use case we will apply conditions to Excel data and send emails based on those condtions.

00:24 Update Excel Tables with Power Automate
Creating a Power Automate flow to make data entries to an Excel table.

01:32 Add Input (manually from user – text and number)
In our manual trigger we will define, what input Power Automate should take from the user.

02:21 New Step – Excel Online (Business)

02:29 Add A Row Into A table
The ‘Add A Row’ will add a row into a defined Excel table

06:15 Create a Flow (Import data from Excel, Condition and Send Mail)
How to create a Power Automate Flow, import data from Excel and send mails based on conditions on the data from Excel.

06:55 List Rows Present In Table
The ‘List Rows Present In Table’ will get all the rows in an Excel table, so we can work with them.

07:40 Apply To Each
We iterate through each row with an ‘Apply To Each’.

08:15 Condition
Applying a simple condition to our data.

10:40 Send Email (notification to our self)
We send out emails based on our condition.

? Best Power Automate Book –

Connect with me:
? Subscribe –
? LinkedIn –
? Facebook –
? Email Newsletter –

#microsoft #powerautomate #excel


Since 30 years I work on Database Architecture and data migration protocols. I am also a consultant in Web content management solutions and medias protecting solutions. I am experienced web-developer with over 10 years developing PHP/MySQL, C#, VB.Net applications ranging from simple web sites to extensive web-based business applications. Besides my work, I like to work freelance only on some wordpress projects because it is relaxing and delightful CMS for me. When not working, I like to dance salsa and swing and to have fun with my little family.

You may also like...