Forum Discussion
Microsoft Forms > Sharepoint list > View list as calendar. Can not get date fields to work?
Can you guide me into what you mean?
How to do a calculated field?
If i could figure out how to transfer the text date that is put in to the list from forms, to a new date column in the list, that would solve everything.
Ie copy value from one column to another column.
Hey Oskar, it works just fine with me using the default fields to a SharePoint calendar. Here is my flow example, make sure your getting the values, then you have to just drop down the extra section to get access to the date fields. they plug right in and work Just fine! Also calendar's don't show in the pick list for the SharePoint list, you have to use enter custom value and just put in the name. At least I had too, it's an older calendar template.
- MantasSeFeb 21, 2019Copper ContributorI took this example and everything is working fine! Thanks ;)
- Oskar KuusJun 03, 2018Iron ContributorThats so wierd. I got the exact same setup as you have. But i do not get my date fields as an option in the flow when creating an item. I only get submission time.
- DeletedJun 03, 2018I’m using a calendar list. Sounds like you need to modify your list your using and add more datetime columns to your list or change the existing one to datetime if it’s not already. Make sure include time might be required.
- Oskar KuusJun 03, 2018Iron Contributor
I have tried to create a calendar in sharepoint and create a list and then create the view calendar.
Now i have also tried to create a calculated field in the list to transfeer the date from the text field to a new column that is a date field. This allows me to setup the calendar properly so the start and end time is based on those dates. But no events are showing up in the calendar then... (i have tried to turn on time and date and only date). The list looks correct, but nothing is shown in the calendar.
- Helen Carver-WilliamsNov 22, 2018Copper Contributor
I only get response ID as an option, despite having both start time and end time as fields within the form.
However, start time and end time fields are free text - is there an time option, as there is a date?
Thanks
Helen