Below is the excel file sample data.
Employee Name | Department Name | Joining date |
---|---|---|
Kumar | Legal | 01-07-20 |
Santosh | IT | 18-08-20 |
Ranu | Finance | 15-05-20 |
Department name is drop down feature in Microsoft forms and Joining date is calendar date feature in Microsoft forms.
Below is the survey link that i have used to record responses.
Output file
Sample output file Microsoft forms Automation.xaml (15.0 KB)