UiPath training task

Need to complete a training task UiPath Studio X and share solution .
Also record screen to explain briefly how the solution is done and how to open in my Local Studio.



Here is the task:


Supplier list Maintenance

You have a excel file which contains company supplier information. To maintain the list, you need to check if each supplier is available on https://www.rpasamples.com/suppliers . If not, you will create the new supplier on the website. Once done, you will send out email with summary of supplier status.
Knowledge to check:
• Web Automation
• Excel Automation
• Email Automation
Download working file:

Manual Steps
• Create a copy of working file and rename it as ‘CompanySupplier_’ plus current Day, eg ‘CompanySupplier_20221221’.

• Open the newly created excel file and add 1 new column called ‘Supplier Status’ at the end, eg


• Open https://www.rpasamples.com/suppliers

• For each supplier in excel file, cross check on supplier website
- if External Name on UI is the same with the one in input file, it is considered that the supplier is already existed, then populate ‘Current’ under Column (Supplier Status)
- If supplier is not available on website, populate ‘New’ under Column (Supplier Status)

• If supplier is ‘New’, create it on website by clicking ‘New Supplier’ button,

- Populate ‘Internal Name’ – refer Column External Name in excel file,
- Populate ‘External Name’ – refer Column External Name in excel file,
- Select ‘Industry’ from dropdown list, - refer Column Industry in excel file,
- Populate ‘State’ - refer Column State in excel file,
- Click ‘Save’ Button

• Once done with all suppliers, send an email to yourself with the updated excel file attached