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

  Рет қаралды 15,858

Quality Assurance Lab

Quality Assurance Lab

3 жыл бұрын

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:
• Power Automate Desktop...
Microsoft Power Automate Tutorial Playlist:
• Power Automate Tutoria...
Automation Anywhere A11 Tutorial Playlist:
• Automation Anywhere A1...
Automation Anywhere A2019 Tutorial Playlist:
• Automation Anywhere A2019
UiPath Tutorial Playlist:
• UiPath Tutorial
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Subscribe for more tutorials - / @qualityassurancelab7764
Connect with me for some interesting updates here -
KZbin - / @qualityassurancelab7764
LinkedIn - / quality-assurance-lab-...
Facebook - / quality-assurance-lab-...
Twitter - / labassurance
Medium - / labassurance
Join Channel Membership - / @qualityassurancelab7764

Пікірлер: 17
@qualityassurancelab7764
@qualityassurancelab7764 3 жыл бұрын
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!
@SyreTek-ox8vf
@SyreTek-ox8vf 3 ай бұрын
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.
@sreemanthkumar5964
@sreemanthkumar5964 3 жыл бұрын
Superb classes, No words to speak🗣. Thank you. Be Rocking 🎸🎶🎶 always.
@marammadhupal1380
@marammadhupal1380 2 жыл бұрын
Nice and very clear explanation. Thank you!
@pankajkaushik7284
@pankajkaushik7284 3 жыл бұрын
Thanks for Valuable info.
@_kishan_savaliya
@_kishan_savaliya 2 жыл бұрын
Very Easy explanation Thanks
@rekhavijayan1349
@rekhavijayan1349 2 жыл бұрын
nice work learnt a lot
@Wizzy3012
@Wizzy3012 2 жыл бұрын
Ma'am please start a tutorial series for MS power platform..your way of teaching is outstanding.... please consider my request 🙏🙏🙏
@Wizzy3012
@Wizzy3012 3 жыл бұрын
Please upload how to compare excel sheets in power Automate n cover some more important topics of power automation.....please ma'am ....will b waiting
@acharya152002
@acharya152002 2 жыл бұрын
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
@AbhishekSharma-xt9er
@AbhishekSharma-xt9er 3 жыл бұрын
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
@ashokchittempelli8157
@ashokchittempelli8157 2 жыл бұрын
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.
@DilipKumar-mq2gi
@DilipKumar-mq2gi Жыл бұрын
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
@birendragosain
@birendragosain Жыл бұрын
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
@HaiPhan93
@HaiPhan93 2 жыл бұрын
How to format number as currency (in a column) in email action?
@priyankanaphade256
@priyankanaphade256 Жыл бұрын
If excel file is not formatted as a table. How to read that excel file?
@amolnaik6027
@amolnaik6027 15 күн бұрын
U can make use of office scripts in power automate
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 35 МЛН
The child was abused by the clown#Short #Officer Rabbit #angel
00:55
兔子警官
Рет қаралды 25 МЛН
ОСКАР vs БАДАБУМЧИК БОЙ!  УВЕЗЛИ на СКОРОЙ!
13:45
Бадабумчик
Рет қаралды 4,5 МЛН
THE POLICE TAKES ME! feat @PANDAGIRLOFFICIAL #shorts
00:31
PANDA BOI
Рет қаралды 24 МЛН
Excel in Power Automate for Desktop (Full Tutorial)
28:39
Anders Jensen
Рет қаралды 27 М.
When an Excel row is created, modified, or deleted
32:59
Tyler Kolota
Рет қаралды 10 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 371 М.
Use Power Automate to Send Excel Data to Outlook | Practical Use Case
9:33
Import Outlook to Excel with Power Automate Tutorial
13:33
Kevin Stratvert
Рет қаралды 342 М.
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 35 МЛН