My best Power Automate Tutorial? That's the REST API Call tutorial: ua-cam.com/video/HiS_lQ1wbD4/v-deo.html, where you will learn to master one of the key techniques in RPA/Automation. I can't recommend you to learn it enough 😊
Good Day Anders, Thank you for this wonderful tutorial. please Is there a way I could use Power automate to copy folders with files and keep updating the folders whenever a new file is added without copying the whole folder again
Thanks a lot, @saidit7596 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
You are really great, thank you for sharing very knowledgeable content on RPA. Your channel is always act as knowledge repository for us to learn and grow...
@@andersjensenorg I haven't but I have it open on another tab now to check out! Your video above gave me the missing pieces that I needed to build a proof of concept for my work project. Everything else I had been lookin at was either too basic or too advanced. Thank you!
beautifully explained and so easy to follow. Thank you Anders, another very useful video detailing how we can use the power of RPA to save us time and effort.
You're very welcome, Rod Bowder - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
Thanks a lot, juicyjuice 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi @anders, your video literally helped me to understand power automate. Could you please create some videos on if any user want to testing on legacy desktop application which is on VM and want to take screenshots, logs and send those logs & screenshot to ADO boards user stories, that would be very helpful?
Hi NNMusic, I think you would use a HTTP or URL connector in Power Automate Cloud (or Desktop) to connect, first, to the VM. Then you would use browser automated actions to control the VM.
Thank you so much for one of the best Power Automate folder Tutorial. I was wondering is there a way to create a folders from different file name and then move the files to the folder created. (such as file a1, a2, a3, a4, b1, b2, b3, b4, all files a1-4would create a folder labeled a then files a1-4 are moved into that folder and all files labeled b1-4 would create a folder labeled b then files b1-4 are moved into the folder labeled b
Hey Jay W 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Great video! I am slowly learning from this, but I have some more advanced workflow which includes: Images upload into Dropbox. I want to create a folder based on the metadata of when the photo was taken. Eg. A folder with MM.DD.YYYY Once I have created a folder, I want to move the image based on the meta data into the appropriate folder. Eg. An Image taken on 01.01.2023 is moved into the folder 01.01.2023, and an image taken on 01.02.2023 is moved into a folder on 01.02.2023 etc. I have managed to work out the creating the folder, but struggling on the condition of moving the image into the correct folder. Do you have any tutorials which have something similar I could look at?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Greetings Jensen, Thanks so much your videos are great. i was able to learn how to fill a form on web with your help, but i was stock on how to upload a document, like to attache a document before submitting. Is it possible to upload a document in to a website using power autho?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Good Day Anders, Thank you for this wonderful tutorial. please Is there a way I could use Power automate to copy folders with files and keep updating the folders whenever a new file is added without copying the whole folder again. Thank you
Hey Tomory. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Anders Jensen, thank you very much for sharing. I have a question, could you create a stream that would run daily at a certain time, that would take the files that are on the desktop, take them and save them in a folder with the date of the day they were saved. Thanks
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thank you very much for this clear explanation Anders! I have one question.If I need to copy the last modified file from a folder, how should I create that flow?
Hey Pablo Mancera 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.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 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hey Mark. For sure. At the moment I'm doing a lot of UiPath, but I plan to make a Power Automate Desktop comeback right after New Years eve :) Kind regards, Anders
Hey @CHENYUNKE. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Also I am preparing education for our subsidiaries. When i saw your line of videos, my first tought was this, why not simply show them your videos and pause a long the way,. We are in the transition from the old WinAutomation layout into the MS world. At the same time running ProcessRobot server. Amazing videos.
Any video on webpage data scraping? And also best practices for entering user/password names into cloud services iF you share the PA script with others there's no security risk?
Hey Northern Exposure 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Thanks Anders, do we have a video on or plan to make one to compare two files i.e. extract the data from two and compare and show results lets say from two PDFs
Hey Lalit. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Once I have created the new folder by flow then I want to add files in the new folder (files like excel, ppt) by using flow. how do this any suggestions?
Anders, this was a wonderful video! Thank you for taking the time. Is there a way to use conditions with 'get files'? Would be nice to use to identify and select all .txt files 10 days or older
Hey Knucklehead. Thanks a lot for such a comment! Yes, sure. Can you see the "File Filter" in the Get files in folder? Try add *.txt. You can use wildcards (asterisk and question mark). Unfortunately they don't allow us to use either DAV or Jet. Let me know, if that helps. Kind regards, Anders
Hey Fred. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
HI Anders, Very useful . VERY CLEAR -- thanks when I'm trying to copy your moves, to add a new input variable - the default window that opens up is with a "DATA TYPE: Aa Text" - it will not open "data type: String" as in your video and the drop down options has only two options regarding text please clarify why is that and how can I open a new string input variable
Great video. Can you please also explain how can I choose a file in a folder. I want to open a website and open a image file in the browser, one after one
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 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hello Anders :) What can i do when i want do move a file and already there is a file with that name, i want to create a file like a file_name(2) automatic, if already there is a file_name in the folder. Can you help me with that please?
Hey Luísa Cortes 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Thank you very much for this clear explanation Anders! I have one question. Here you assigned all the txt, ppt files in to a list of file. Is there's a way to get one specific file out of that list giving an index or something?
Hey Dilukshi. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hi. I see down the left there is a option for FTP. Do you have a video on this? I have been asked to look into using Power Automate, for many tasks where are using file transfers to and from SFTP servers. Of these, many do some file transform (ie SFTP Get file1.csv, produce file2.csv using some scripted logic, and then send file2.csv to another SFTP). Is any of this possible with Power Automate? Thank you.
Hey SupermanKelly. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hey Aman. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hey Andrey. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Thank you for the videos! Although I have a problem that I yet cant solve, even after searching among you videos. The problem is as follows: I am using Power Apps to create new project folders with the help of Power Flows. After creating the folder for the project, I would like to copy in a template folder with numerous template subfolder and files. Do you have any good ideas of how to do this?
Hey Valdrin. Thanks a lot!! No I'm not sure, since I never used Power Apps (apart from playing around), but I will start to do it soon :) Kind regards, Anders
@@andersjensenorg Hi again, I am doing all this action in Power Flow, Power Apps is only for better user experience. Do you have any videos of how you may fix this problem on Power Flow
How can I get a folder name a document was uploaded to and use a condition to compare it to a column named "Folder Name" in an approver list and get the related approver's name?
Thanks for the video, but here i want to ask what if we have unique file name with changing date and time (i.e. testdoc202405041746.txt). With PowerShell we are able to copy such file after putting testdoc*.txt, but how can we copy this from on premises file server to SharePoint. Appreciated if you can help on this. This flow i want to create for cloud flow using on premises data gateway service
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
You're very welcome, cfrancescangeli - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
Thank you, Anders. It is an excellent material for a beginner like I am. I created a flow in which folders are deleted but got an error with a specific folder saying "access denied". The folder can easily be deleted manually but not by the flow. Any good solution to it?
Hey Mssamichi. Thanks a lot - what a nice message to receive. Sorry for the late reply. Usually it's because it's in use by the robot (either the folder as in your case or a file) and our OS locks it. Try to restart the computer and only run that activity on your folder. Do you still face the problem? Have a great weekend. Kind regards, Anders
Thank you. Great information shared. there is one suggestion if I may. can you make the areas you are describing bigger, this way we can see your actions better. as it is now it is easy to lose interest because your screen and fonts are so small. Thank you again for the awesome content. :)
Hey Mostafa. For sure. Since it's not the first time, I hear this, I really should fix it 😊 Don't hesitate to give me further feedback - I really want to improve in any way. Kind regards, Anders
Hey Wakko. Not sure 😬 I think you can do all you want with Power Automate, except the premium functions. The PAD is a 30 day trial only. Thank you 😊 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
is it possible to create a flow that goes one by one through a folder with thousands of files all of the same type, open each in a particular software program (all files would open in the same program), export each file in that software program to a destination folder as a different exported file type? wondering if i can do this myself with some trial error/testing or if i should seek outside experti$e to help me. thanks for any input you can provide
Hey geobum 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Jensen. Quick Questions. I have Desktop Flow and created a flow to wait for file and move the files. It works fine I want the flow to automatically run each month and move the file. The only way to schedule is the Cloud Flow? Also can we save the file to a dynamic folder, for example, YYYYMM?
Hi, I am looking to automate reporting to our charity funders: fill in forms (web), upload content (from Windows desktop to web). Been looking for "recording" that addresses this scenario. Only found triggers that are web based only or form filling only. So will search your channel. Thanks for this video. ,👍👌✌️😊
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks Andres, this is a wonderful video. I have a question about file in a folder. How i can build with the desktop version a trigger like when a specific file are modified, send me an email. It's look like pretty easy with a cloud flow (trigger from onedrive, sharepoint ...) but from the desktop version ... thanks!
Hey Dave Otis 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
how do you save a file in a relative path? for example, take your file explorer and type %USERPROFILE%, depending on the computer you're working on it will take you to a certain location. How do you use that in PAD? when I just type this, PAD thinks it's a variable...
Hey Sébastien De Bosscher 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Hey Trailers 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Hey Vishesh Jain 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
HI Anders, how can i use the variables of f.i. the Files. when i doubleclick after a run the variables maybe "(x) Files" and then "more" i can see properties. like .FullName or .Name or .Extension.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hello, Just wondering if this automation would work between Windows Servers? and would it support timed execution of the task, such as moving of the folder? does it also move the associated permissions with the folder? Thank you
Hey jay pandat 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
Hey Arjun. What will the rule be? Like the first column with the ame keeps it and the next one, we would like to rename? Or are you doing it by index? Let me know and we'll fix it. Kind regards, Anders
@@arjunreddy0 The problem is that the Read Range will throw an exception, when it encounter duplicate headers. What you can do is to read it w/o headers (untick add headers) to a DataTable (e.g. dtArjun). Then have an assign with LINQ where you assign your array of strings to: arrayColumnNames = (from dc in dtData.Columns.cast(of DataColumn)Select dc.Columnname).ToArray. Now you have an array with Column0, Column1...ColumnN, where N is the last column index. Do a For Each (string) and you can now enter your headers column with dtArjun.rows(0).item(item).ToString. This workaround will give you the column names to work with. Now you need to have three arrays (just copy the above procedure 3 times). You compare the first two arrays (use the syntax from here: ua-cam.com/video/VLkE1I2SfJ0/v-deo.html) and when you find a match, you can update your third array. You might need to do a while loop outside, if you have more than 1 match of the same word. I hope this helps, otherwise just ask and tell me, how much you've made. Kind regards, Anders
Hey htchd2myph. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
My best Power Automate Tutorial? That's the REST API Call tutorial: ua-cam.com/video/HiS_lQ1wbD4/v-deo.html, where you will learn to master one of the key techniques in RPA/Automation. I can't recommend you to learn it enough 😊
Good Day Anders,
Thank you for this wonderful tutorial. please Is there a way I could use Power automate to copy folders with files and keep updating the folders whenever a new file is added without copying the whole folder again
Hi Anders
How can we loop for each folder
Like in uipath path we have for each folder
I was dreading explaining PowerShell to some coworkers, but this video just introduced me to Power Automate. It looks like such a handy, friendly GUI!
Hey André, it's very low-code and great for business people. Thanks a lot for the comment. Kind regards, Anders
Clear, focused and logical build from one action to the next. Good tutorial.
Awesome, thank you! 😎
awesome video, not only did it teach me what task being done in the example, but also how to apply the learning in other requirements also.
Thanks a ton, Santhanam 🤩 Have a great day. Kind regards, Anders
I'm learning Power Automate for my job. Thanks for making these videos!
Thanks a lot, Justin. Did you see today's new video? 😊 ua-cam.com/video/JbXunbF_Nbo/v-deo.html
Excellent instruction. I am creating several PowerAutomate actions to manage my daily tasks.
Nice, Kevin. And thanks for all your nice comments and feedback. I'll get back to each of them 🙂🙌
Great Video ! Thanks!
My pleasure, have you seen this new one: ua-cam.com/video/bXqSjLCSLEg/v-deo.html 😊 Kind regards, Anders
Thank you, it's really easy and clear how you explained !
Thanks a lot, @saidit7596 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
i'm brazilian and i have difficulties to understand because i don't speak english, but i can learn from you .. thanks!
Hey Deivison. But how can you understand my English then? And big thank you 😊👍 Kind regards, Anders
Does UA-cam provide the subtitles in Brazilian?
You are really great, thank you for sharing very knowledgeable content on RPA. Your channel is always act as knowledge repository for us to learn and grow...
Your support means the world to me! I appreciate you taking the time to watch and learn from my videos 😊 Kind regards, Anders
Thank you for making these amazing videos for free 🙏🏽🙏🏽🙏🏽
Hey Nido. You're very welcome. I'm happy you like them :) Kind regards, Anders
Super clear explanations, another excellent video 👏 Thanks Anders!
Hey Franco. Thanks a lot 😊 I'm trying to find time for another round of PAD tutorials. Kind regards, Anders
Very useful and informative. Thank you. Please add more
Hey Fahd. Thanks a lot. I will, but you will have to wait a couple of weeks :) Kind regards, Anders
Do you have topics, that you would like to see?
Very useful Anders, I have subscribed to your channel please keep the practical use case examples coming
Thanks a lot, Jamie. From December I will be back to a lot of Power Automate/UiPath use cases/tutorials 🙂👍 Kind regards, Anders
Super helpful - exactly what I have been looking for
Hey Benjamin. Thanks a lot 😊 Have you seen this new use case build? ua-cam.com/video/igl93T9Jrmc/v-deo.html Kind regards, Anders
@@andersjensenorg I haven't but I have it open on another tab now to check out! Your video above gave me the missing pieces that I needed to build a proof of concept for my work project. Everything else I had been lookin at was either too basic or too advanced. Thank you!
Excellent tutorial. Thank you.
Hey TalmadgeMcGhourlaghy (I hope I spelled your name correctly, I did it manually), thanks a lot :) Kind regard, Anders
Very helpful for my usecase so far!
You're very welcome, Adam Simmons - your support helps me a lot 😍
beautifully explained and so easy to follow. Thank you Anders, another very useful video detailing how we can use the power of RPA to save us time and effort.
You're very welcome, Rod Bowder - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
Very useful content, thank you very much!
Thanks a lot, juicyjuice 🤗 Your feedback helps me immensely. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Very Helpfull. Thanks. Greetings from Colombia.
Hey William. Thanks a lot. I know the sound could be better, but you improve every day :) Kind regards from Denmark!
This information is so useful! Thank you
Hey Dionne. Thanks a lot :) Have a great weekend. Kind regards, Anders
Hey @Anders Jensen, The video was really very useful and well explained. Thank You ..!!
Hey Sajjan. Thanks a lot :) Have a great day. Kind regards, Anders
Wonderful! Thx for sharing your knowledge
Hey Dimitri. Thanks a ton. I play to do more Power Automate Desktop early February 🙂 Let me know, if you have any suggestions. Kind regards, Anders
Hi Anders! Thanks for the video - really concise and helpful.
Hey Pat, thanks a lot for the nice comment. I'm back very soon with more PAD content :) Kind regards, Anders
Nice job. Great video. Keep them coming.
Hey Gabo. Thanks a lot and I will 🙂💯 Have a great weekend. Kind regards, Anders
Fabulous demo! TYVM!
Thanks a lot, Ulyses!!!
Thank you very much for the video !!!!!
Hey Viktor - you're very welcome - thanks a lot for the support in here 🙌😊
Nice tutorial!
Helped me save a lot of time.
Thanks a lot, Tayla. Have you seen the new version: ua-cam.com/video/igl93T9Jrmc/v-deo.html Kind regards, Anders
Thanks for the post. It was very helptul.
Hey Khurram. Thanks a lot for letting me know :) I'm working on new lessons. Have a great day. Kind regards, Anders
Great job man,Thanks
You're very welcome, Soccer Magic!
Most excellent. Thank you.
Thanks a lot, Lestyn :)
Hi Anders excellence video! Very helpful thanks.
Hey Marldon. Many thanks - your comments helps me a lot 😊 Don't hesitate to bring any questions. Kind regards, Anders
Thank you. Very useful!
You're very welcome, Lecture Pal - your support helps me a lot 😍
Thank you very much for this!
Hey Radu. Thanks lot for writing 🙂 Have a great week. Kind regards, Anders
Hi @anders, your video literally helped me to understand power automate. Could you please create some videos on if any user want to testing on legacy desktop application which is on VM and want to take screenshots, logs and send those logs & screenshot to ADO boards user stories, that would be very helpful?
Hi NNMusic, I think you would use a HTTP or URL connector in Power Automate Cloud (or Desktop) to connect, first, to the VM. Then you would use browser automated actions to control the VM.
Thanks a ton, NNmusi (and I'm very sorry about the late reply). Kind regards, Anders
Thanks Anders for sharing 👍👍👍
Hey Kebin. Thanks a lot :) Kind regards, Anders
You are a rock star, thank you
You're very welcome, Hamid Jaouhar - your support helps me a lot 😍
Thank you so much for one of the best Power Automate folder Tutorial. I was wondering is there a way to create a folders from different file name and then move the files to the folder created. (such as file a1, a2, a3, a4, b1, b2, b3, b4, all files a1-4would create a folder labeled a then files a1-4 are moved into that folder and all files labeled b1-4 would create a folder labeled b then files b1-4 are moved into the folder labeled b
Hey Jay W
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
Thank you it is a nice turorial
You're very welcome 🤗
Great video! Thank you!
You're very welcome, my friend 🤩
It is Very Useful !
Thanks a lot, Praenjit. Have you seen this: ua-cam.com/video/bXqSjLCSLEg/v-deo.html Kind regards, Anders
Yes
Very helpful! THX
Thanks a lot, 1899!
Great video! I am slowly learning from this, but I have some more advanced workflow which includes:
Images upload into Dropbox.
I want to create a folder based on the metadata of when the photo was taken. Eg. A folder with MM.DD.YYYY
Once I have created a folder, I want to move the image based on the meta data into the appropriate folder. Eg. An Image taken on 01.01.2023 is moved into the folder 01.01.2023, and an image taken on 01.02.2023 is moved into a folder on 01.02.2023 etc.
I have managed to work out the creating the folder, but struggling on the condition of moving the image into the correct folder. Do you have any tutorials which have something similar I could look at?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Greetings Jensen, Thanks so much your videos are great. i was able to learn how to fill a form on web with your help, but i was stock on how to upload a document, like to attache a document before submitting. Is it possible to upload a document in to a website using power autho?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Good Day Anders,
Thank you for this wonderful tutorial. please Is there a way I could use Power automate to copy folders with files and keep updating the folders whenever a new file is added without copying the whole folder again.
Thank you
Hey Tomory. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Anders Jensen, thank you very much for sharing. I have a question, could you create a stream that would run daily at a certain time, that would take the files that are on the desktop, take them and save them in a folder with the date of the day they were saved.
Thanks
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thank you very much for this clear explanation Anders! I have one question.If I need to copy the last modified file from a folder, how should I create that flow?
Hey Pablo Mancera
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
Hi Anders,
Thanks for the great video! Is there a way to filter the files with names? Like delete the files starting with RPA
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks for the video! WHen you get the files, what are you getting exactly? The files themselves or information about each file?
Both 🙂🙌 And thanks a lot, artistry
Nice!!! Could you do a video on merging PDFs?
Hey Mark. For sure. At the moment I'm doing a lot of UiPath, but I plan to make a Power Automate Desktop comeback right after New Years eve :) Kind regards, Anders
Thanks for the video! Any ways we can create multiple folders in power automate?
Hey @CHENYUNKE. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 11,000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Awesome video
My pleasure 😍 Have you seen this one: ua-cam.com/video/bXqSjLCSLEg/v-deo.html Kind regards, Anders
Hi Henrik
I love your way of explaining the logic of i all. Best practice etc. WinAutomation/ProcessRobot user since early 2019..
Godt gået ;-)
Also I am preparing education for our subsidiaries.
When i saw your line of videos, my first tought was this, why not simply show them your videos and pause a long the way,.
We are in the transition from the old WinAutomation layout into the MS world. At the same time running ProcessRobot server.
Amazing videos.
Hvor fedt. Mange tak 🤩 Det lyder da som en fed idé - hvis du mangler en video, så sig til. Den kan jeg sikkert lave en dag. Mvh Anders
very good!! Thanks
Thank you too! 🤩
Great, thanks for doing this
Hey Bill. Thanks for letting me know :) Kind regards, Anders
Any video on webpage data scraping? And also best practices for entering user/password names into cloud services iF you share the PA script with others there's no security risk?
Hey Northern Exposure
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
Very helpful
Thanks a lot, Markus 🙏👍
Thanks Anders, do we have a video on or plan to make one to compare two files i.e. extract the data from two and compare and show results lets say from two PDFs
Hey Lalit. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Once I have created the new folder by flow then I want to add files in the new folder (files like excel, ppt) by using flow. how do this any suggestions?
Hey Nads Gaming YT - I have a video on just that coming up next week 😊
@@andersjensenorg thank you.
Anders, this was a wonderful video! Thank you for taking the time. Is there a way to use conditions with 'get files'? Would be nice to use to identify and select all .txt files 10 days or older
Hey Knucklehead. Thanks a lot for such a comment! Yes, sure. Can you see the "File Filter" in the Get files in folder? Try add *.txt. You can use wildcards (asterisk and question mark). Unfortunately they don't allow us to use either DAV or Jet. Let me know, if that helps. Kind regards, Anders
Thanks! Just what I needed. I'm wondering If is possible to say NOT *.lnk, NOT *.ini and so on?
Yea, I was gonna ask the same question. I was trying: *.lnk,-smelly.lnk doesn't work.
Hey Fred. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hi Please continue the series
Hey Kisal. Thank you. I will - within the next month I have 4-6 videos ready with more topics 🙂 Kind regards, Anders
@@andersjensenorg thank u very much.... If possible please do some videos regarding web browser data extraction using power automate
HI Anders, Very useful . VERY CLEAR -- thanks
when I'm trying to copy your moves, to add a new input variable - the default window that opens up is with a "DATA TYPE: Aa Text" -
it will not open "data type: String" as in your video and the drop down options has only two options regarding text
please clarify why is that and how can I open a new string input variable
Hey lavi. That one I havn't seen, sorry :( Kind regards, Anders. Ps sorry for the late reply, did you solve it?
And thank you for the nice words :)
Me too. No "string" available. Only Text, or "sensitive text", whatever that is.
Great video. Can you please also explain how can I choose a file in a folder. I want to open a website and open a image file in the browser, one after one
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 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hello Anders :) What can i do when i want do move a file and already there is a file with that name, i want to create a file like a file_name(2) automatic, if already there is a file_name in the folder. Can you help me with that please?
Hey Luísa Cortes
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
Thank you very much for this clear explanation Anders! I have one question. Here you assigned all the txt, ppt files in to a list of file. Is there's a way to get one specific file out of that list giving an index or something?
Hey Dilukshi. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hi. I see down the left there is a option for FTP. Do you have a video on this? I have been asked to look into using Power Automate, for many tasks where are using file transfers to and from SFTP servers. Of these, many do some file transform (ie SFTP Get file1.csv, produce file2.csv using some scripted logic, and then send file2.csv to another SFTP). Is any of this possible with Power Automate? Thank you.
Hey SupermanKelly. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
crystal clear steps. Can you also explain how to give a dynamic name to files and folders like today's date?
Hey Aman. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Good Video. 👍
Thanks a lot, Stephan 😊🙋♂️
My friend, thank you! But how to choose one most recent file out of the list?
Hey Andrey. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Thank you for the videos! Although I have a problem that I yet cant solve, even after searching among you videos.
The problem is as follows:
I am using Power Apps to create new project folders with the help of Power Flows. After creating the folder for the project, I would like to copy in a template folder with numerous template subfolder and files. Do you have any good ideas of how to do this?
Hey Valdrin. Thanks a lot!! No I'm not sure, since I never used Power Apps (apart from playing around), but I will start to do it soon :) Kind regards, Anders
@@andersjensenorg Hi again, I am doing all this action in Power Flow, Power Apps is only for better user experience. Do you have any videos of how you may fix this problem on Power Flow
Thanks :)
Fedt, du kunne bruge den, Morten 😊 Jeg har lavet en nyere/anderledes version her: ua-cam.com/video/bXqSjLCSLEg/v-deo.html Mvh Anders
Thank you
My pleasure, kind regards, Anders 🙌
How can I get a folder name a document was uploaded to and use a condition to compare it to a column named "Folder Name" in an approver list and get the related approver's name?
Hey No Mayhem. It's easiest to take one question at a time. Where do you get stuck? Kind regards, Anders
Thanks for the video, but here i want to ask what if we have unique file name with changing date and time (i.e. testdoc202405041746.txt). With PowerShell we are able to copy such file after putting testdoc*.txt, but how can we copy this from on premises file server to SharePoint. Appreciated if you can help on this. This flow i want to create for cloud flow using on premises data gateway service
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Good stuff
Appreciate it 😊
Awesome
Thanks a lot, Stephanie 😀
Great post
Thanks a lot, Astatke 🙂👌
very helpful
You're very welcome, cfrancescangeli - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html
Thank you, Anders. It is an excellent material for a beginner like I am.
I created a flow in which folders are deleted but got an error with a specific folder saying "access denied".
The folder can easily be deleted manually but not by the flow. Any good solution to it?
Hey Mssamichi. Thanks a lot - what a nice message to receive. Sorry for the late reply. Usually it's because it's in use by the robot (either the folder as in your case or a file) and our OS locks it. Try to restart the computer and only run that activity on your folder. Do you still face the problem? Have a great weekend. Kind regards, Anders
@@andersjensenorg Thank you! I will try as you advised.
Thank you. Great information shared. there is one suggestion if I may. can you make the areas you are describing bigger, this way we can see your actions better. as it is now it is easy to lose interest because your screen and fonts are so small. Thank you again for the awesome content. :)
Hey Mostafa. For sure. Since it's not the first time, I hear this, I really should fix it 😊 Don't hesitate to give me further feedback - I really want to improve in any way. Kind regards, Anders
@@andersjensenorg thank you
I wear glasses for this as it is a problem throughout UA-cam. Hundreds of videos all too small to see with the naked eye.
awesome
Thanks a lot Naushaad :)
Hi Anders do you know the restrictions for the free part of this?, thanks for the video.
Hey Wakko. Not sure 😬 I think you can do all you want with Power Automate, except the premium functions. The PAD is a 30 day trial only. Thank you 😊 Kind regards, Anders
Do you have idea, How I can set up a flow to get changes from the folder and its sub-folders?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
thank you
You're very welcome, Sir “1899 visca” SH - your support helps me a lot 😍
is it possible to create a flow that goes one by one through a folder with thousands of files all of the same type, open each in a particular software program (all files would open in the same program), export each file in that software program to a destination folder as a different exported file type? wondering if i can do this myself with some trial error/testing or if i should seek outside experti$e to help me. thanks for any input you can provide
Hey geobum
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
Jensen. Quick Questions. I have Desktop Flow and created a flow to wait for file and move the files. It works fine I want the flow to automatically run each month and move the file. The only way to schedule is the Cloud Flow? Also can we save the file to a dynamic folder, for example, YYYYMM?
Hey Khurram. PAD is only attended at the moment :( You can use ProcessRobot or way a couple of months to have Microsoft fix it. Kind regards, Anders
@@andersjensenorg Thanks, Anders.
Usefull!
Thanks a lot, Dmitri - from December I'm going full time creating Power Automate and UiPath content :) Kind regards, Anders
Hi, I am looking to automate reporting to our charity funders: fill in forms (web), upload content (from Windows desktop to web). Been looking for "recording" that addresses this scenario. Only found triggers that are web based only or form filling only. So will search your channel. Thanks for this video. ,👍👌✌️😊
Hey william, check this: ua-cam.com/video/JbXunbF_Nbo/v-deo.html And thanks for the nice words 😊
can we create a flow to create weekly folders ? each folder has the name by the week number and the year ?
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks Andres, this is a wonderful video. I have a question about file in a folder. How i can build with the desktop version a trigger like when a specific file are modified, send me an email. It's look like pretty easy with a cloud flow (trigger from onedrive, sharepoint ...) but from the desktop version ... thanks!
Hey Dave Otis
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
how do you save a file in a relative path?
for example, take your file explorer and type %USERPROFILE%, depending on the computer you're working on it will take you to a certain location.
How do you use that in PAD? when I just type this, PAD thinks it's a variable...
Hey Sébastien De Bosscher
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
Hey! is it possible to run this in the cloud? I want to run it every day at a certain time (without the pc being online)
Hey Trailers
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
How can we automate the file path when downloading multiple files from the web to the same folder?
Hey Vishesh Jain 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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html Have a great day. Kind regards, Anders
HI Anders, how can i use the variables of f.i. the Files. when i doubleclick after a run the variables maybe "(x) Files" and then "more" i can see properties. like .FullName or .Name or .Extension.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi, how to get files by index?
for example i want to get the name of the fifth file in a folder (name sorting)
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 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi Anders! Is it possible to use Power automate desktop app to run pitstop action lists on multiple PDFs sequentially?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 13,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
@@andersjensenorg Thank you for recommending! :)
Hello,
Just wondering if this automation would work between Windows Servers? and would it support timed execution of the task, such as moving of the folder? does it also move the associated permissions with the folder?
Thank you
Hey jay pandat
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: ua-cam.com/video/_QRI-Yo2h8U/v-deo.html
Have a great day.
Kind regards,
Anders
Hai Jensen
how to rename the columns if we have duplicate columns in excel sheet in uipath.
please make a video on this.
Hey Arjun. What will the rule be? Like the first column with the ame keeps it and the next one, we would like to rename? Or are you doing it by index? Let me know and we'll fix it. Kind regards, Anders
In a excel sheet there are 4 columns like- ARJUN, JENSEN, ARJUN, JENSEN. We have to rename as ARJUN, JENSEN, ARJUN1, JENSEN1.
@@arjunreddy0 The problem is that the Read Range will throw an exception, when it encounter duplicate headers. What you can do is to read it w/o headers (untick add headers) to a DataTable (e.g. dtArjun). Then have an assign with LINQ where you assign your array of strings to: arrayColumnNames = (from dc in dtData.Columns.cast(of DataColumn)Select dc.Columnname).ToArray. Now you have an array with Column0, Column1...ColumnN, where N is the last column index. Do a For Each (string) and you can now enter your headers column with dtArjun.rows(0).item(item).ToString. This workaround will give you the column names to work with. Now you need to have three arrays (just copy the above procedure 3 times). You compare the first two arrays (use the syntax from here: ua-cam.com/video/VLkE1I2SfJ0/v-deo.html) and when you find a match, you can update your third array. You might need to do a while loop outside, if you have more than 1 match of the same word. I hope this helps, otherwise just ask and tell me, how much you've made. Kind regards, Anders
Can we filter by create date and time? Thanks
Hey htchd2myph. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders