hi Anders, Thank you for the video. I am trying to launch outlook using power automate but it throws an error. Outlook failed. I have outlook installed on my system. Could you pls give some insight on same.
Anders, you have saved my bacon. I am overloaded with cases already, and we just lost the only other attorney in my department, and all her cases have been assigned to me. My IT guys sent out 300 docusign emails, but when they came back, I had 300 emails with no identifying information in them, and 300 each of Attachment1, Attachment2, Attachment3, and Attachment4 (with no external indication of who the client was.) Thanks to you, I was able to iterate through the mail, extract the data from the PDF attachments to identify the client and re-save the attachments with the client name catted to them, and then do real work. What would have been a two week project was done in a day. Thank you. THANK YOU. I have now subscribed to your channel and I plan on following along on ALL your tutorials.
Hey goodluckfox. Thanks a lot for the nice words, highly appreciated 🙌😍 Have you seen this beginners guide: czcams.com/video/qfpHqfp2R3Y/video.html, where we'll also go advanced in the end? Kind regards, Anders
Another great tutorial i am now using this for my project emails as there are many and using Excel can filter by date to ensure that i have received all replies to my questions thanks again 👍
Hey shaun. Thanks a lot for the feedback. I'm so happy to hear 😊 Please let me know, if you have any topics, you want to see in the coming videos. Kind regards, Anders
Hi Anders, congratulations on the video. A suggestion would be to rename the file with an increment (name + 1) or with the date (hour, minute and second) to gather all the attachments in the same folder.
Thanks a bunch, @PitakYT 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: czcams.com/video/xWFz-S96XGo/video.html You're more than welcome. Kind regards, Anders
Hi Anders .... You have no idea how helpful this video was in our organization and I'd like to say how greatful I'am to watch this, it was the actual process we wanted so we can process the email body on our own from excel. I have only 1 issue after running it.. The headers (Date, From, ...) appeared from EmailData - variable value reflected on the first row of Excel. I would appreciate if you could help me out Thanks
Thanks a ton, Pankaj Narula 🤩 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Thanks a lot, Yoseph Teshome 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders, Thanks for the great video. I did find a few problems which I have managed to solve, but they may have affected other subscribers. So here are the problem and solution: 1) I am using an IMAP outlook account. This did not retrieve emails until we set the Retrieve email path to Inbox/PAD The backslash did not work. 2) The email retrieval crashed and only did one mail. Solution: I found the email from Stine Høiberg Rasmussen, which caused the problem because of the special character in his name. Where could I get the instructions on how to Scrap information from the body text. I do not need the entire text only specific information. All the Body Texts have the exact same layout with only the person's name and number changing. I will post this on Discord as well. :)
I love your video/teaching style! This content isn't exactly what I'm searching for though... I'm trying to find a tutorial for consolidating the emails within many subfolders into one folder in Outlook. I tried to capture the actions using the record feature of power automate desktop, but it wants to recreate the specific folders I used in my recording. Whereas I want it to continue on and do those actions for all the subfolders within that Outlook folder.
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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.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 12,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders Thank you for all of your excellent videos. Do you have a video to show how to extract specific information from the "body" text of the email? The email has content in it such as the client's Name and a customer number. I would like to place that in the excel file in a separate column. Appreciate your help.
Hey Robin. I would look at Regular Expressions (RegEx), I do it on PDFs in this step-by-step video: czcams.com/video/SySI75hYHOU/video.html Kind regards, Anders
Hello, what version of PAD did you use in this video? I cannot insert a row in Excel the way you do, and that is why my flow does not perform as intended. Thank you.
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
I want to thank you for your tutorials on PAD, I just recently discovered that you can scrap webpages and find it fascinating not to mention the power PAD has. I do have a question for you. I’m retired now and I like to tinker around the house repairing stuff. Ultimately I use the internet to help me troubleshoot the problem. I then do a google search for the part number that needs replacing. This is when it gets hard. You see the results that come back include many items that do not relate exactly to the part number I’ve entered. I only want to save the URL if the text description contains my exact part number and then go on to the next entry and the next page etc. I thought that this type of problem would be covered by someone’s tutorial but I can’t seem to find one. Your tutorial using the “Tesla model X”, could it be modified to only want those model X cars that are painted red and then obtain the registration? I believe I can take it from there. Thanks again for your hard work and great tutorials.
Hey Glenn. Thanks for the nice words 😊 Let me solve the problem for you in a video. I need the page, where you're searching and a part number. Kind regards, Anders PS. ETA is a week or two.
@@andersjensenorg Sorry for the delay. I responded to your request last night but I must have done something wrong because my reply example disappeared. So let me try again. If this doesn’t work I’ll start a new thread. The goal. Have an excel worksheet with two columns. Column one will have the part number, this will also confirm the correct number was scraped. Column two will have the URL,s for me to click on. The URL’s should only be domestic not foreign (.com.XX). The example. Launch Firefox and enter DA41-00670A in the google search box located on the Menu Bar. For me Google returns four pages of results. Page 1. For me, the first return shows the title without the part number so the body of text will have to be interrogated to see if the part number is there. The 4th item shows the part number in the title but without the dash (DA4100670A) but shows up correctly in the body of text. I go to the bottom and click on “Next”. Page 2. Google now shows five pages of results. Item eight on page two is a foreign site (www.desertcart.in ) and is not desired. The remaining results look good. I go to the bottom and click on “Next”. Page 3. Item three is foreign (.com.ve) and is not desired. The rest we know about. I go to the bottom and click on “Next”. Page 4. The last two items are obviously foreign but I can’t see how to eliminate them. I go to the bottom and click “Next”. Page 5. The final results have all been logically handled before. I hope I have covered this example to your satisfaction and look forward to what you can do. I believe your tutorial on this subject will help those who want to selectively scrap search results. Thanks and I look forward to more of your tutorials.
Hi Anders and thanks a lot for your amazing videos! I'm learning a lot! I have an issue opening the Emails file after the robot runs: Excel starts but it appears blank and no data is displayed. The file preview is available and I can see here it worked properly. If I try to let I work again it stops when opening the file. Same issue with the Excel files created after WEB Scraping Data from Amazon Any idea what is wrong with them?
Hey Marco Bacchetti 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: czcams.com/video/_QRI-Yo2h8U/video.html Have a great day. Kind regards, Anders
Hi Anders. Thanks so much for you video. I practiced as your video. However, in case 2 emails have some attachments with the same name. It auto created number file name at the end . So, is there any way to handle it?
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 8000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Thank you very much for this video. Very interresting. Is it possible to have a preview of the attachment in the excel table instead of the name of the attachment (in the last column) ? Karin Thiry
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi , first of all many thanks for your help - I'm following your guides for some time , I have a question in regards to above training is there a way to extract only excel attachments ?
Hey Martha. Thanks a lot. Yes, retriece them, loop them where you ask which extension they have (.xlsx) and then you can work with them. I hope it helps, else you're more than welcom in my discord community, where we can help you (it's 100% free). Kind regards, Anders
Hello Anders, Would it be possible to, instead of writing this off in a local Excel file, use a POST API call to send this data to be stored in a database on a company's intranet? Thank you in advance, and thank you very much for the informative videos 😊
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders ! I hope, You are doing. Could you please suggest. How we can interact Shared outlook mail box by Power Automate Desktop. As I am trying at my end by Power Automate Desktop. However, Unable to resolve.
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 8000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Anders I have an other problem here, your instructions are clear it's most likely a small issue, sitting on a Swedish installation and PDA says it can't find my "inbox" nor "Inkorg" and it gets stucked of course, do you have any smart tip? Thanks for putting in all your effort in this tutorials.
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 12,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): czcams.com/video/xWFz-S96XGo/video.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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.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 12,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders.... I've passed all previous lessons, and I really like this course. However in this one I've encountered a problem I couldn't solve completely. I was always getting an error message in line where creating folder for attached files, saying that my "x:\...\....\OutlookProject\Attachments" folder does not exist, although it exists. I've solved problem partly moving whole project folder to root of drive, but I'm curious about the reason. My question is, do you know if PA maybe has some of limitation on pathname's length, because with shorter (D:\OutlookProject) everything worked fine? Tnx in advance. 🙂
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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders, I need your help in resolving an issue I am facing. Need to have multiple subject texts(like daily or weekly & country as well), because I have multiple lists to get filtered in the email subject. Please respond to me asap.
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders, When I fill in the 'From contains: ' field in 'Retrieve email messages..' action, the flow does not seem to download the attachments for emails from that email ID. But if I suppose, fill in the 'Subject: ' field with keywords to look for, the flow runs as it is supposed to. Any idea why this is? And is there a way I can get emails from one particular email ID?
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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.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 8000+ 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): czcams.com/video/xWFz-S96XGo/video.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 11,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): czcams.com/video/xWFz-S96XGo/video.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 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders: "From contains" works fine when it's a 'common' email, but it fails when it's an exchange account. Need help on how to filter mails based on from address
Hey Chaitanya Chunduru 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: czcams.com/video/_QRI-Yo2h8U/video.html Have a great day. 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 12,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
is it possible to reply an email (retrieved messages to multiple recipient?) so that in each email it should have recipient name i.e Dear Anders and so on...
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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
"When I tried to run the solution after step 3, I got a "runtime error" alert, possibly because I ran the solution for my entire inbox. What can I do to make this work?"
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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.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 11,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): czcams.com/video/xWFz-S96XGo/video.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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hey Second none. Did you put in the name of the folder you're retrieving the mails from? If yes, does it work with another folder? Kind regards, Anders
@@andersjensenorg I did. So it seems that if I have it search someone's email in our organization from the "From contains:" section, it doesn't see their emails addresses the way it should. They show up as an LDAP path.
Hey Jeffrey. I just tried to download the course materials, and it seems like the attachments folder is empty? And thanks for the update, glad you sorted it 😊🙌❤ Kind regards, Anders
Everything is running smoothly, but when I try to open up the excel document with the information it opens up but Everything is blank. Like I see all the tabs like file, home, insert, etc... but it's just white nothingness under it.
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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Launching of outlook giving error: Requesting you to explain Correlation Id: 9fc8df18-7078-4c3f-ad59-03d3007e5b0c Value cannot be null. Parameter name: type: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Failed to launch Outlook ---> System.ArgumentNullException: Value cannot be null. Parameter name: type at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.Activator.CreateInstance(Type type) at Microsoft.Flow.RPA.Desktop.Modules.Outlook.Actions.OutlookActions.LaunchOutlook(Variant& outlookInstance) --- End of inner exception stack trace --- at Microsoft.Flow.RPA.Desktop.Modules.Outlook.Actions.LaunchOutlook.Execute(ActionContext context) at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
"When I tried to run the solution after step 3, I got a "runtime error" alert, possibly because I ran the solution for my entire inbox. What can I do to make this work?"
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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
![Power Automate Desktop Tutorial for Beginners [2024]](http://i.ytimg.com/vi/B0cHOdBv7Jg/mqdefault.jpg)
![Power Automate Desktop Tutorial for Beginners [2024]](/img/tr.png)
Please give the video a thumbs up if it helped you.
Thank you 🙌😊
Power Automate for website please
hi Anders, Thank you for the video. I am trying to launch outlook using power automate but it throws an error. Outlook failed. I have outlook installed on my system. Could you pls give some insight on same.
This is the only video I could find that shows how to use the desktop version of Power Automate - Great video!
Your support means a lot, thank you for watching and leaving a positive comment ❤️😊
Anders, you have saved my bacon. I am overloaded with cases already, and we just lost the only other attorney in my department, and all her cases have been assigned to me. My IT guys sent out 300 docusign emails, but when they came back, I had 300 emails with no identifying information in them, and 300 each of Attachment1, Attachment2, Attachment3, and Attachment4 (with no external indication of who the client was.) Thanks to you, I was able to iterate through the mail, extract the data from the PDF attachments to identify the client and re-save the attachments with the client name catted to them, and then do real work. What would have been a two week project was done in a day. Thank you. THANK YOU. I have now subscribed to your channel and I plan on following along on ALL your tutorials.
Hey goodluckfox. Thanks a lot for the nice words, highly appreciated 🙌😍 Have you seen this beginners guide: czcams.com/video/qfpHqfp2R3Y/video.html, where we'll also go advanced in the end? Kind regards, Anders
Another great tutorial i am now using this for my project emails as there are many and using Excel can filter by date to ensure that i have received all replies to my questions thanks again 👍
Hey shaun. Thanks a lot for the feedback. I'm so happy to hear 😊 Please let me know, if you have any topics, you want to see in the coming videos. Kind regards, Anders
thanks, man! keep up the excellent work, the views will eventually increase
Hey Kyan, I'm so glad you liked it 😊 Have a great day. Kind regards, Anders
Hi Anders, congratulations on the video. A suggestion would be to rename the file with an increment (name + 1) or with the date (hour, minute and second) to gather all the attachments in the same folder.
Hey Sandro - you're 100 % right and a great approach, thank you 😊
Thank you so much, This is excellent videos. I'm learning a lot from your channel. 👍👍👍🙏🙏🙏
Thanks a bunch, @PitakYT 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: czcams.com/video/xWFz-S96XGo/video.html You're more than welcome. Kind regards, Anders
It's really helpful to my daily tasks... Also Please do the session on database automation on PAD.. Love u Always❤❤❤Thanks in advance !!!
Hey Jamalapurapu. Thanks a ton 😍 A video about SQL automation in PAD is in the pipeline!! Have a great day. Kind regards, Anders
Many Thanks Anders, Great content. I would like to see more Videos :)
Thank you, Roberto. A lot of new Power Automate videos are in the pipeline. Have a great day 😊
Hi Anders .... You have no idea how helpful this video was in our organization and I'd like to say how greatful I'am to watch this, it was the actual process we wanted so we can process the email body on our own from excel. I have only 1 issue after running it.. The headers (Date, From, ...) appeared from EmailData - variable value reflected on the first row of Excel.
I would appreciate if you could help me out
Thanks
Thanks a ton, Zdahn 😊 I don't understand the question, can you please post a screenshot on my Discord? Then we solve it for you. Kind regards, Anders
your videos are amazing - thank you
Hey ScheduleLogicReader. Thanks a lot 😊 Have a great day. Kind regards, Anders
I appreciate it very much! It is very useful, thank you
Thanks a ton, Pankaj Narula 🤩 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Thanks so much, it is so helpful.
Thanks a lot, Yoseph Teshome 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders,
Thanks for the great video.
I did find a few problems which I have managed to solve, but they may have affected other subscribers. So here are the problem and solution:
1) I am using an IMAP outlook account. This did not retrieve emails until we set the Retrieve email path to Inbox/PAD The backslash did not work.
2) The email retrieval crashed and only did one mail.
Solution: I found the email from Stine Høiberg Rasmussen, which caused the problem because of the special character in his name.
Where could I get the instructions on how to Scrap information from the body text. I do not need the entire text only specific information. All the Body Texts have the exact same layout with only the person's name and number changing.
I will post this on Discord as well. :)
Hey Robin. Thanks a lot for the clarification 🙌❤️ Highly appreciated. Kind regards, Anders
Another great video! Thanks.
My pleasure, Nilangi 😊
Thanks!
Another excelent video. Obrigado.
Many thanks 🙌😍 Kind regards, Anders
Thanks once again
My pleasure, have a great day 😊
I love your video/teaching style! This content isn't exactly what I'm searching for though... I'm trying to find a tutorial for consolidating the emails within many subfolders into one folder in Outlook.
I tried to capture the actions using the record feature of power automate desktop, but it wants to recreate the specific folders I used in my recording. Whereas I want it to continue on and do those actions for all the subfolders within that Outlook folder.
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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Awesome 👏🏾💎
😍😍😍My pleasure
great boss
Thank you for this nice video. Please How can I retrieve a table that is in the body of the mail ?
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 12,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders
Thank you for all of your excellent videos.
Do you have a video to show how to extract specific information from the "body" text of the email?
The email has content in it such as the client's Name and a customer number. I would like to place that in the excel file in a separate column.
Appreciate your help.
Hey Robin. I would look at Regular Expressions (RegEx), I do it on PDFs in this step-by-step video: czcams.com/video/SySI75hYHOU/video.html Kind regards, Anders
Hello, what version of PAD did you use in this video? I cannot insert a row in Excel the way you do, and that is why my flow does not perform as intended. Thank you.
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
I want to thank you for your tutorials on PAD, I just recently discovered that you can scrap webpages and find it fascinating not to mention the power PAD has.
I do have a question for you.
I’m retired now and I like to tinker around the house repairing stuff. Ultimately I use the internet to help me troubleshoot the problem. I then do a google search for the part number that needs replacing. This is when it gets hard. You see the results that come back include many items that do not relate exactly to the part number I’ve entered. I only want to save the URL if the text description contains my exact part number and then go on to the next entry and the next page etc.
I thought that this type of problem would be covered by someone’s tutorial but I can’t seem to find one. Your tutorial using the “Tesla model X”, could it be modified to only want those model X cars that are painted red and then obtain the registration? I believe I can take it from there.
Thanks again for your hard work and great tutorials.
Hey Glenn. Thanks for the nice words 😊 Let me solve the problem for you in a video. I need the page, where you're searching and a part number. Kind regards, Anders PS. ETA is a week or two.
@@andersjensenorg
Sorry for the delay. I responded to your request last night but I must have done something wrong because my reply example disappeared. So let me try again. If this doesn’t work I’ll start a new thread.
The goal.
Have an excel worksheet with two columns. Column one will have the part number, this will also confirm the correct number was scraped. Column two will have the URL,s for me to click on. The URL’s should only be domestic not foreign (.com.XX).
The example.
Launch Firefox and enter DA41-00670A in the google search box located on the Menu Bar.
For me Google returns four pages of results.
Page 1. For me, the first return shows the title without the part number so the body of text will have to be interrogated to see if the part number is there.
The 4th item shows the part number in the title but without the dash (DA4100670A) but shows up correctly in the body of text.
I go to the bottom and click on “Next”.
Page 2. Google now shows five pages of results.
Item eight on page two is a foreign site (www.desertcart.in ) and is not desired.
The remaining results look good. I go to the bottom and click on “Next”.
Page 3. Item three is foreign (.com.ve) and is not desired. The rest we know about. I go to the bottom and click on “Next”.
Page 4. The last two items are obviously foreign but I can’t see how to eliminate them. I go to the bottom and click “Next”.
Page 5. The final results have all been logically handled before.
I hope I have covered this example to your satisfaction and look forward to what you can do.
I believe your tutorial on this subject will help those who want to selectively scrap search results.
Thanks and I look forward to more of your tutorials.
Thanks for the video but can you help me for the course material cause i cant download from your website. The website can't be reach. Thank you
Hi Anders and thanks a lot for your amazing videos! I'm learning a lot!
I have an issue opening the Emails file after the robot runs: Excel starts but it appears blank and no data is displayed.
The file preview is available and I can see here it worked properly.
If I try to let I work again it stops when opening the file.
Same issue with the Excel files created after WEB Scraping Data from Amazon
Any idea what is wrong with them?
Hey Marco Bacchetti 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: czcams.com/video/_QRI-Yo2h8U/video.html Have a great day. Kind regards, Anders
Hi Anders. Thanks so much for you video. I practiced as your video. However, in case 2 emails have some attachments with the same name. It auto created number file name at the end . So, is there any way to handle it?
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 8000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Very cool again
Thank you so much 🙂
Thank you very much for this video. Very interresting. Is it possible to have a preview of the attachment in the excel table instead of the name of the attachment (in the last column) ? Karin Thiry
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi , first of all many thanks for your help - I'm following your guides for some time , I have a question in regards to above training is there a way to extract only excel attachments ?
Hey Martha. Thanks a lot. Yes, retriece them, loop them where you ask which extension they have (.xlsx) and then you can work with them. I hope it helps, else you're more than welcom in my discord community, where we can help you (it's 100% free). Kind regards, Anders
Hello Anders,
Would it be possible to, instead of writing this off in a local Excel file, use a POST API call to send this data to be stored in a database on a company's intranet?
Thank you in advance, and thank you very much for the informative videos 😊
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders ! I hope, You are doing.
Could you please suggest. How we can interact Shared outlook mail box by Power Automate Desktop.
As I am trying at my end by Power Automate Desktop. However, Unable to resolve.
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 8000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Any suggestions on above query
Anders I have an other problem here, your instructions are clear it's most likely a small issue, sitting on a Swedish installation and PDA says it can't find my "inbox" nor "Inkorg" and it gets stucked of course, do you have any smart tip? Thanks for putting in all your effort in this tutorials.
Hey True Viking. I honestly don't know 😔 I always have my WinAutomation/PAD in English. Kind regards, Anders
@@andersjensenorg I think the problem might be in outlook then cause PDA is in English
@@truewiking That might be the case; you're more than welcome to post the problem at my Discord - the link is in the description 😊
@@andersjensenorg thank you very much for your offer, solved it by putting a * in the "from" field, wish you a nice day
@@truewiking Nice 😊
Hi Anders, can you please make a video that How to send multiple email attachments in outlook in one go through Power automate desktop
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 12,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi. How should I extract specific information in the body of the email?
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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Is it possible to read 1 email at a time in PAD?
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 12,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders.... I've passed all previous lessons, and I really like this course. However in this one I've encountered a problem I couldn't solve completely. I was always getting an error message in line where creating folder for attached files, saying that my "x:\...\....\OutlookProject\Attachments" folder does not exist, although it exists. I've solved problem partly moving whole project folder to root of drive, but I'm curious about the reason.
My question is, do you know if PA maybe has some of limitation on pathname's length, because with shorter (D:\OutlookProject) everything worked fine?
Tnx in advance. 🙂
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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders,
I need your help in resolving an issue I am facing. Need to have multiple subject texts(like daily or weekly & country as well), because I have multiple lists to get filtered in the email subject. Please respond to me asap.
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders,
When I fill in the 'From contains: ' field in 'Retrieve email messages..' action, the flow does not seem to download the attachments for emails from that email ID. But if I suppose, fill in the 'Subject: ' field with keywords to look for, the flow runs as it is supposed to.
Any idea why this is? And is there a way I can get emails from one particular email ID?
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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Can you please guide me. As soon as I insert a data table and try to insert values, the current item variable goes missing.
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 8000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
hi Anders, i want a pic in my email signature, how can i make it? i raised the question on discord. thank you!
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders
As i don't have outlook then how can i do this use cases?
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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Hi Anders: "From contains" works fine when it's a 'common' email, but it fails when it's an exchange account. Need help on how to filter mails based on from address
Hey Chaitanya Chunduru 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: czcams.com/video/_QRI-Yo2h8U/video.html Have a great day. Kind regards, Anders
To save attachments from emails retrieved in Outlook using Power Automate but exclude saving .jpeg attachments?
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 12,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
is it possible to reply an email (retrieved messages to multiple recipient?) so that in each email it should have recipient name i.e Dear Anders and so on...
Hey Noman. Yes, the guide is right here: czcams.com/video/5bHhl1_jVoE/video.html :) Kind regards, Anders
Hi, can we also track to check if the email was responded? Is that possible?
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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
"When I tried to run the solution after step 3, I got a "runtime error" alert, possibly because I ran the solution for my entire inbox. What can I do to make this work?"
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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
I tried with TO address. Getting an error "System.Collections.Generic.List`1[System.Object]"
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
How do I convert the email body into fields I can insert into Excel?
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Is the account is the outlook address?
Most likely 🙂
%RetrievedEmails% for me does not produce anything when I run this. Any reason why?
Hey Second none. Did you put in the name of the folder you're retrieving the mails from? If yes, does it work with another folder? Kind regards, Anders
@@andersjensenorg I did. So it seems that if I have it search someone's email in our organization from the "From contains:" section, it doesn't see their emails addresses the way it should. They show up as an LDAP path.
31:29
Why my outlook is not opening
Hey Sudha. That's very hard to answer without further information :( Kind regards, Anders
The attachment folder was not empty.
or when the bot sweeps my email, it is sweeping more than just Inbox\PAD...not sure
Great lesson though!!
Hey Jeffrey. I just tried to download the course materials, and it seems like the attachments folder is empty? And thanks for the update, glad you sorted it 😊🙌❤ Kind regards, Anders
Everything is running smoothly, but when I try to open up the excel document with the information it opens up but Everything is blank. Like I see all the tabs like file, home, insert, etc... but it's just white nothingness under it.
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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
Launching of outlook giving error: Requesting you to explain Correlation Id: 9fc8df18-7078-4c3f-ad59-03d3007e5b0c
Value cannot be null.
Parameter name: type: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Failed to launch Outlook ---> System.ArgumentNullException: Value cannot be null.
Parameter name: type
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)
at Microsoft.Flow.RPA.Desktop.Modules.Outlook.Actions.OutlookActions.LaunchOutlook(Variant& outlookInstance)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.Outlook.Actions.LaunchOutlook.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)
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 11,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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
"When I tried to run the solution after step 3, I got a "runtime error" alert, possibly because I ran the solution for my entire inbox. What can I do to make this work?"
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 6000+ 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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders