- 10
- 33 458
Begin Endless Automation - By Prankur
India
เข้าร่วมเมื่อ 31 พ.ค. 2021
Hello,
This channel would be creating content for the people who all want to start their automation journey. Feel free to reach out to me in case you have any questions regarding how to get started in the RPA space using different RPA tools, I would be happy to help. The idea behind creating the channel is to learn together and grow together.
LinkedIn - www.linkedin.com/in/prankur-joshi-24574724/
UiPath Forum - forum.uipath.com/u/prankurjoshi/summary
UiPath Community Blog - www.uipath.com/community/rpa-community-blog/dot-net-developer-story-winning-uipath-community-award
-Prankur
This channel would be creating content for the people who all want to start their automation journey. Feel free to reach out to me in case you have any questions regarding how to get started in the RPA space using different RPA tools, I would be happy to help. The idea behind creating the channel is to learn together and grow together.
LinkedIn - www.linkedin.com/in/prankur-joshi-24574724/
UiPath Forum - forum.uipath.com/u/prankurjoshi/summary
UiPath Community Blog - www.uipath.com/community/rpa-community-blog/dot-net-developer-story-winning-uipath-community-award
-Prankur
UiPath Excel Automation
This video tells us about the ways in which you can use excel application. Reading and writing the data from excel workbook, getting sheets, appending data, inserting and deleting rows and many others. If you are a beginner this would really help you in understanding excel activities in UiPath.
มุมมอง: 313
วีดีโอ
UiPath - What is RPA? Why to use RPA?
มุมมอง 523 ปีที่แล้ว
This video tells about the basic understanding of RPA, why should we use RPA, what process should be automated using RPA.
UiPath - Microsoft Office365 Part2 - Outlook and Calendar
มุมมอง 4K3 ปีที่แล้ว
In this video we will see if we want to use Outlook and calendar activities what should be the input what output you will get, all the data types which you can iterate on and complete the activities.
UiPath - Microsoft Office365 Part1 - Setup and Files/Folders Activity
มุมมอง 11K3 ปีที่แล้ว
In this video, we will see how to configure Microsoft Office 365 settings in the Azure portal to communicate with UiPath and then use Files and folders activities.
UiPath - Jira Software Automation Through API Tokens
มุมมอง 2.5K3 ปีที่แล้ว
In this video you will learn how to access Jira through API tokens and perform different operations like Create, Update, Delete issues any many more.
UiPath - How to Execute Xpath and work with XMLs
มุมมอง 1.4K3 ปีที่แล้ว
In this video, you will learn how to use execute XPath activity and how to traverse through each and every node of XML to get the required data.
UiPath - Update/Delete rows from data table without loop
มุมมอง 3.4K3 ปีที่แล้ว
This video will show you how to update or delete rows from a data table in UiPath in the fastest way which is LINQ.
UiPath - How to Join Data tables with LINQ
มุมมอง 1.9K3 ปีที่แล้ว
This video will show how to Join two tables with UiPath Join activity and LINQ.
UiPath - How To Filter Datatables with LINQ
มุมมอง 1.6K3 ปีที่แล้ว
How to filter data tables in UiPath in some simple yet faster ways. You can also visit UiPath Community Blog to see my blog here www.uipath.com/community/rpa-community-blog/four-ways-to-filter-data-table-in-uipath-studio
UiPath - Datatables, How to use GroupBy with SUM and COUNT functions
มุมมอง 7K3 ปีที่แล้ว
It will show the simplest way to group the rows based on required columns with SUM and COUNT functions, if you have worked on projects like supply chain or invoice automation you must be knowing how important is to use these functions.
Lol! Typical "offshore" work. Title says "delete from data table WITHOUT LOOP". Proceeds to use *TWO LOOPS* in LINQ. Lol. Wow. You do realize .ForEach() is a LOOP, right?
i want to learn linq...where i can learn this? do you take classes?
Hello bro i have this data where i need to calculate 3 subject each student and write to total column .How to calculation through LInq can you help me. NAME ENGLISH MATH SCIENCE TOTAL ANKIT 85 74 75 AMAN 80 85 65
Hi can we perform action on online excel
this is super helpful, thanks!
Sorry, at the end the results can't be seen because of the next videos windows appeared and overlap
Hi, can you please do more videos on Microsoft 365(planner)
Hey Prankur. Keep up the awesome work! Do you plan to make more content with uipath and jira? Kind regards, Deepak
Thanks. Will surely add content for RPA and UiPath not sure about Jira for now. Congratulations on being recognised as MVP again. Very well deserved
How to pass API token as secured string
Thanks for sharing this video with clear explanation
Mr. Prankur Can you please share your workflow of what you are teaching here.
I have worked out on whatever you have said in the video but I am getting "runtime execution error". "The Value cannot be null". The error I got is in jira application scope. Please elaborate on the error.
Hi, can we download a folder with subfolders and files from SharePoint using office 365
Trying to pass API token value as securestring and getting not declared compilation error. How Do i need to pass API token ? Please elaborate on that
Very helpful, thanks for sharing.
How do I need to give secure string
how to add queue name in subject in O 365 Send mail activity ?
In my xpath ,i have namespace how to extract data using xpath in XML with namespace.
Thanks for this! Very helpful. My only critique is that the last line was very hard to read because of all the brackets at one point, so maybe for the sake of readability you could indent and keep one "idea" per line in the LINQ statement
Here is the full LINQ for anyone unable to read it clearly: ( From p in var_STUDENT_Info.AsEnumerable() Group By col1 = p("Name").ToString Into Group Select var_DT_Final.Rows.Add( { col1, Group.Sum( Function(r) Convert.ToDouble(r("Marks").ToString) ), Group.Count() } ).CopyToDatatable
@@LukeWatts85 thanks 👍 very valid point I will try to improve code visibility in next ones
howw can we save attachments
You can use Get Mail activity it will return you list of messages, use for each loop to iterate and then use save attachments activity
Have you done this in Sharepoint instead of OneDrive? Creating files in Sharepoint using UiPath?
SharePoint I have not used but I will surely try and get back to you
Executing should have been there .. Thats a big drawback of this video
Hi I have setup office 365 ..but may i know how you navigated to one drive folder ..And how the accounts to be linked etc
Hi, can you share your Linq code please
I pasted it above if you need still
Hi, How to make query dynamic to download any file
You can have the subfolder name in a config file where you want to search the file and in the file you can pass any variable with full file name
@@beginendlessautomation-byp4257 Is it possible to use the Query parameter to select with wildcards? For example, I want to find all the files/folders that contain the text "messages_1" (if there were files/folders named "my messages_10" or "messages_15" I would want them returned in the driveItem array). I've tried wildcards (*) and various odata queries like $filter with no success.
@@billrichardson6469 I think you will have to loop on the folders inside parent folder and while iterating you can check names
Hi, I really liked your video, I learned a lot of new things, but I tried to innovate and I wasn't very happy. In that part where you show how to create an excel woorkook I couldn't understand how to write the data in this workbook created. Could you make a video showing how office 365 write range works? Thanks
Thanks Fabio. I will try to work on your scenario and get back to you 👍🏼 you connect with me on LinkedIn for better communication.
Good information. Thanks!
Thanks Nitesh brother!
Helpful 👍
I tried this but this is not working the error showing is that "copytodatatable is not a part of ienumberable of object type
Hello Vijay, did you check in your main.xaml that assembly reference for datatable extension is given?
@@beginendlessautomation-byp4257 How can we do that
Very informative video. 👍🏼
Thank you!
Good one ❤️❤️❤️
Thanks Nived
Could you please show executing the activities.. Why because the same steps i have followed and getting error inside the scope as “Generic exception - An error occurred sending the request” . Would you suggest me how to resolve this issue
Hello Sweetha it seems there is authentication error from what you have mentioned. Which authentication method you are using? If you use Username and Password or IntegratedWindowsAuthentication make sure multi-factor authentication MFA is disabled otherwise they will not work and application Id and secret will only work in unattended mode. See this for more info - docs.uipath.com/activities/docs/microsoft-office-365-scope. Let me know if this helps
All the best prankur 💐💐💐💐💐, glad to see your work on TH-cam .
Thanks a lot!
Wow ,good to see you on YT
Thank you for this video , make sure you make playlist for organised channel , I'm beginner to uipath.👏👏👏
Thanks Vidhi. Yes I am working on creating a series for beginners
@@beginendlessautomation-byp4257 waiting for that! 👏😍
Aur content hindi mein bhi daal de kuch to acha rahta
Bhai LINQ par aur video bana de bhai,aur regex bhi cover kar de bhai