Below is the excel file sample data.
|Employee Name||Department Name||Joining date|
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.
Sample output file Microsoft forms Automation.xaml (15.0 KB)