How to Get File Name from Lane and Get List in SharePoint Capitalizing on UiPath
UiPath is the technology of the head Robotic Process Automation (RPA) tool that enables enterprises to automate repetitive tasks. UiPath in just a few clicks authorizes to access to applications such as SharePoint, make and delete the mandatory files, and do sundry mathematical operations. This blog will be surveying into how to get a file name from a pathway exploiting UiPath and also how to get a list from SharePoint through UiPath
1 How to Get File Name from Road Applying UiPath
In automation, often you have to separate the file name from the complete valid file way to the name of the file with the help of this menu structure. One such built-in function provided by UiPath is the GetFileName function which enables you to extract the file name from a file pathway that is specified.
Step-by-Step to Get File Name from Course:
Step 1: Prepare the File Road
First, no matter what the process is, you need to have a file passage, For case:
Copy codeC:\Users\JohnDoe\Documents\Reports\SalesReportpdfStep 2: Use PathGetFileName Method
UiPath entitles the officers of the company a very easy way to extract the file name from the way (pathway) by exploiting the VBNET functions. You can use the PathGetFileName method to get the file name from a full pathway.
Here's how you
- Assign Activity: This illustration illustrates how you can useAssignactivity to produce a variable that will be later used with a file to store the file route. vb Copy codefilePath = C:\Users\JohnDoe\Documents\Reports\SalesReport.pdf
- Assign Activity (for File Name): The next step is to retrieve the file name by means of thePath.GetFileNamemethod. To do so, we need to apply one moreAssignactivity for the file name.vbCopy codefileName = Lane.GetFileName(filePath)
- Output the Result: You can either see the result through aMessage BoxorWrite Lineto show the file name. Here is what it would display:vbsales report.pdf

Case System:
- Assign Activity 1: filepath = C:\Users\JohnDoe\Documents\Reports\SalesReport.pdf
- Assign Activity
Bonus: Extracting File Name Without Enlargement
For the purpose of finding the file name and omitting the elongation, you can use the PathGetFileNameWithoutExtension method.
vb
This will return:
Copy codefileNameWithoutExt = PathGetVery often you are going to get a list of items or documents from the SharePoint site. With UiPath, despite that, it opt against be rocket science for you to automate this process.Step-by-Step Advisor to Get List in SharePoint:
Step 1: Install the SharePoint Activities Package
Before doing any of the file operations on SharePoint, what really you should do is to install the UiPathSharePointActivities package. You should go in advance with the following process:
- Open the Control Packages window in UiPath Studio.
- Go to the Official tab, find UiPath.SharePoint.Activities making use of the Search bar and install it.
Step 2: Set Up the SharePoint Application Scope
You need to be identified and linked to your SharePoint site to be able to check its data. Use the SharePoint Application Scope activity to do this.
- Drag the SharePoint Application Scope activity to the sequence.
- Provide the required credentials and site URL as follows.
- Site URL: https://yourcompany.sharepoint.com/sites/ProjectSite
- Client ID: Your SharePoint API Client ID.
- Client Secret: Your Client Secret.
- Tenant ID: Your Azure Tenant ID.
Step 3: Use the Get List Items Activity
Now you are connected to SharePoint and you can get the items from the particular list. You will implement a SharePoint Get List Items activity.
- Drag the SharePoint Get List Items activity and drop it, under the SharePoint Application Scope.
- Choose a list name (Documents or any ceremony list) in the properties.
- Likewise, it is greater if you use the filters and columns ****** to make sure the only required items are listed.

Properties settings to SharePoint Get List Items:
Exemplar:
- Site URL: https://yourcompany.sharepoint.com/sites/ProjectSite
- List Name: Documents
- Doubt: (optional) Title eq 'Sales Report' (to filter by title).
Step 4: Loop Through the Retrieved List
Usually, the items are saved after retrieval as a DataTable or IEnumerable collection. A For Each Row activity will activate traversing each item in the collection or array where you can deal with them as it is required.
UiPath, among the major names in the robotic process automation (RPA) sector, is unparalleled in providing organized solutions for automating annoying and repetitive tasks across several applications One of the most frequently automated activities is dealing with Achieve excellence files, and UiPath, on the other hand, has a whole array of activities that can be used for the capable supervising of these files. Facilitate's see what the Achieve excellence Online activities are, how they are used, and how some of the innovative Top activities can make your work easier in this blog.
Achieve excellence Automation in UiPath: A Game Changer
Exceed is still one of the most extensively used tools in the business community for data storage from the simplest sums to data analysis to complicated facts in Be outstanding It is essential for many organizational processes. Automating tasks that involve Achieve excellence files can save you a lot of time and decrease the possibility of errors UiPath’s link-up with Distinguish oneself is among its prominent competence which provide different services provided that you are dealing with local Be outstanding files or Lead Online through the company's cloud-based system.
Examining Surpass Online Activities in UiPath
Cloud technologies are being used more and more and the Surpass Online app has succeeded as one of the main alternatives for many companies. UiPath invitations special activities for working with Surpass Online, which are capable of editing data that is stored on the cloud. These activities equip you to engineer the Shine files without downloading them into your computer, and you're able to do this on platforms like OneDrive and SharePoint.
Here are some frequent Distinguish oneself Online activities in UiPath:
- Outshine Online Application Scope: It is a portable opportunity to work with an Top file placed on a cloud base. Hence it is more comfortable to access the cloud-stored Be outstanding files straight from UiPath without any hassle of extra steps like downloading and launching them in a local demonstration of Achieve excellence.
- Read Range: Users can deploy the 'Read Range' UI Course activity in order to import data from Shine Online files into a Data Table, which can be used for expanded administering of the data internal to the automation process.
- Write Range: The Write Range activity, the same as Read Range activity, permits you to send data to an Top Online file, thus, your data is directly updated on the cloud.
Through such activities, you can completely automate Distinguish oneself Online processes like data extraction, data transformation, and reporting to conserve the integrity of your data in the cloud.
How to Use the Be outstanding File Activity in UiPath
Besides enabling the operations with Be outstanding Online, UiPath additionally comes with a strong set of old-fashioned Outperform file activities that provide the easy setting of local Outshine file interaction. Such activities permit you have rigorous control over Surpass files in case you open, read, write the data, or control the data. Below you will find out the method of adopting Outshine File Activity in UiPath:
Lucille
An effort offers a chance to learn, and a result provides valuable lessons.
