How to use Excel in Power Automate Desktop

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

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

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

    Your speak speed is perfect this time. Thanks for sharing 👍👍👍👍👍

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

      Hey Kebin. Haha, thanks a lot :) Kind regards, Anders

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

    Anders! You are genius and a God send man. This is content I feel like I should be paying thousands of dollars for. This is so incredible.

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

    Anders, a very sincere thank you! Your tutorials are great. As someone who easily gets overwhelmed with technology, your calm approach really helps me!

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

      Thanks a lot, Dan - your comment is highly appreciated 🙂 Recently, in a podcast, I got asked what my teaching style was and I answered teaching in layman's terms. Have a great day. Kind regards, Anders

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

    Anders, I got to say - You and your work are AMAZING! Thank you so much for putting this and the other videos up.
    If I could, I would like your videos a billion times over.

  • @andersjensenorg
    @andersjensenorg  4 года назад +4

    Do you want to learn Microsoft Power Automate Desktop? Then check the full course here: ruclips.net/p/PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw Let me know, if you have any questions to the above videos or suggestions for new topics 😊

  • @Maynardjones100
    @Maynardjones100 3 года назад +5

    Just a little tip. When passing text from the ExcelData variable to the notepad or to any other application, if you get the error “Argument text must be encrypted value” you need to take ExcelData variable, encrypt it with AES, that will generate a variable called EncryptedData. Take that one, decrypte it, and then you will get a DecryptedData variable, this is the one you will pass as text. It’s weird but it worked for me. Other than that, great tutorial, thanks!

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

      Hey Manuel. Thanks a lot :) If you spot anything else, I can improve, please let me know (I'm away until late August though). Have a great weekend. Kind regards, Anders

  • @RahulPandey-mc9vk
    @RahulPandey-mc9vk 2 года назад +1

    You are a genius, creating content to help the people who don't know anything about programming. Keep it up man. GBU

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

      Thanks a lot, Rahul - and for attending today's session. Kind regards, Anders

  • @SS-zi3ky
    @SS-zi3ky 3 года назад

    Excellent video, audio speed is good!

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

      You're very welcome, S S - your support helps me a lot 😍

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

    Fantastic, Anders....I am really astonished after seeing this magical tool of Microsoft, and really you demonstrated very well, after watching your video I purchased licenced version of Power Automate ..Thumbs up..1 Million likes...:)

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

      Hahah hey Tariq - what a fantastic message to receive. Thanks a lot :) Kind regards, Anders

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

      @@andersjensenorg Just one question Andres, i saw ur video of Ui path as well, in ur opinion which tool is best power automate desk or ui path....?

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

    Super helpful! You're one of my go-to guys on Power Automate Desktop tutorials.

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

      Hey A skeptical Human. Thanks a lot. I'm back in August, where I will try to make new videos around PAD :) Kind regards, Anders

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

    Hi Anders, thanks for your videos. now i can use and implement this powerful tool for my own.
    Please make some more videos for more posibility to use this app :)
    Best regards
    From Indonesia

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

      Thanks a lot, Julis Suryadi 🤗 Your feedback helps me immensely. Kind regards, Anders

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

      @@andersjensenorg I still wonder why excel files generated from PAD cannot directly read by excel.
      I have to upload it to Google drive and open as Google sheet file to show the content. If not, excel file is only blank when I try to open it. I use office365

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

    Thank you so much for the vedios.
    Please keep educating us...🙏🙏

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

      Hey Farhan. Thanks a lot :) I love these comments, keep them and questions coming. Kind regards, Anders

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

    Very useful - thanks - and not talking too fast (even on x2!)

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

      Thanks a lot. Haha, great - I hope that doesn't mean it's too slow 😀

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

    This is a top video Anders. Great work, thanks. This and Kevin Stravert are the 2 best videos I've seen for PAD so far. Keep up the great work 👍

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

      Hey Jamie. Thanks a lot and for comparing me with Kevin. I'll improve my sound and visuals during the next 3 months and then I'll start to do a lot of PA/PAD :) Have a great day. Kind regards, Anders

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

    This was so helpful! Thank you.

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

      Hey Deborah. Thanks a lot 😊 Kind regards, Anders

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

    Loving these videos. Your pace is spot on. Cool that you capture a lot of nice features in one use case. Great work!

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

      Hey Richard. Thanks a lot, I'll try to be back with a series of PAD videos very soon 😊 Kind regards, Anders

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

    thanks sir. you have saved me tons of time

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

      Thank you, Mohd - Have you started PAD this week after the news? Kind regards, Anders

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

      @@andersjensenorg yes i have. And i think its gonna save us time n minimize misscommunication big time... What news may i ask?

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

    Instruction speed is perfect

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

      Thanks a lot, Paul. I've improved the sound quality from back then though 🙂

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

    Nice video. Very good explanation. Thank you so much

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

      Hey Prasad. Thank you very much 😊 Kind regards, Anders

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

      @@andersjensenorg Great Demo Anders, worth to see and follow..Do you have a demo for getting submitted data from a Power Form and notify via a V2-Email action using the Power Automate Desktop (Not the online Power Automate) ?. I am familiar with the Online , but I am new with the Desktop vesrion..Thanks allot...Adam

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

    Really helpful tutorial, thanks Anders

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

      Thanks a lot, Jul - these comments mean a lot to me. Kind regards, Anders

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

      Dear Anders, do you know how to use excel on line with power automate desktop?

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

    Very helpful! Thx a million.

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

      Thank you, Jan 🤩 I'll try to make a few more after the great Microsoft news 🙂

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

      @@andersjensenorg indeed, with PAD now open to more or less everyone, your videos might get quite a bit of extra traction 😁

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

    Great, thank you so much!

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

      Hey Truong. You're very welcome. Have a great weekend. Kind regards, Anders

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

    Very informative video, brother. Can you please do a video on how to copy and paste data from one Excel file into a corresponding excel file template without losing or overwriting the template formatting? I would really appreciate it.

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

      Hey John Shoowa Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders

  • @SamsungA-wv5bh
    @SamsungA-wv5bh 3 года назад +1

    Awesome Video,
    I wanted your advice as to which RPA tool one must learn , Power Automate, Automation anywhere or UIPath?

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

      Hey Samsung. It depends of your goal (job, automating your búsiness, what is your company using etc.): Feel free to join my Discord (discord.gg/d8KQpTUvFD), where we discuss just that 🙂

  • @MrJohnnyjt
    @MrJohnnyjt 3 года назад +4

    Good stuff, I have used 1.25 playback speed which was great for me.

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

      Hey lonut. Thanks a lot! Yeah, for me it's a balance. I talk twice as fast IRL as in the video 😏😀 Have a great day. Kind regards, Anders

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

    Great service Anders! Thank you!

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

      Thanks a lot, Melwyn. I would like to make more soon 🙂

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

    Great video. Does power automate can refresh the power query in excel?

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

      Hey alice Morili
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    Hi, I have a question, suppose we have multiple excel workbook which contains multiple sheets then how to copy all the data from all those Excel and paste in a single excel file using Microsoft Power Desktop Automate. Please help me.
    And yes the quality of your videos are amazing. Thanks

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

      Hey Waquif Raza
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    I got the following error "Parameter 'Text to fill-in': Argument 'Text' must be 'Encrypted value'." - Your videos are great! thanks a lot

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

      Hey aris blan
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    Hello thanks for this nice tutorial. Is it possible to write to an excel sheet that is already opened? Each time I try it it would open another instance of the sheet in read only mode so writing is not possible…

    • @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 5800+ 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders

  • @purushottamw
    @purushottamw 4 года назад +3

    We are waiting for more videos on UI Flow. Related to add data to the website and extract data from the website. Hope you will create the same for us. Thank you again.

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

      Hey 04_AaravWagh_6D, sorry for the late reply. I'm back and will be producing videos by the start of September (Power Automate + Desktop as well). Kind regards, Anders

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

    Hi Anders, thanks for your videos. Love it when you say "that's it". Feels like I get smarter after :)
    Will you be showing any videos on how to filter an excel document, select columns with Power automate desktop, and sending the end file in an email to someone? That would be amazing!

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

      Hey Peter. Thanks a lot 🤗 Yes, for sure. From December 1 this is my full-time job, I will do my best to make videos about everything in Power Automate. Kind regards, Anders

  • @mkappeyne7561
    @mkappeyne7561 4 года назад +3

    Anders regarding the speed at which you talk. RUclips allows you to change the playback speed (slower or faster) in the playback settings (little cog in lower left part of screen). This will allow you to speak normally and allow all users to select their preferred playback speed.

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

      Hey M Kappeyne. Thanks a lot - I'm actually starting to speak at normal speed :) Kind regards, Anders

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

    Nice Video Thank you!

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

      Thank you, Heinrich 🙂 I plan to do a handful more very soon.

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

    Amazing!

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

    Great video Anders. If I can make a suggestion--use an external microphone or a lav mic as you speak very softly and it is hard to hear what you are saying. There is a lot of sound reflection in the room you are recording in. It sounds like you are in a tunnel. Otherwise the content of your video is terrific.

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

      Hey Norm. Thanks a ton! I have thought about it myself and I can simply not find a solution. I've tried improving it here: ruclips.net/video/INnbGPF5MwE/видео.html or is it still the same? Kind regards, Anders

  • @vilera70
    @vilera70 4 года назад +3

    Hello @Anders Jensen, excellent video. One question, following your video "How to use Excel in Power Automate Desktop" when I did the step to populate text field in window, I got the following error message "Argument 'Text' must be 'Encrypted object'." Do you know what is this and how to fix it?

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

      José Antonio García Vilera I got the same error ... have you managed to solve it ?

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

      @@meryemsikouky6117 Hello, no not yet. But still looking. I will update any solution here. If you find it please if you could update it here, I will appreciated.

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

      Hey José Antonio García Vilera
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    Hi, can you make more Microsoft Power Automate Desktop tutorials ? use Excel in Power Automate Desktop to import into the CMR system and more... write to a web page, thank you so much!

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

      Hey Truong. Thank you. Check this: ruclips.net/video/ZznxDB1u-Hs/видео.html Have a great weekend. Kind regards, Anders

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

    Great Video Anders. Too many things I have learnt from this. Thanks a lot. Is it possible for you to do video regarding logging to a external website with credentials, accessing the menu options, download few pdf files as a daily job and logout. Is it possible to do with PAD?

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

      Hey Ramesh. Thanks a ton! Usually we want to split it up and solve the problems one by one. We can do all the things with PAD. Within the next month I will add a handful of more guides to the PAD playlist: ruclips.net/p/PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw Kind regards, Anders

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

    Anders, many thanks for this great tutorial. May I ask, does the ExcelData have a buffer size?
    My data has 145 rows and 26 cols, however data start to become corrupted after row 17.

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

      Hey Phillip, that is 99% not because of the size of your Excel. I've done projects with Excel books with several thousands rows. It's hard to debug on the distance, but you're more than welcome to post your problem on my discord and then we solve it for you: discord.gg/iloveautomation Kind regards, Anders

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

    HI Anders Jensen, Pl's suggest the step to connect application and read the excel from another PC through remote desktop because that PC dont have the Windows 10 to install the Microsoft Power Automate desktop.

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

      Hey Jitendra Patel
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    Hi Anders, 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

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

      Hey Las aventuras de Sharon Agudelo
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    Thanks. Please which tool do you use to develop the "My CRM" application ?

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

      Hey bali. I've took it from the UiPath Acme Demo world. But you can create one in any programming language, e.g. C# 🙂

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

      @@andersjensenorg ok

  • @user-mv3ek7jh8g
    @user-mv3ek7jh8g 3 года назад +1

    Thank you for a great tutorial. About the speaking speed: I guess anyone can adjust the right speed in "settings" :)

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

      Hey 2 - thanks a lot for the nice feedback 🙂

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

    hi andres please do videon on in our office main we will get daily birthday wishes mail so create flow pic up that specific birthday mail along with birthday date and name and insert into excel spread sheet .

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

      Hey Meharaz. Thank you :) At the moment I'm doing a series of Power Automate tutorials. However I havn't added a birthday flow. Kind regards, Anders

  • @DataSpinners
    @DataSpinners 4 года назад +3

    Great vid Anders. I'm getting an error when I populate the text field in window - Argument 'Text' must be encrypted value? Bit odd, but it's stopping me from getting it to work. Any ideas? I had no problem with the sound.

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

      Hey Rory. Thanks a lot! Weird, is it a web field with public access? Then I can take a look. Kind regards, Anders

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

      Hi @@andersjensenorg I think it is becasue in december there was an update. It happens to me also. It appears that will only work with the recorders...

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

      @@andersjensenorg Great video. The populate to text field only seems to work if you encrypt and decrypt it before, for whatever reason. Could that be possible?

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

    Hi Anders, first of all, i want to thank you for your very helpful content! when i tried to follow the steps in the video, in the step of pupulate the text field, PAD shows an error message that said the text should be a encrypted value... it already happens to you? what should i do? thanks again!!!

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

      Hey Kelsson. I'm humbled, thank you and thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

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

    Hello Anders!
    Your video is amazing! Thank you for sharing your knowledge with us.
    I am trying to do this automation, but the following message is shown to me: The 'Text' argument must be 'Encrypted value'. Do you know what I should do to avoid this message? Thanks in advance!

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

      Hey Marcos. Many thanks!! :) Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

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

      You have to Encrypt the value and decrypt the value and decrypted value need to pass.

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

    Thank you for the video. It was helpful. Could you please let us know that, how do we delete the unwanted selectors?

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

      Hey 04_AaravWagh_ 6D
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    If there are multiple tabs in the Excel, can we specify the specific tab we want to read? This feature was there in UiPath, but couldn't find where it is in PAD..

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

      Hey Davis. For sure. You can use the Set active Excel worksheet action 😊

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

      @@andersjensenorg Thank you, Anders :) That worked!

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

    I'd love to see a video that features something like "Top 10 Most Common Power Automate Desktop Errors-And How To Workaround Them", or something to that effect, more concisely titled for RUclips friendliness of course, lol

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

      Hey A Skeptical Human. Yeah, I will work on that, when I get back in August. In the meantime feel free to join my Discord and chat with me and your colleagues around automation: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

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

    Hi, thank you very much for the video.
    how would you do web data extract for product on amazon or Aliexpress ?
    sometimes a product comes with variant, sometimes not
    Thanks

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

      Hey Walid. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

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

      @@andersjensenorg :
      Thank you for the reply. Congratulations for your baby , Enjoy !

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

    Hello congratulations great tutorial. I would like to know if a license is needed to use these tools?

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

      Power Automate Desktop is free for Windows 10 users; they have a paid version with additional features though.

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

      Hey Alexsander da Rosa Costa
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    Thanks for the video. Have you found Control + V? I have not found that so far. Also have you already tried element selection on websites like in uipath?
    I also experience error when trying to add current item to google search bar in browser. Have you done that yet?

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

      Hey Daniel. I hope your're still doing well and sorry for the late reply. Ctrl+v works fine for me? The UI actions have gotten a lot better the last month, let me know if you still face the problem. I really want to make a video on UI automation, but very busy at the moment :( Kind regards, Anders

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

    Hello! Great tutorial, thank you for sharing!
    By any chance, do you know how I can use Power Automate to transfer data from one Excel file to another? I am constantly updating a particular excel file for a item category and would like the data to be transferred into another excel file where its a consolidation of all information of all the items in my company. Would like to reduce the manual process of copy and pasting of the data.
    Thank you so much! :)

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

      Hey Vick Tan
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    can I have always copy half of the rows with data?
    I have an very tedious csv upload I have to do, it would be very cool if Power Automate could help

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

      Hey Saibot
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    Cool!

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

      Hey Zeng, thanks a lot :) Kind regards, Anders

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

    👍👍👍👍👍👍👍

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

    Nice tutorial, but your voice is so relaxing I'm falling asleep...

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


    ﴿إِنَّ اللَّهَ وَمَلائِكَتَهُ يُصَلُّونَ عَلَى النَّبِيِّ يَا أَيُّهَا الَّذِينَ آَمَنُوا صَلُّوا عَلَيْهِ
    وَسَلِّمُوا تَسْلِيمًا﴾

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

    Anders, thank you very much for such insightful video! Would love to see more videos from you on Power Automate Desktop!
    Do you know is it possible to make a reference to a whole column by the header name from the first row or column index?
    I've applied Read data from Excel to my data (from column 1, row 1 until last column and last row) and now would like to refer to the whole column, which name is "Test" (Test is a text in B1 cell).
    I've figured out how to get an access to the whole row, for instance: %ExcelData[1]%, to a specific cell %ExcelData[1][2]%, but don't know how to get a column: %ExcelData[][2]% has a syntax error, %ExcelData[2]% will refer to the second row, not a column and %ExcelData['Test']% gives an error message: " Variable 'ExcelData' doesn't have a property 'Test' ".
    Thank you!

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

      Hey Sergii Zelenko
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    Whats the difference between this and winautomation? Most actions look similar if not the same

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

    Hi Anders, If a file Excel Contains 3 sheets, and we want to take data from "Sheet2" without touching "Sheet1" and "Sheet3".
    How we can do ?

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

      Hey Hung. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

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

    Hey where can I get the My CRM app from?

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

      Hey Alfred Pereira
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    This method reads active sheet .How to read specific sheet eg (sheet2) of an excel

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

      Hey shubham jaiswal
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    In desktop automate , one email have multiple data to crop. I am able to successfully crop (using flag between two text) only first set of data. I not able to crop the next ...set of text data in that same email. How to do that?

    • @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 7000+ 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders

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

    How to use the run excel macro?

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

      Hey Secret Santa. Create your macro in an Excel book. Then call it with Run Excel Macro and there you go :) Kind regards, Anders

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

    6:12​ Populate text field in window, når jeg gør dette får jeg denne fejl: Parameter 'Tekst til udfyldning': Argument 'Text' skal være 'Krypteret værdi'. Hvad gør jeg forkert? Gør nemlig hvad du gør :-) Vh

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

      Hey Frederik. Fedt med en dansker der ser mine videoer :) Uha, den er svær - prøver du at indtaste bogstaver i et felt, der kræver et nummer? Er det en variabel du bruger? Hvis ja, kan du prøve at hardcode den i stedet (dvs. skriven din tekst/dit nummer direkte i stedet for at bruge en variabel). Du kan bare svare her el. også er der et link til min discord på hovesiden, hvis du vil sende screenshot. Mvh Anders

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

    How do you set it to read from a specific excel sheet that may not be the active sheet in a workbook?

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

      You can activate a sheet by the name or index

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

      Hey J Wardlaw. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

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

    how do i create a flow to open excel, hit refresh all, wait for the refresh to complete, then save and close?

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

      Hey Dallas. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

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

    Hi anyone tell me how can i print the rows of excell sheet by using Ms power automate desktop ?
    tell me its urgent

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

      Hey Faizan Asghar Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html Have a great day. Kind regards, Anders

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

    Du skal gøre noget ved den klik lyd fra musen. Det forstyrre alt for meget.

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

      Hej Bj M. Tak for rigtig god feedback. Jeg kan godt lide at optage "live", da jeg så får sagt alle de ting, jeg vil og det bliver mest autentisk. Jeg har købt en ny mic og den har jeg brugt i de 10 seneste videoer. Lad mig vide, hvad du synes. Mvh Anders

  • @russellconnerjr.5475
    @russellconnerjr.5475 4 года назад

    How do you duplicate an entire Power Automate Desktop flow and have it include all UI Elements and variables?

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

      Hey Russel. I'm not sure, what you want. Do you want the flow to be copied, so you can use it e.g. on another machine? Kind regards, Anders

    • @russellconnerjr.5475
      @russellconnerjr.5475 4 года назад

      Anders Jensen thanks for getting back to me.
      Yes. I would like to simply duplicate the entire flow for use on another machine or have a template to add on to or adjust for other similar projects that require a lot of the same steps but not all of them.

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

    my crm login(sample App) ??

    • @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 5800+ 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders

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

    my crm l(sample App) ??

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

      Hey alam afsar
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: ruclips.net/video/_QRI-Yo2h8U/видео.html
      Have a great day.
      Kind regards,
      Anders

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

    Thanks for sharing
    Can we get microsoft certified for this course
    Can share
    Kjobless right now

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

      Hey megadisc1982. At the moment no, but I think it will come in a couple of months. I would definately start to get good at it, since I think it will pass the likes of UiPath, AA etc. Let me know, if you have questions in the process. And good luck with the job situation. Kind regards, Anders

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

    This does not work! all of the information doesn't populate onto the notepad

    • @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 4900+ 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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders

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

    This task would be written in python. Faster.

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

      Impressive if you can do it 😄 How about this in Python: ruclips.net/video/WXK0u2yXLrU/видео.html

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

    I could barely hear. May be your mike was too far.

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

      Oh no, Tanvir 😔 Can you try with another device? Otherwise let me know, I find the copy for you. Kind regards, Anders

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

    Audio is not good

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

    You could learn to pronounce the word "current".

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

      Haha, you're probably right, Chuck. My English is only my 3rd language. I promise I'll use it better next time. Thanks for the feedback. Kind regards, Anders