Power Automate Desktop : Module 3 : Excel Automation - 1 (Launch Excel, Read from Excel,Close Excel)

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

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

  • @thebhaskarjoshi
    @thebhaskarjoshi 3 года назад +3

    I really appreciate your efforts towards teaching new technology

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

    Thank you for your lectures of power automate. According to these things, I could use RPA easily.

  • @kancharlasan
    @kancharlasan 3 года назад +3

    Sir, the explanation was crisp and clear. Really worth learning from you

  • @FayezEneim
    @FayezEneim 2 года назад +1

    Great session

  • @sciences-sci
    @sciences-sci 2 года назад +1

    great video really good, good teaching thank you

  • @steadyballer
    @steadyballer 2 года назад +1

    Thanks for the tutorial, most helpful. Would like to ask if PAD can also read content from Word document? Can't find this action in PAD. Thanks for the advice.

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

    Nice explanation! Thank u Ameer, Thank u LT!

  • @vmohakrish
    @vmohakrish Год назад +1

    Thanks for video . Do you know how to get last row of a column

  • @lisam8986
    @lisam8986 10 месяцев назад

    In step #2 you chose range, can a table be used? If so would that be the third option “from selection”?

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

    Thanks for much.
    Is there a way to open the most recently modified excel file in a folder ? I.e the most recent? Thanks in advance

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

    Very good. Thank you

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

    Clearly Explained, Can you please create a video on Excel file consolidation to a master file.

  • @vigneshg9648
    @vigneshg9648 3 года назад +2

    How to filter an excel data and work on the filtered data instead of original data?

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

    I have a csv file, which I use to separate the data into columns and then save it as the same name as csv file, but in .xlsx format. I use the Close Excel function and then Save the document as with Document Format .xlsx and the path , I want it the name of the csv without the extension. Could you suggest how to do it?
    Thanks in advance,

  • @ievaraj6961
    @ievaraj6961 2 года назад +1

    Sir can you are explain hot to log in outlook and download attachments please

  • @ariehashimie
    @ariehashimie 4 года назад +1

    Hi Sir. Good video learning you post for sure. Im new into power automate and with your video gave lot of information especially handling the desktop version of power automate. And perhaps sir will it be possible for you to post on how to handle empty row in excel file. There is no video that close to how to handle it in power automate dekstop. Most of it focus more on web version. Thank you in advance sir.

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

    Fantastic Bro, can we play power automate with power query as well..?

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

    Hello Sir, Thank you for making it easy for us by your videos.
    could you pls help me i am stuck in one scenario, i have to read multiple xls file and save it to xlsx..which am abke to do it for a single file by launch excel and close excel .
    But when i do it for multiple file i used foreach loop to read all the xls and that variable i.e "currentItem" i passed it to close excel document path.
    the issue is file gets launch, but did not get save it in xlsx format .could you pls advice

  • @lasaventurasdesharonagudel9745
    @lasaventurasdesharonagudel9745 4 года назад +1

    Hi Learning Technologies, Thanks so much for the video, is very valuable information. Could you please guide me about, How to open different excel files in a folder? For example: I have 5 files in a folder and I need to open one at a time and read de information. I know that i need a loop, but, how to go directly to each file. Thanks

    • @LearningTechnologies
      @LearningTechnologies  4 года назад

      There is one action where you can get the information of files in folder i.e get files in folder.
      By using that you can get the information
      ruclips.net/video/uwICwOmQOJ4/видео.html

    • @lasaventurasdesharonagudel9745
      @lasaventurasdesharonagudel9745 4 года назад +1

      @@LearningTechnologies Thanks so much

    • @LearningTechnologies
      @LearningTechnologies  4 года назад

      Welcome Jonathan

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

    Hello Sir,
    can we enter a "count of not empty rows" in the property of read from excel action at end row. if yes then please explain how we can "count the not empty rows" in excel and csv both

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

    But I have latest version for Power Automate. Where I can get the "Launch Excel" from the "Excel expand"?

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

    How to make rows and columns dynamic

  • @twangt
    @twangt 4 года назад +1

    Hello!
    Great video! :)
    Is it possible to maybe make an example of how to use the OCR action, to extract text from an image and output it with searchable text.
    Could be very useful! :)
    Thanks

  • @avinashsingh6691
    @avinashsingh6691 3 года назад +2

    How to make data range dynamic?

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

    there is also problem with signing in account after clicling on flow

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

    hello, can we connect for a paid consultation, I have issue in my flow with Excel? Thanks

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

    How do i set it to read from a specific sheet with a workbook with multiple sheets?

  • @OnlyIasReader76
    @OnlyIasReader76 2 года назад +1

    Can you make all excel activity

  • @abeybrams2366
    @abeybrams2366 Год назад +1

    Hellow Sir
    Where can we get the excel data?

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

    how to create flow with no triggers option

  • @kraken8701
    @kraken8701 10 месяцев назад

    Here if i modify data in excel after run flow there is not get that data in text file , what to do for this query??

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

    How can we achieve this in power automate not using power automate desktop

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

    Can we not use google sheets instead?

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

    Clear

  • @anilyadav-rt4sr
    @anilyadav-rt4sr 4 года назад

    Thanks

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

    what if you dont know the last row in the excel and you want it to read everything in the excel?