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.
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!
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
@@andersjensenorg No I'm using it to try to create a loop for data into Excel and then out again. I have built a loop but I'm just looking for tricks to make it better. I'm currently stuck on how to write data from an Excel table row after row into the same Excel line and then copy the results before I write over it with the second line. Your videos have brought me alot closer to that . Do you have extended power Automate training that I could get through in a week - happy to go paid content if I can stretch to the cost. I'm from Brisbane, Australia.
Hello Anders, your videos are fantastic. Do you have a video that you can recommend to help me with the following: I have an excel list of URLs and want to create a flow that reads each URL from my excel table, then writes the data in the corresponding open columns (e.g. First Name, Last Name, etc.). Do you have a video that shows me how I can accomplish this? Thank you!
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!
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!
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
Hello, nice Video 👍🏼 Can you help me? I created a flow in power automate. Its called "create order". the flow looks like this: A user creates an order in my share point list "create order". He also states his information like company name, address, articles and so on. after that, my flow creates a word document, based on a template word doc. later on, that document is also converted into a PDF. now to the issue: all the information is placed into the doc via quick entry blocks BUT it doesnt do that with paragraphs separating the info, so it looks like (NAME,ADDRESS,ARTICLES) instead of COMPANY ADDRESS ARTICLES Is there a function to separate the info with paragraphs or any other solution?
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 14,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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
![Power Automate Desktop Tutorial for Beginners [2024]](http://i.ytimg.com/vi/B0cHOdBv7Jg/mqdefault.jpg)
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.
dıscord lınk ıs doesnt work sır
This is exactly what I was looking for. Easy to understand without unnecessary information. Thank you!
My pleasure, glad you liked it 😊🙌 Kind regards, Anders
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!
Hey Jazz, thanks a ton for the nice comment - I'm glad to play a little role in your learning journey 😊 Kind regards, Anders
Thank you for an excellent tutorial, your Best Practice tips are very valuable!
1000x thanks for the very nice comment 😊 Kind regards, Anders
I started doing my flows two months ago watching your videos. Thank you very much for your teachings and your patience in teaching.
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
THANK YOU SO MUCH , You save me !!
Congratulations! Very well!! I'm from Brazilian!!
Thanks a lot for the nice comment, kind regards, Anders (from Denmark) 😊
Awesome job. I learned so much. Thank you!
I'm so glad to hear, did you build it all yourself? Kind regards Anders 😊
@@andersjensenorg No I'm using it to try to create a loop for data into Excel and then out again. I have built a loop but I'm just looking for tricks to make it better. I'm currently stuck on how to write data from an Excel table row after row into the same Excel line and then copy the results before I write over it with the second line. Your videos have brought me alot closer to that . Do you have extended power Automate training that I could get through in a week - happy to go paid content if I can stretch to the cost. I'm from Brisbane, Australia.
You are the greatest!!
Thanks a lot, Carlos 🙏🥳🦾 Kind regards, Anders
Very informative and inspiring. Keep up the good work, Anders.
Many thanks 😊 Kind regards, Anders
😁awesome video, Anders. What a great addition to the automation and data arsenal. You're one of my goto teachers.
Hey Philipp - thank you so much 🥷😍 Kind reards, Anders
Hello Anders, your videos are fantastic. Do you have a video that you can recommend to help me with the following: I have an excel list of URLs and want to create a flow that reads each URL from my excel table, then writes the data in the corresponding open columns (e.g. First Name, Last Name, etc.). Do you have a video that shows me how I can accomplish this? Thank you!
Hey Dave, thanks a ton ⭐😎 Yes, I think so: ruclips.net/user/live4zmviNtOFwA I streamed the video 2 years ago. Kind regards, Anders
@@andersjensenorg thank you so much. your video's are amazing!
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!
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!
@@andersjensenorg I earned the PL-500 cert in June! Your material was very helpful in my studying! Thanks so much!
Menyala abangku, sangat bermanfaat..
Thank you so much for sharing :) , Small suggestion...can you please increase screen size. It will help us to see clearly.
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
Thank you so much for sharing :) Can you also make a tutorial, which guide us on how to utilize ChatGPT functions in Power Automate?
Thank you so much 😊 Have you seen this: ruclips.net/video/cieSRNUykvo/видео.html Kind regards, Anders
Hello, nice Video 👍🏼 Can you help me? I created a flow in power automate. Its called "create order". the flow looks like this: A user creates an order in my share point list "create order". He also states his information like company name, address, articles and so on. after that, my flow creates a word document, based on a template word doc. later on, that document is also converted into a PDF.
now to the issue: all the information is placed into the doc via quick entry blocks BUT it doesnt do that with paragraphs separating the info, so it looks like (NAME,ADDRESS,ARTICLES) instead of
COMPANY
ADDRESS
ARTICLES
Is there a function to separate the info with paragraphs or any other solution?
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 14,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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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
@@andersjensenorg thx dude 👌
I am from South Africa
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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??
Hey Vijay, kindly check this: ruclips.net/video/POfK2A8iWAs/видео.html 😊
Hello 👋 sir u can make short videos around 5 to 10 minutes.. on power automate.. people will love ❤️ them for sure... tiny videos...
Hey Ajay, great suggestion, which I will start to implement. Thanks a lot 😍 Kind regards, Anders
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
hello
Anders Jensen
Hey and thanks for the greeting 😊 How was the video? Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders