Dear Community enthusiasts, are you up to Unlock the Future further?
Virtual series day 6 happened today : See Unlock the Future: Join the 20 Use Cases Challenge Learning Sprint - Day 6 at UiPath Visakhapatnam and now it’s time to put your skills to the test.
Are you ready for #6 Challenge from the 20 Use Cases Challenge Learning Sprint , crafted together with @pradeep_ch , @AutomationX_by_Kiran and with the help of @loredana_ifrim & @Ana_Bulhac ? Let’s level up your UiPath skills!
Here is the Challenge #6 we have in store for you 
:
RPA Challenge Automation with UiPath Studio Web
Objective: Automate the RPA challenge task by interacting with the website and processing the provided Excel file containing user details.
Steps:
- Create Project in Studio Web
- Action: Initialize a new RPA project using UiPath Studio Web.
- Outcome: A new project is created to automate the challenge.
- Launch RPA Challenge Website
- Action: Use the Open Browser activity to navigate to the RPA Challenge website.
- Outcome: The bot successfully launches the RPA Challenge website in a browser.
- Get challenge.xlsx File using HTTP Request
- Action: Download the challenge.xlsx file using an HTTP Request activity.
- Outcome: The Excel file with user data is downloaded from the given URL.
- Upload File to Google Drive / OneDrive
- Action: Use the Google Drive or OneDrive integration in UiPath Studio Web to upload the downloaded challenge.xlsx file.
- Outcome: The file is successfully uploaded to the chosen cloud storage.
- Click “Start”
- Action: Use a Click activity to click the “Start” button on the RPA Challenge website.
- Outcome: The challenge begins, and the form fields are ready for input.
- Process Each Record in the Excel File
-
Action: Read the Excel file and iterate through each row using a For Each Row activity.
-
Sub-Steps for Each Record:
Step 6.1: Use Type Into activities to enter the following details for each record in the corresponding form fields:
First Name
Last Name
Company Name
Role in Company
Address
Email
Phone Number -
Outcome: For each record in the Excel file, the respective details are entered into the form fields on the RPA Challenge website.
- Click “Submit”
-
Action: After filling out the form for each record, use the Click activity to submit the form.
-
Outcome: The form is submitted successfully, and the process continues for the next record until all entries are processed.
-
USE CASE 12
Process Invoice with File-Based Trigger on Google Drive/OneDrive
Objective: Automate invoice processing by triggering the process when a new file is created in Google Drive/OneDrive, extract relevant information from the invoice, and update a spreadsheet with the extracted data.
Steps:
- Create a Studio Web Project with File Created Trigger on Google Drive/OneDrive
- Action: Use the file-based trigger in UiPath Studio Web to monitor Google Drive or OneDrive for newly created files (invoices).
- Outcome: The automation is triggered whenever a new invoice is uploaded to the monitored folder in Google Drive/OneDrive.
- Download File from Google Drive/OneDrive
- Action: Use the Download File activity in UiPath Studio Web to download the newly uploaded invoice from Google Drive/OneDrive to the local system.
- Outcome: The invoice file is successfully downloaded and stored for further processing.
- Extract Invoice Information Using Generative Extractor
-
Action: Leverage the Generative Extractor in UiPath to extract key invoice data such as:
Invoice Number
Invoice Date
Total Amount -
Outcome: The relevant invoice information is extracted and stored in variables for further use.
- Create Spreadsheet in Google Drive/Excel File in OneDrive
- Action: Create a new Google Spreadsheet or Excel file in OneDrive using the respective integration activities.
- Outcome: A new spreadsheet or Excel file is created successfully in the designated location.
- Add Sheet with Table Name from the Extracted Information
- Action: Add a new sheet to the created file, and use the extracted information (e.g., Invoice Number, Vendor Name) as the sheet name or table header.
- Outcome: The new sheet is created, and the relevant information is reflected in the sheet name or table header.
- Write Data to Spreadsheet/Excel File
- Action: Use the Write Range or Write Cell activity to input the extracted invoice data into the newly created sheet in the Google Spreadsheet/Excel file.
- Outcome: The extracted invoice details are written into the file in a structured format.
InputFile.zip (43.6 KB)
Event Date: Today onwards!
Deadline : Quiz submissions must be submitted no later than the 2024-09-24T20:59:00Z, your time-zone!
Scoring System
- All submissions earn one star
for participation, regardless of correctness. - Correct solutions/Quiz answers receive 5 stars .
- The most creative/best practice solution earns an additional maximum 5 stars .
and begin sharing your creative submissions.
Tackled two fascinating use cases using UiPath Studio Web .
Immense gratitude to the UiPath MVP experts 
Successfully completed Day 6 of our hands-on learning sprint! 
Tackled two new use cases focusing on the Web Studio RPA Challenge and Event-Based Triggers, adding more tools to my automation skillset.
Akash_Javalekar1
Yoichi
ashokkarale
arun.v7
Jon_Smith
rashmisingh2695
ppr
jast1631
pere
Dheerendra_vishwakarma