Excel and Microsoft form automation

This is Murali Rajendran. I am working in Singapore as laundry valet attendant in hotel
.In my hotel every day we submit training attendance by 11am .will you do for me this project in UiPath these are the requirements.

1.read the employee name and employee id in the excel sheet based on which date we working on duty .
2. As well read the training topic from excel based the date because every day training topic will change .
3.training attendance created in Microsoft form there is field date ,name,id,department,training topic ,trainer name ,only name and id training topic and trainer needs to type manually rest of them just choose from the Microsoft form in drop down list .

4.training topic in excel format based on date.
I attached training plan for your reference
I like to automate these scenarios every day who are all on duty only using Microsoft form .

I like to learn from you to kick start my career as RPA developer

Training topic is here in excel

Thanks.
Murali Rajendran

Can you provide the Input Excel and Ouptut You expected?

employeelist.xlsx (12.0 KB)
here i attached excel data and below i given google form link .this is the form i like to auto fill from excel data trainer name can be a any name

I see that the Excel is very unstructured,
If you really get the Excel already like that, it’s better before automating it to clean it up first.
Ex.

I dont really get it, what you want.
here what was i’ve done, hope it can help you
TrainingPlan.zip (15.4 KB)

Dear bro
Thanks a lot for your support and help really appreciate your dedication and your helping heart . Once again thank u so much bro now I am learning UiPath because I want switch my career into IT .now I am working in hotel industry in Singapore

You’re welcome,
I recommend taking the course at https://academy.uipath.com/
You can learn a lot there.

Don’t forget to mark as solution.

Sure bro thanks again keep in touch forever

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.