My employees currently sign up for overtime by responding via email with the dates they want to sign up for.
I would like to automate this procedure by creating a monthly sign up sheet via Forms, within a Teams Channel, with all available dates using multiple choices. It would be one question with all the dates as multiple choices.
I have an excel spreadsheet with the dates in separate columns. I want the excel sheet to display the users name under each date selected.
For example: if I selected 1/2 and 1/10, my name would populate in excel under the column named 1/2 and in the column named 1/10.
is this possible?
Also is there a way to simplify updating this on a monthly basis for someone who isn’t that savvy with power automate?
