Read data from Excel | Write data to excel | Send Email based on condition| Microsoft Power Automate
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- 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 -
TH-cam - / @qualityassurancelab7764
LinkedIn - / quality-assurance-lab-...
Facebook - / quality-assurance-lab-...
Twitter - / labassurance
Medium - / labassurance
Join Channel Membership - / @qualityassurancelab7764
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!
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.
Superb classes, No words to speak🗣. Thank you. Be Rocking 🎸🎶🎶 always.
Nice and very clear explanation. Thank you!
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)???
Very Easy explanation Thanks
Thanks for Valuable info.
Ma'am please start a tutorial series for MS power platform..your way of teaching is outstanding.... please consider my request 🙏🙏🙏
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
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
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
nice work learnt a lot
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
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.
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
How to format number as currency (in a column) in email action?
If excel file is not formatted as a table. How to read that excel file?
U can make use of office scripts in power automate