Great tutorial. Have searched and seen several (4) tutorials and one course previously, and this video has been THE most helpful, Currently in Chapter 3, but could not wait to congratulate you. Thank you
Thank you Carlos, it means a lot to me that you liked my PAD tutorial the most from all the tutorials you have seen. Keep up the good work with learning PAD, and let me know in case you need a helping hand! All the best, Thomas
Awsome video -> sorry to see that low number of likes, because this is actually one of the best vids I have seen on the topic on TH-cam! Also: great work with your own web-page for demoing. Good work. Now the only issue is, that people should use APIs and Power Automate in the cloud instead of Destop flows, but thats a whole other story
Hi Thomas, I work for a company that offers employee transportation services. Currently, ten drivers handle these requests, scheduled through phone calls and emails. As the company undergoes workflow changes, we're encouraging everyone to use Microsoft Teams. After a phone or email booking, an employee creates a task(to do planner) in Teams and assigns it to a driver. Being new to the transportation sector, I noticed the potential of using bookings for appointments. However, since our company culture prioritizes Teams, I'm working on a Power Automate flow. Ideally, after an employee books a transport through MS Bookings, the flow would automatically create a Teams task for the assigned driver (chosen randomly based on availability). Unfortunately, I'm facing challenges. While I can create a Teams task upon booking, it lacks automatic driver assignment and content, leaving it blank. I sincerely appreciate your cooperation! Thank you for your time and effort.
Hi Thiago, Thanks for your comment - and apologies for my late reply. The functionality you're looking for is "generate random number". Let's say you have 10 drivers - you can represent these drivers by a number from 0 till 9. Then could create logic similar to this: 1) Generate a number between 0 and 9 2 ) Check whether this driver is available 3) If the driver is not available, generate another number and try again. Of course you need more extensive logic to handle this process - but this should get you started :)
@@TomsTechAcademy Hi Thomas, how are you? thank you very much for your attention. This is a little complicated for my level of knowledge. Do you provide automation services? If I pay you could you do this for me? Thank you!
Sir. In power automate for desktop How to select date from the modern date pickers in which first we have to select year then month and then the date? Pls pls pls make a video...
In the if statement "If CurrentItem IsEmpty then exit" the Flow is getting employee numbers for rows 10-12 but there are no employee names there. I tried using the condition IsBlank but that still adds the numbers for blank employees. Is there a way to make sure the name length is > 0? How would we fix this? I also tried %CurrentItem.Length%, which did not work because it's not a string variable. And I tried a variable of "%CurrentItem.['Name'].Length%" which gives me a syntax error. I also tried "%CurrentItem.['Name']%.Length" which gave a syntax error. Ok this condition seems to be working: "%CurrentItem['Name']% IsBlank" then exit and will not get Employee Numbers for names that are blank.
@54:20, bot is only copying first two page details in excel, i have checked loop index+1 it is at correct location and did that step again. Still I am not sure why bot is taking only two pages.
For ch 3, the Flow only gets the first page of items over and over again and puts them in the spreadsheet. In your video you click the "Anchor 2" button which doesn't seem correct. When I get my Flow to try to find and click the Next button that doesn't work either. It still gets page 1 of the "Touch" products over and over again, with the Nokia 123 item, and appends the first page of items to the spreadsheet over and over. Ok I got it working but I don't know how to share the code with others.
hi Sir...its not turning out to be what you have shown in the video.Most of the Variable shown in videos are different...... for example in the video it showed to use %CurrentItem% but in actual its =CurrentItem and also in the video it showed %CurrentItem['Name']% working but it isn't in reality nor even =CurrentItem['Name'] is working.
Hi, which country / language setting are you using? Please refer to the official Microsoft documentation in case you have doubt about the notation: learn.microsoft.com/en-us/power-automate/desktop-flows/variable-manipulation As you can see the format is the same as in the video
I wish we could prints these flows out or send the to a text file so I could make sure I have the right code. In your video it's hard to see your Flow as I have 3 windows open just to learn this Flow.
In uipath I tried extracting data from different websites but how to store all the website data in one Excel file, If I do it is only storing last website data not extracting all the website data.... could you please explain about this.
Please refer to this video if you want to learn how to extract and store data with UiPath: th-cam.com/video/2ron0Y8Kk-o/w-d-xo.html If UiPath is only storing the latest data, it's possible that you haven't enabled the "append" checkbox in the "write DataTable to Excel" activity for example
Something is wrong. First of all, upon reaching an empty row, it doesn't end the loop, goes on for almost three times more. Secondly, upon completion, excel file get corrupted.
Hi, with regards to the first challenge; if Power Automate Desktop is looping though empty rows, you can add an "if" condition in the loop and check whether the content of a column is empty. If so, use a "break" activity to stop the loop. Good luck!
![Power Automate Beginner to Pro Tutorial [Full Course]](http://i.ytimg.com/vi/1p5kI7SYz4Q/mqdefault.jpg)
![Power Automate Desktop Tutorial for Beginners [2024]](/img/n.gif)
Great tutorial. Have searched and seen several (4) tutorials and one course previously, and this video has been THE most helpful, Currently in Chapter 3, but could not wait to congratulate you. Thank you
Thank you Carlos, it means a lot to me that you liked my PAD tutorial the most from all the tutorials you have seen. Keep up the good work with learning PAD, and let me know in case you need a helping hand! All the best, Thomas
Excellent job Tom! Liked and Subscribed.
Thank you Ryan 🙏 glad this tutorial was helpful for you. Happy automation 🚀
Thanks for the great chapters in your video desc! This tells me what I might learn from this video.
Thank you for your comment, glad you like my videos :)
Awsome video -> sorry to see that low number of likes, because this is actually one of the best vids I have seen on the topic on TH-cam! Also: great work with your own web-page for demoing. Good work.
Now the only issue is, that people should use APIs and Power Automate in the cloud instead of Destop flows, but thats a whole other story
Thanks- this video was of value to me, and I look forward to power automating my work tasks!
Glad it was helpful!
Hi Thomas, I work for a company that offers employee transportation services. Currently, ten drivers handle these requests, scheduled through phone calls and emails.
As the company undergoes workflow changes, we're encouraging everyone to use Microsoft Teams. After a phone or email booking, an employee creates a task(to do planner) in Teams and assigns it to a driver.
Being new to the transportation sector, I noticed the potential of using bookings for appointments. However, since our company culture prioritizes Teams, I'm working on a Power Automate flow.
Ideally, after an employee books a transport through MS Bookings, the flow would automatically create a Teams task for the assigned driver (chosen randomly based on availability). Unfortunately, I'm facing challenges. While I can create a Teams task upon booking, it lacks automatic driver assignment and content, leaving it blank. I sincerely appreciate your cooperation! Thank you for your time and effort.
Hi Thiago,
Thanks for your comment - and apologies for my late reply.
The functionality you're looking for is "generate random number".
Let's say you have 10 drivers - you can represent these drivers by a number from 0 till 9.
Then could create logic similar to this:
1) Generate a number between 0 and 9
2 ) Check whether this driver is available
3) If the driver is not available, generate another number and try again.
Of course you need more extensive logic to handle this process - but this should get you started :)
@@TomsTechAcademy Hi Thomas, how are you? thank you very much for your attention. This is a little complicated for my level of knowledge. Do you provide automation services? If I pay you could you do this for me? Thank you!
Hi Thiago, can you post more details in my discord? I will try to help you as good as I can (for free): discord.gg/a4qUrRuZ
@@TomsTechAcademy thank you so much!
Sir. In power automate for desktop How to select date from the modern date pickers in which first we have to select year then month and then the date? Pls pls pls make a video...
Appreciate it really helpful
In the if statement "If CurrentItem IsEmpty then exit" the Flow is getting employee numbers for rows 10-12 but there are no employee names there. I tried using the condition IsBlank but that still adds the numbers for blank employees. Is there a way to make sure the name length is > 0? How would we fix this?
I also tried %CurrentItem.Length%, which did not work because it's not a string variable. And I tried a variable of "%CurrentItem.['Name'].Length%" which gives me a syntax error. I also tried "%CurrentItem.['Name']%.Length" which gave a syntax error.
Ok this condition seems to be working: "%CurrentItem['Name']% IsBlank" then exit and will not get Employee Numbers for names that are blank.
When i saving my excel no data is showing with no sheet as well. Rest automation working fine. Please help
@54:20, bot is only copying first two page details in excel, i have checked loop index+1 it is at correct location and did that step again. Still I am not sure why bot is taking only two pages.
For ch 3, the Flow only gets the first page of items over and over again and puts them in the spreadsheet. In your video you click the "Anchor 2" button which doesn't seem correct. When I get my Flow to try to find and click the Next button that doesn't work either. It still gets page 1 of the "Touch" products over and over again, with the Nokia 123 item, and appends the first page of items to the spreadsheet over and over.
Ok I got it working but I don't know how to share the code with others.
hi Sir...its not turning out to be what you have shown in the video.Most of the Variable shown in videos are different...... for example in the video it showed to use %CurrentItem% but in actual its =CurrentItem and also in the video it showed %CurrentItem['Name']% working but it isn't in reality nor even =CurrentItem['Name'] is working.
Well...... your efforts in the tutorial is very good but am unable to work
Hi, which country / language setting are you using?
Please refer to the official Microsoft documentation in case you have doubt about the notation: learn.microsoft.com/en-us/power-automate/desktop-flows/variable-manipulation
As you can see the format is the same as in the video
@@TomsTechAcademy ...hello....appreciate your reply. Am from India and using English as my language
I wish we could prints these flows out or send the to a text file so I could make sure I have the right code. In your video it's hard to see your Flow as I have 3 windows open just to learn this Flow.
Thanks for your feedback, I'm going to see how I can make it easier to follow along
Power Automate doesn't support zoom in or zoom out at this point.
In uipath I tried extracting data from different websites but how to store all the website data in one Excel file, If I do it is only storing last website data not extracting all the website data.... could you please explain about this.
Please refer to this video if you want to learn how to extract and store data with UiPath: th-cam.com/video/2ron0Y8Kk-o/w-d-xo.html
If UiPath is only storing the latest data, it's possible that you haven't enabled the "append" checkbox in the "write DataTable to Excel" activity for example
Thank you so much
Something is wrong. First of all, upon reaching an empty row, it doesn't end the loop, goes on for almost three times more. Secondly, upon completion, excel file get corrupted.
Hi, with regards to the first challenge; if Power Automate Desktop is looping though empty rows, you can add an "if" condition in the loop and check whether the content of a column is empty. If so, use a "break" activity to stop the loop. Good luck!