Read data from Excel | Write data to excel | Send Email based on condition| Microsoft Power Automate

preview_player
Показать описание
This video explains how to work with Excel in Microsoft Power Automate.
Learning -
0:48 - Read data from excel using List rows present in Table Action
3:07 - Apply to each to the list of rows from previous step
3:52 - Apply condition
4:43 - Send email if the condition is true
8:27 - Add data to excel using Add a row into a table action
8:57 - Take user input
13:23 - Delete data from excel using Delete a row action

=========================================================
Microsoft Power Automate Desktop Tutorial Playlist:

Microsoft Power Automate Tutorial Playlist:

Automation Anywhere A11 Tutorial Playlist:

Automation Anywhere A2019 Tutorial Playlist:

UiPath Tutorial Playlist:

JMeter Tutorial Playlist:

Git and GitHub Tutorial Playlist:

Connect with me for some interesting updates here -

Рекомендации по теме
Комментарии
Автор

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

qualityassurancelab
Автор

Finally!! Thank you, Thank you!! I have been browsing all day. This was exactly what I was looking for. Straight to the point and clear.

SyreTek-oxvf
Автор

Superb classes, No words to speak🗣. Thank you. Be Rocking 🎸🎶🎶 always.

sreemanthkumar
Автор

thanks for the video.... if we run the send mail flow again, as it has some new rows inputed, would the previous employees get mail again (they got mail already at the first run)???

vishnupp
Автор

Clear explanation
My query is if we add row and update the file on daily basis, whether the flow run again from start and send mail once again, which already sent or it will send only for that row

acharya
Автор

Nice and very clear explanation. Thank you!

marammadhupal
Автор

Ma'am please start a tutorial series for MS power platform..your way of teaching is outstanding.... please consider my request 🙏🙏🙏

Wizzy
Автор

Please upload how to compare excel sheets in power Automate n cover some more important topics of power ma'am ....will b waiting

Wizzy
Автор

Hi Ma'am thank you I have been following your channel for long. I have one doubt when we send mail it seems like our is getting sent as single line How to give space in between i.e., new line? Please put more content in email

AbhishekSharma-xter
Автор

hi Maam, Thanks for the video and it was quiet knowledgeable. i have a query what if i add data in 6 row manually and put eligible for promotion as "YES" will an email be triggered only to the new added row or it will send email again to all the 3 which have eligible for promotion as "YES".

Please reply back to my query, awaiting for your reply

birendragosain
Автор

Here we have taken yes or no only in the eligible for promotion colomn if we have other multiple inputs how can we send the email to them, plzz help me here.

ashokchittempelli
Автор

I want to edit a field in .dbf file, any idea how to do it ? tried reading as text and saving but file gets corrupt

DilipKumar-mqgi
Автор

How to format number as currency (in a column) in email action?

HaiPhan
Автор

If excel file is not formatted as a table. How to read that excel file?

priyankanaphade