Mr Jensen, I wish to give a very heart felt thank you for all the time and effort that you put into making this amazingly interesting content- I love it and your calm and thought out explanations- thank you, thank you 🙏🏻
Hey think help. Wow, thanks a lot for your nice feedback. Highly appreciated. I've thought a lot about, if I should do these videos, where I "live-code" and explain vs polished videos. Currently I prefer these, as they show my thought process and the small mistakes we constantly make and have to fix in Power Automate Desktop development. Have a great day. Kind regards, Anders
I was about to say barely the same thing (with less English skills 😅). So thank you very much ! I want to give you an e-hug for all of the videos I have seen so far. It nicely explained ! Well it’s really really appreciated. You go where the value is so thank you very much !
Hi, I want to ask, if i have xlsx file, and xls file, then error arise after follow your tutorial at around 14:44, the program says "FileCount doesnt have properti 'xls'", at set variable inside IF, how to resolve this? FYI: inside array FileCount, already available XLSX filename
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Hi Anders, please can you do a video how to get a list of files in folders in PAD, but also extract file attributes such as creation date? I've been trying for ages and cannot work it. I understand it can be done with a for each loop and CMD
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How to Apply Actions to multiple excel files? So I want to apply a similar action to multiple excel files on the same folder. I'm unable to find a way to do it.
I am using the Desktop version. I am manually opening each files using the Launch Excel option and doing it one by one.
I want to apply the same action to multiple files using the shortest way but I can't figure it out.
Hey Mark. First of all - why are you opening them one by one? Why not sort it in Power Automate Desktop or an invoked script? You're more than welcome to post your case on my discord (in the Power Automate Desktop channel), then we're more than 6000 RPA developer ready to help you. Free. Here's how to join: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks for the video! Can you demonstrate how to move Microsoft Lists file attachments to a specific SharePoint folder according to the characters contained in the file name? For example, a Microsoft Lists attachment has a file name that contains the word "blue" and another that contains the word "green." The SharePoint library has a folder titled "Blue" and a folder titled "Green." How would you use Power Automate to extract the Microsoft List attachments and place them in the corresponding SharePoint folders? 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 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
I have created a flow which is basically saving attachments in the specific folder using power automate desktop. I am facing a challenge my flow is saving signature's jpg file as well as png files.I want to exclude the jpg as well as png file.could you please make a video for this problem.
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
Hi Jenson am creating a folder and storing the downloaded files in my target folder now am trying to read the most recent file from my target folder but its not working kindly can u help me to sort it out? AM also set a variable and trying to get the first file(latest one with 0 index but i cant be able to open 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 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
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
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
Thank you Anders for your content. Here is a question that may be an interesting topic. I have a list of file names and I wish to compare that to the file names in a folder and then only move those specific files out into another folder. But I can't seem to write a flow where the file names will loop through the list of file names. I would think this might be a common use case. How could you compare files in a folder to files in a list so you can dynam,ically move only certain file names around? I hope that is an interesting question for people and many thanks for the desktop content!
Hey Peter, let me solve it. Can you send me an email with how a list looks like? anders@andersjensen.org You'll have a video next week. Kind regards, Anders
@northernboy70 if you don't mind I would love to see what Anders came up with as a solution. I am looking at a similar case with pictures. Thanks in advance.
Thank you for making these ,I'm a complete newbie to PAD but your tutorials are helping me automate so many tasks. But I am having issues with paths to folders, if I browse for the folder in a step the flow works fine but when I set the path as a variable I get an error saying can't retrieve the list of files in a folder - when I go deeper into the error I see this ... Can't retrieve list of files in folder . ---> System.ArgumentException: The path is not of a legal form . I have compared the path in both cases and they look exactly the same, any idea what could be causing this? 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 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 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Bonjour, Je vous remercie pour toutes vos leçons. Sauf erreur de ma part, il y a une erreur sur l'algorithme, j'ai suivi les étapes une par une, Power Automate me déplace des fichiers dans le mauvais dossiers, Word avec Excel et PowerPoint avec Texte et ainsi de suite. Merci d'essayer sur des fichiers avec des noms différents et revenir vers moi. Cordialement
@@andersjensenorg Hello, Thank you for all your lessons. Unless I am mistaken, there is an error on the algorithm, I followed the steps one by one, Power Automate moves me files to the wrong folders, Word with Excel and PowerPoint with Text and so on. Please try on files with different names and get back to me. Cordially
Use the Get files action. In Advanced choose Sort by: Creation time and tick the 'Descending'. After the Get files use a Set variable action and in the value write %Files[0]% 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): 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
I made a Discord, so we can network and solve RPA problems together 😊
Here’s the link, if you want to join: discord.gg/iloveautomation
I have no words. One more excellent video.Thank you Anders Jensen.
Hey ALVINMAN, thank you so much for all your nice comments 🙌😊 Kind regards, Anders
Thank you so much Anders, this video is a life-saver.
I'm so happy to hear, SQLAgent 😊🙌 Kind regards, Anders
Thank you for sharing. I'm learning a lot from your videos. Won my LIKE.
Thanks a lot for the nice words, ORIC - and the like 👍😍
Mr Jensen, I wish to give a very heart felt thank you for all the time and effort that you put into making this amazingly interesting content- I love it and your calm and thought out explanations- thank you, thank you 🙏🏻
Hey think help. Wow, thanks a lot for your nice feedback. Highly appreciated. I've thought a lot about, if I should do these videos, where I "live-code" and explain vs polished videos. Currently I prefer these, as they show my thought process and the small mistakes we constantly make and have to fix in Power Automate Desktop development. Have a great day. Kind regards, Anders
I was about to say barely the same thing (with less English skills 😅).
So thank you very much !
I want to give you an e-hug for all of the videos I have seen so far.
It nicely explained !
Well it’s really really appreciated. You go where the value is so thank you very much !
Hi, I want to ask, if i have xlsx file, and xls file, then error arise after follow your tutorial at around 14:44, the program says "FileCount doesnt have properti 'xls'", at set variable inside IF, how to resolve this?
FYI: inside array FileCount, already available XLSX filename
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Appreciated your time your content 🔥 damn helpful as an Beginner in RPA
Thanks a lot, suraj singh 🤗 Your feedback helps me immensely. Kind regards, Anders
Hi, the new GUi does not show all the fields in the if statement, is there any workaround for this?
Hey rojo, what do you mean, it doesn't show all fields? 😊 Kind regards, Anders
Hi Anders, please can you do a video how to get a list of files in folders in PAD, but also extract file attributes such as creation date? I've been trying for ages and cannot work it. I understand it can be done with a for each loop and CMD
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How to Apply Actions to multiple excel files?
So I want to apply a similar action to multiple excel files on the same folder. I'm unable to find a way to do it.
I am using the Desktop version. I am manually opening each files using the Launch Excel option and doing it one by one.
I want to apply the same action to multiple files using the shortest way but I can't figure it out.
Hey Mark. First of all - why are you opening them one by one? Why not sort it in Power Automate Desktop or an invoked script? You're more than welcome to post your case on my discord (in the Power Automate Desktop channel), then we're more than 6000 RPA developer ready to help you. Free. Here's how to join: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
@@andersjensenorg I joined, I'm extremely sorry. I'm new to all this and I'm not a coder/programmer. It's extremely challenging to use power automate.
Thanks for the video! Can you demonstrate how to move Microsoft Lists file attachments to a specific SharePoint folder according to the characters contained in the file name? For example, a Microsoft Lists attachment has a file name that contains the word "blue" and another that contains the word "green." The SharePoint library has a folder titled "Blue" and a folder titled "Green." How would you use Power Automate to extract the Microsoft List attachments and place them in the corresponding SharePoint folders? 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 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
I have created a flow which is basically saving attachments in the specific folder using power automate desktop.
I am facing a challenge my flow is saving signature's jpg file as well as png files.I want to exclude the jpg as well as png file.could you please make a video for this problem.
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
Hi Jenson am creating a folder and storing the downloaded files in my target folder now am trying to read the most recent file from my target folder but its not working kindly can u help me to sort it out? AM also set a variable and trying to get the first file(latest one with 0 index but i cant be able to open 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 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
Hi, can I get files in a folder from a folder that is synced?
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
Great video!!, but I'm new to rpa, doesn't it work in power automate cloud?
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
Thank you Anders for your content. Here is a question that may be an interesting topic. I have a list of file names and I wish to compare that to the file names in a folder and then only move those specific files out into another folder. But I can't seem to write a flow where the file names will loop through the list of file names. I would think this might be a common use case. How could you compare files in a folder to files in a list so you can dynam,ically move only certain file names around? I hope that is an interesting question for people and many thanks for the desktop content!
Hey Peter, let me solve it. Can you send me an email with how a list looks like? anders@andersjensen.org You'll have a video next week. Kind regards, Anders
@@andersjensenorg many thanks Anders, I have dropped you a mail. Hopefully it may make an interesting video for your audience! Best wishes 😀
@@northernboy70 Hey Peter, great, I've sent you a draft of the solution, please let me know, how it needs to be corrected. Kind regards, Anders
@northernboy70 if you don't mind I would love to see what Anders came up with as a solution. I am looking at a similar case with pictures. Thanks in advance.
Thank you for making these ,I'm a complete newbie to PAD but your tutorials are helping me automate so many tasks. But I am having issues with paths to folders, if I browse for the folder in a step the flow works fine but when I set the path as a variable I get an error saying can't retrieve the list of files in a folder - when I go deeper into the error I see this ... Can't retrieve list of files in folder . ---> System.ArgumentException: The path is not of a legal form . I have compared the path in both cases and they look exactly the same, any idea what could be causing this? 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 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
What if there are duplicates, how can we identify 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 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Very useful
You're very welcome, Prasenjit Mandal - your support helps me a lot 😍
thank you
My pleasure 🙂
Make a video on how we can build Regex Tutorial
I will, Suraj. Great input. Have you seen this: ua-cam.com/video/TmeGaxksrUA/v-deo.html Here I use RegEx to filter my data. Kind regards, Anders
Bonjour,
Je vous remercie pour toutes vos leçons.
Sauf erreur de ma part, il y a une erreur sur l'algorithme, j'ai suivi les étapes une par une, Power Automate me déplace des fichiers dans le mauvais dossiers, Word avec Excel et PowerPoint avec Texte et ainsi de suite.
Merci d'essayer sur des fichiers avec des noms différents et revenir vers moi.
Cordialement
Hey Rachid, I can't speak French 😑 Can you please try in English, and I'll look at it. Kind regards, Anders
@@andersjensenorg
Hello,
Thank you for all your lessons.
Unless I am mistaken, there is an error on the algorithm, I followed the steps one by one, Power Automate moves me files to the wrong folders, Word with Excel and PowerPoint with Text and so on.
Please try on files with different names and get back to me.
Cordially
Make a video on Regex Tutorial At Power Automate Desktop
In the pipeline. Thanks for giving me so many valuable comments 😊
how to get the most recent file in an folder
Use the Get files action. In Advanced choose Sort by: Creation time and tick the 'Descending'. After the Get files use a Set variable action and in the value write %Files[0]% 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
It doesn't tell what wild card options there are or where to find out, very disappointing
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