Excel Automation in Power Automate Desktop | Read data from Excel in Power Automate Desktop #02

Поделиться
HTML-код
  • Опубликовано: 10 дек 2024

Комментарии •

  • @qualityassurancelab7764
    @qualityassurancelab7764  3 года назад +6

    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!

    • @tele2662
      @tele2662 2 года назад

      Was very useful. Thank you!

  • @rpjlee
    @rpjlee 10 месяцев назад +1

    The only video that actually teaches you how not to "hardcode" last column and row. The rest of the videos with millions of views are just "hard-coding" the columns and rows. Thank you for this amazing videos. It should have 4.76 million views. Seriously!!!

  • @codebychetan
    @codebychetan Год назад

    Clear cut explanation for beginner. Kudos.

  • @iMadeThisThat
    @iMadeThisThat 3 года назад +1

    Excellent video! Loving this series on Power Automate! I have also pressed the BELL icon on your Channel to see the upcoming videos immediately..!

  • @avneet50500
    @avneet50500 2 года назад

    Found the video very useful. Content was clear and explanation was very good. Thanks !!!!!

  • @pavankumar-tm8dr
    @pavankumar-tm8dr 3 года назад +5

    Thank you very much you done great job 👏
    For helping people who wants learn
    And more over you have such good teaching skills nice explanation with examples
    Tq ...

  • @greggapowell67
    @greggapowell67 3 года назад +1

    THANKS! You just helped me figure something out!

  • @knightz273
    @knightz273 2 года назад

    Excellent tutorials i was able to follow everything. Thank you team QAL please keep up the great work.

  • @goviktor
    @goviktor 2 года назад

    Thank you very much for such an exciting guide!!!!!

  • @sandeepallaka1988
    @sandeepallaka1988 3 года назад +1

    Excellent explanation😊

  • @aminvogue
    @aminvogue 3 года назад

    Thanks a lot ma'm , your work deserve a hats off

  • @jamesyao8288
    @jamesyao8288 3 года назад

    Thank you so much! It helped me with my project and saved me hours of research.

  • @gangadayal4585
    @gangadayal4585 6 месяцев назад

    Very valuable and informative video

  • @nuinhuin7325
    @nuinhuin7325 2 года назад

    Thank you for sharing your knowledge! Great video. Wish you will bring more 😁

  • @notonurnelly
    @notonurnelly 3 года назад +1

    Really useful thank you,
    An well explained demonstration and a practical use case. :) I will keep my eye for upcoming demonstrations.

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад

      Thanks, please checkout the next video here - ruclips.net/video/r7RwdpkN-Fg/видео.html

  • @mlhtest5928
    @mlhtest5928 Год назад

    Great content, thank you!

  • @joswadsouza9849
    @joswadsouza9849 3 года назад +1

    Hello once again good video ❤️🔥

  • @RC-nn1ld
    @RC-nn1ld 3 года назад

    Very good video, I learnt a lot, thank you

  • @mharish83
    @mharish83 3 года назад +1

    Very much appreciated...!

  • @umanggulati6840
    @umanggulati6840 3 года назад +1

    Thanks for the great video.
    Is there a way we can filter the excel data table? Either while reading from excel or filter the datatable in Power Automate Desktop?

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад

      You are welcome. You can filter excel data table using For Each and If action as shown here - ruclips.net/video/eBC3pBEZ5uc/видео.html

  • @sravanipula8642
    @sravanipula8642 3 года назад

    Please Add more videos explaining all commands in power automation

  • @aquabestindian
    @aquabestindian 2 года назад

    Thanks, this is great!
    Could you please help me with a problem,
    Whenever a new Excel file is placed in a SharePoint folder, I want to read its contents and send emails accordingly.
    Each Excel file will have a different name, but the table design in it will be the same.

  • @shashikkantlohar1163
    @shashikkantlohar1163 2 года назад

    Nicely explained madam..

  • @sathishbe2010
    @sathishbe2010 4 месяца назад

    Please explain get cells contents as text in read excel activities

  • @udaykumarsayala5034
    @udaykumarsayala5034 Год назад

    Hi , Videos are very useful to me to learn the Power automate.
    I want an scenario which you read the excel file. For example if there are 255 columns and 20 rows based on this 255 columns I 1O columns information along with rows data as well. Like that column names like A, B , C,D, E, F, G, H , I, J , K, L M, N, O, P ,Q for this columns we have rows values are also available in that columns I want columns like A, B,C,F,I only. Can you help me how to filter this values.

  • @smadasamy81
    @smadasamy81 2 года назад

    Nice Video,

  • @guatkiemtan2557
    @guatkiemtan2557 3 года назад

    Hi, thanks, this is really useful. do you have any video that explain how to copy data from one excel and append it into another excel? i could not find it in your video list.

  • @yogeethasusparsha4547
    @yogeethasusparsha4547 3 года назад +1

    Thank you!! Very useful video.. I tried to create the same workflow and I get If Action error that says - 'Column or property 'Salary' not found.' I do have this column in my excel workbook. Can you please help me on this?

  • @dicksontantacksinn3493
    @dicksontantacksinn3493 3 года назад +1

    Hi and thank you for your video. I have tried to create a sample use case like yours, but i got a error message on the function "IF". The error message told me that "Column or property 'Percent' is not found. But in my excel file, I got input data under 'Percent' but it still mentions that could not be found. Can you please help me on this? Thank you\ and stay safe.

    • @qualityassurancelab7764
      @qualityassurancelab7764  3 года назад +1

      Hi, please let ,me know the expression you added inside If

    • @dicksontantacksinn3493
      @dicksontantacksinn3493 3 года назад

      @@qualityassurancelab7764
      Hi and thank you for replying me.
      Inside my "IF" expression are
      First operand: %CurrentItem['Percent']%
      Operator: Less than (

  • @kaditya4902
    @kaditya4902 3 года назад

    Hiie, Can we read group of excel files from a folder ?

  • @tylerkolota
    @tylerkolota 2 года назад

    If you’re interested in sending the data to SharePoint or some other dataset after reading the Excel data, then check this video: ruclips.net/video/ONl7B9-9lPU/видео.html

  • @amruteshammu8245
    @amruteshammu8245 2 года назад

    I have a doubt that if we create a new header column as status and if salary is greater than 10k it should display as red otherswise it should display as green can you please say how to do it

  • @lookman06
    @lookman06 2 года назад

    Hi, how do you get the excel file to open automatically ? for my case the excel only pops up in the shortcut taskbar but it does not open

  • @RenoTrader
    @RenoTrader 2 года назад

    what if my excel file is not in my drive but it is on my ONEDRIVE BUSSINES FOLDER ONLINE?

  • @neerajkhadilkar2329
    @neerajkhadilkar2329 5 месяцев назад

    Hi how i can get the single column it seems %CurrentItem[""Salary"]% This is no longer working

  • @sathishbe2010
    @sathishbe2010 4 месяца назад

    One doubt all value of variables used in read from excel activities

  • @soumyadas02012
    @soumyadas02012 3 года назад +1

    1st View