I have an overly simple microsoft forms questionnaire that I will add more to once I have it working. Right now it is simply a text form for your name, a date selection, a start time selection with options (9AM, 10AM, 11AM, 12PM, 1PM) and end time with options (10AM, 11AM, 12PM, 1PM, 2PM). Its used for requesting scheduling for an event. I am not sure if this is even the right way to handle using gather the time data.
I am having 2 problems. One is that when a new response is submitted, it is adding it to my calendar on the wrong day, always tomorrow no matter what I put in. I think I found a fix for that but I can't test it correctly because of my second problem. It is putting in the start time and end time ok though.
My second problem is that whenever I submit a new response, it is resending an earlier response to my calendar rather than a new one. Sometimes it was adding the new one and the original one as I was testing the logic of how automate works as I tweaked it. I only need them to to be added to the calendar one time, and if there is an issue with the time/date a user on my end will change it manually in the calendar. I am curious as to why it would do that. Am I not referencing the submitted new data?
I am also wondering if it is possible for myself or another user to view their requested time slot/date, and approve it before its actually added to the calendar? We wont get very many of these so it is manageable if its not the case.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1