Power Automate Desktop: Read Excel and Web Search - Beginners Tutorial

Поділитися
Вставка
  • Опубліковано 15 жов 2024

КОМЕНТАРІ • 37

  • @andersjensenorg
    @andersjensenorg  5 місяців тому +2

    Thanks for all your likes and support 🔥🙌
    I've created a 100% free community with 12,000 RPA developers: discord.gg/iloveautomation Here we network and help each other with solutions.

    • @Okanbrk
      @Okanbrk 15 днів тому

      dıscord lınk ıs doesnt work sır

  • @mik32165
    @mik32165 Місяць тому +1

    This is exactly what I was looking for. Easy to understand without unnecessary information. Thank you!

    • @andersjensenorg
      @andersjensenorg  5 днів тому

      My pleasure, glad you liked it 😊🙌 Kind regards, Anders

  • @jazzbrew68
    @jazzbrew68 4 місяці тому +2

    I am in the process of learning Power Automate Desktop and your videos have been extremely helpful. Thanks for what you are doing for the community. Side note - you have an very calming voice!

    • @andersjensenorg
      @andersjensenorg  4 місяці тому +2

      Hey Jazz, thanks a ton for the nice comment - I'm glad to play a little role in your learning journey 😊 Kind regards, Anders

  • @JerryEduardo
    @JerryEduardo 5 місяців тому +1

    I started doing my flows two months ago watching your videos. Thank you very much for your teachings and your patience in teaching.

    • @andersjensenorg
      @andersjensenorg  5 місяців тому

      Hey Jerry, I'm so glad to hear - I try to do a mix of beginner and advanced stuff, so expect some different videos in the coming months 😊 Kind regards, Anders

  • @skjones91199
    @skjones91199 5 місяців тому +2

    Hey Anders! Watching in the U.S. (Indiana). Great video, as always! Finishing your PL-500 playlist to help prepare for the test in a couple of weeks! Thanks again!

    • @andersjensenorg
      @andersjensenorg  5 місяців тому +1

      Hey skjones, thank you so much 😊 The PL-500 playlist could be a lot better, I just didn't had the time to finish it, sorry. Kind regards, Anders Ps. Advanced PAD videos coming soon!

    • @skjones91199
      @skjones91199 2 місяці тому

      @@andersjensenorg I earned the PL-500 cert in June! Your material was very helpful in my studying! Thanks so much!

  • @philippkowalski1105
    @philippkowalski1105 3 місяці тому +1

    😁awesome video, Anders. What a great addition to the automation and data arsenal. You're one of my goto teachers.

    • @andersjensenorg
      @andersjensenorg  3 місяці тому

      Hey Philipp - thank you so much 🥷😍 Kind reards, Anders

  • @grzegorzzielinski1263
    @grzegorzzielinski1263 5 місяців тому +1

    Very informative and inspiring. Keep up the good work, Anders.

  • @pthree9449
    @pthree9449 4 місяці тому +1

    Thank you so much for sharing :) , Small suggestion...can you please increase screen size. It will help us to see clearly.

    • @andersjensenorg
      @andersjensenorg  4 місяці тому

      Thank you so much for the nice comment. The video is available in anything up to 4K. Can you click the cog wheel on the video and increase the solution? I just tried it on both my 4K setup and on a 720p laptop. Kind regards, Anders

  • @furkansimsek33
    @furkansimsek33 5 місяців тому +2

    Thank you so much for sharing :) Can you also make a tutorial, which guide us on how to utilize ChatGPT functions in Power Automate?

    • @andersjensenorg
      @andersjensenorg  5 місяців тому

      Thank you so much 😊 Have you seen this: ua-cam.com/video/cieSRNUykvo/v-deo.html Kind regards, Anders

  • @robertgreen5842
    @robertgreen5842 2 місяці тому +1

    Thank you, Anders. Is it possible to search a website to look for a string and then write back if the string has been found or not?

    • @andersjensenorg
      @andersjensenorg  Місяць тому

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @ajaylearningcentre8898
    @ajaylearningcentre8898 2 місяці тому +1

    Hello 👋 sir u can make short videos around 5 to 10 minutes.. on power automate.. people will love ❤️ them for sure... tiny videos...

    • @andersjensenorg
      @andersjensenorg  2 місяці тому

      Hey Ajay, great suggestion, which I will start to implement. Thanks a lot 😍 Kind regards, Anders

  • @juliofeliu6617
    @juliofeliu6617 3 місяці тому +1

    A question, please 🙏:
    Can the same procedure be used for spreadsheets of google drive ?
    I'm basically trying to do the same thing, but with a spreadsheet hosted in my drive account.
    but I have some problems with it :s

    • @andersjensenorg
      @andersjensenorg  3 місяці тому +1

      Hey Julio, extractly. Either we can work in the UI (not recommended) or we can connect throught he google API. You're more than welcome to post the problem on my discord (100% free) and I'm sure we can help you: discord.gg/iloveautomation Kind regards, Anders

    • @juliofeliu6617
      @juliofeliu6617 3 місяці тому +1

      @@andersjensenorg thx dude 👌

  • @bootattkhoo6531
    @bootattkhoo6531 2 місяці тому

    Dear Anders Sir, can show how to use "Get Empty Cell"? Because currently im facing a problem when Power Automate Desktop fill the excel into SAP, those "Blank" cell Power Automate desktop also copyover to SAP too. But what i want is those "Blank" cell i want to skip instead of copy. Do you have idea?

    • @andersjensenorg
      @andersjensenorg  2 місяці тому

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @austinbright-j3o
    @austinbright-j3o 28 днів тому

    What about the case where the result is not always in the same place and I need to “scroll” and find a specific element containing text. Click the url containing the text. Then scrolling to required information and extract data off that second webpage?

    • @andersjensenorg
      @andersjensenorg  27 днів тому

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders

  • @VIJAY-ou2wu
    @VIJAY-ou2wu 4 місяці тому

    Hey Andreas, I just wanted to know how to extract multiple values/data from web and store it into an excel in the same row??

    • @andersjensenorg
      @andersjensenorg  4 місяці тому

      Hey Vijay, kindly check this: ua-cam.com/video/POfK2A8iWAs/v-deo.html 😊

  • @DEEPAKVERMA-x3m
    @DEEPAKVERMA-x3m 5 місяців тому +1

    hello
    Anders Jensen

    • @andersjensenorg
      @andersjensenorg  5 місяців тому

      Hey and thanks for the greeting 😊 How was the video? Kind regards, Anders

  • @aikikaiparaguay
    @aikikaiparaguay 2 місяці тому +1

    Great Anders, good job, I have a difficulty extracting the data from the capital, this is the message, can you help me please:
    Correlation ID: 9ae77903-19a0-4219-b201-56ff1470fdc5
    Data extraction element not found.: Microsoft.Flow.RPA.Desktop.Modules.SDK.Extended.Exceptions.InternalActionException: Data extraction element not found. ---> Microsoft.Flow.RPA.Desktop.UIAutomation.WebAutomation.Core.DataExtraction.WebExtractionException: Data extraction element not found.
    at Microsoft.

    • @andersjensenorg
      @andersjensenorg  2 місяці тому

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders