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

This video tutorial shows 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:

GET HELP IN MY POWER AUTOMATE GROUPS:

00:00 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 conditions.

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 emails 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 to 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.

FOLLOW ME:

#microsoft #powerautomate #excel

[sarveshpandey]

Before watching this, I had a feeling that implementing email notification with condition on a row in excel is so difficult. Thank you. Really cool stuff.

[ericzheng]

Thank you Anders. Power Automate is such an amazing software - but it is nothing to beginners like me without sophisticated trainers like you!

[andersjensenorg]

Do you want to get an intro to Microsoft Power Automate?

[jeangui]

Thanks for this detailed tutorial! Finally figured out how to make data transfer to work from SmartSheet to Excel.

[leonardogoncalves]

Very nice stuff. Thank you so much for this guidance. I've used that on my work to control and report viscosity levels of oil lubricants and also analysis of vibration of industrial blowers's gearbox used in cooling towers.

[rasithachathurangaliyange]

This is incredible and great stuff. thank you so much for this guidance.

[shirleysmith]

This is incredible!!!! Thank you so much.

[nicolaslupo]

Great video! Thank you so much from Argentina!

[antognani]

man your accent is sooo good to listen to.

[jorgevalencia]

Thank you for the guide. Greetings from Peru

[chicanight]

This tutorial is really good. I learned so much from it. I am so glad I found you. Thank you so much.

[rets]

Even timestamped the video. Absolutely clutch!

[IndianKiwi]

Thanks for the informative video and explaining the use of float function for converting string to integer.
I will really appreciate your help here-
Can we use conditions with dates for mail merge in Power Automate?

[fittolast]

Thank you so much for this - really helpful!

[alphamackie]

Hey man thanks for your tutorials. Wondering whether you've got any idea on how to position an address on a letter so that it shows on a window envelope using uipath.

[JohnJ-fjxe]

Thank you. I look forward to applying these ideas.

[hballestas]

Muchas gracias por tu ayuda. Excelente tutorial.

[goviktor]

Great ! You make a great job !!!! Thanks for the video

[MrChavakoti]

Very Good explanation Jenson and i am able to replicate without any issue on my workflow. String to float convertion is major part :

[prabakaransubramaniam]

Hi Anders, its a very informative video. I do have some questions.
1. Is it possible to use the information from one excel source (in table format) to have an action to fill details of say 5 different files ?
2. In terms of the excel formats, is there any restriction on the format (eg. csv, xlsx, etc)