I have an MS Form that is collecting Time Off information that is then saved into a SharePoint List, then added to a group calendar. My issue is that since there is only a Date Field in MS Forms, I need to be able to capture times requested off, for instance a couple of hours or 1/2 day to add that to the calendar showing the desired time off. Date works, but since there isn't a way on the form (which maybe there is) to enter in the times requesting off. The Flow just updates the SharePoint Date/Time field with a time that is not what is being requested.
Would there be a good way to get the time information from MS Forms to the SharePoint list?
Hello @kwilliams ,
there's no direct way how to add time to the date in MS Forms, but you could add another 2 'choice' questions, From and To, and configure available times as choices in these questions.
From:
8:00
9:00
10:00
...
To:
8:00
9:00
...
The you could combine it with the Date and update it to the SharePoint.
I could do that, but for now I'm having another issue, when I add the Dates to my SharePoint List, it is doing some type of conversion where it is a day behind. For instance if I select the Date on the Form to be 09/30/2021, when it creates the item on my SharePoint List it is 09/29/2021. I added a convert time action to my flow, but it is still adding it as a day behind.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
27 | |
23 | |
17 | |
10 |
User | Count |
---|---|
64 | |
55 | |
29 | |
27 | |
25 |