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

ความคิดเห็น • 18

  • @qualityassurancelab7764
    @qualityassurancelab7764  3 ปีที่แล้ว +4

    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 6 หลายเดือนก่อน

    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 ปีที่แล้ว +1

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

  • @marammadhupal1380
    @marammadhupal1380 2 ปีที่แล้ว

    Nice and very clear explanation. Thank you!

  • @vishnupp5944
    @vishnupp5944 2 หลายเดือนก่อน

    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)???

  • @_kishan_savaliya
    @_kishan_savaliya 2 ปีที่แล้ว

    Very Easy explanation Thanks

  • @pankajkaushik7284
    @pankajkaushik7284 3 ปีที่แล้ว

    Thanks for Valuable info.

  • @Wizzy3012
    @Wizzy3012 3 ปีที่แล้ว

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

  • @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 ปีที่แล้ว +1

    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

  • @Wizzy3012
    @Wizzy3012 3 ปีที่แล้ว +1

    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

  • @rekhavijayan1349
    @rekhavijayan1349 3 ปีที่แล้ว

    nice work learnt a lot

  • @birendragosain
    @birendragosain 2 ปีที่แล้ว

    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

  • @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

  • @HaiPhan93
    @HaiPhan93 3 ปีที่แล้ว

    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 3 หลายเดือนก่อน

      U can make use of office scripts in power automate