Microsoft Forms > Sharepoint list > View list as calendar. Can not get date fields to work?

%3CLINGO-SUB%20id%3D%22lingo-sub-200204%22%20slang%3D%22en-US%22%3EMicrosoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200204%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20flow%20that%20works%20like%20this%3C%2FP%3E%3CP%3E1.%20When%20a%20post%20in%20a%20Microsoft%20Form%20is%20submitted%3C%2FP%3E%3CP%3E2.%20Put%20the%20inputted%20data%20from%20the%20form%20in%20a%20Sharepoint%20list%20(form%20contains%20two%20textfield%20and%20two%20date%20filed%20in%20Forms).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20works%20great%20with%20Flow.%3C%2FP%3E%3CP%3EBut%20when%20i%20create%20a%20Calendar%20view%20on%20the%20list.%3C%2FP%3E%3CP%3EThe%20date%20fields%20in%20the%20form%20answers%20are%20not%20recognized%20by%20flow.%3C%2FP%3E%3CP%3EI%20must%20have%20the%20fields%20in%20the%20list%20set%20to%20text%20fields%20and%20not%20date%20fields%20for%20the%20form%20data%20to%20go%20from%20form%20to%20sharepoint%20list....%20but%20if%20i%20dont%20have%20the%20columns%20in%20the%20list%20set%20to%20dates%20i%20can%20not%20use%20those%20dates%20in%20the%20setup%20of%20the%20calendar%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20seems%20like%20a%20bug.%3C%2FP%3E%3CP%3EAnyone%20got%20any%20idea%20of%20how%20to%20work%20this%20out%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-200204%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354517%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354517%22%20slang%3D%22en-US%22%3EI%20took%20this%20example%20and%20everything%20is%20working%20fine!%20Thanks%20%3B)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-324400%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324400%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20managed%20to%20work%20around%20it%20by%20adding%20in%20the%20highlighted%20information%20within%20start%20time%20and%20date%20information%20from%20the%20form.%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20was%20required%20due%20to%20the%20'string'%20information%20needed.%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-324333%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324333%22%20slang%3D%22en-US%22%3E%3CP%3EHowdy%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89819%22%20target%3D%22_blank%22%3E%40Oskar%20Kuus%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20do%20the%20same%20thing%20that%20you%20where%20doing%20with%20forms%20to%20Calendar%2C%20but%20I%20have%20no%20clue%20on%20how%20to%20get%20this%20done.%20Do%20you%20think%20you%20could%20send%20me%20some%20screen%20shots%20for%20something%20to%20help%20me%20acomplish%26nbsp%3Bthis%3F%20Your%20Flow%20seems%20to%20be%20exactly%20what%20I%20am%20trying%20to%20accomplish.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMike%20T%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-290394%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290394%22%20slang%3D%22en-US%22%3E%3CP%3EI%20only%20get%20response%20ID%20as%20an%20option%2C%20despite%20having%20both%20start%20time%20and%20end%20time%20as%20fields%20within%20the%20form.%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%26nbsp%3B%3CSPAN%3Estart%20time%20and%20end%20time%20fields%20are%20free%20text%20-%20is%20there%20an%20time%20option%2C%20as%20there%20is%20a%20date%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3EHelen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-283438%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-283438%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20can%20you%20show%20me%20how%20did%20you%20resolve%20the%20problem%3F%20I%20am%20having%20the%20same%20problem%20as%20you%20before%2C%20I%20can't%20create%20an%20item%20in%20the%20calendar%20using%20the%20data%20from%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20will%20respond.%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200271%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200271%22%20slang%3D%22en-US%22%3E%3CP%3EThink%20i%20got%20things%20to%20work.%3C%2FP%3E%3CP%3EI%20think%20the%20problem%20was%20that%20my%20sharepoint%20site%20had%20the%20wrong%20timezone...%20dont%20know%20how%2Fwhy%20but%20i%20noticed%20it%20when%20trying%20to%20fix%20another%20problem.%20Then%20i%20also%20started%20all%20over%20with%20my%20flow%20and%20created%20all%20new%20lists.%20Now%20i%20can%20put%20in%20the%20dates%20to%20the%20calendar%20from%20the%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20atm%20im%20trying%20to%20set%20things%20up...%20hoping%20it%20will%20work%20in%20the%20end.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200270%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200270%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89819%22%20target%3D%22_blank%22%3E%40Oskar%20Kuus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecould%20you%20please%20give%20us%20a%20screenshot%20of%20your%20list%20setup%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200267%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200267%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20to%20create%20a%20calendar%20in%20sharepoint%20and%20create%20a%20list%20and%20then%20create%20the%20view%20calendar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20i%20have%20also%20tried%20to%20create%20a%20calculated%20field%20in%20the%20list%20to%20transfeer%20the%20date%20from%20the%20text%20field%20to%20a%20new%20column%20that%20is%20a%20date%20field.%20This%20allows%20me%20to%20setup%20the%20calendar%20properly%20so%20the%20start%20and%20end%20time%20is%20based%20on%20those%20dates.%20But%20no%20events%20are%20showing%20up%20in%20the%20calendar%20then...%20(i%20have%20tried%20to%20turn%20on%20time%20and%20date%20and%20only%20date).%20The%20list%20looks%20correct%2C%20but%20nothing%20is%20shown%20in%20the%20calendar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200266%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200266%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20using%20a%20calendar%20list.%20Sounds%20like%20you%20need%20to%20modify%20your%20list%20your%20using%20and%20add%20more%20datetime%20columns%20to%20your%20list%20or%20change%20the%20existing%20one%20to%20datetime%20if%20it%E2%80%99s%20not%20already.%20Make%20sure%20include%20time%20might%20be%20required.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200264%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200264%22%20slang%3D%22en-US%22%3EThats%20so%20wierd.%20I%20got%20the%20exact%20same%20setup%20as%20you%20have.%20But%20i%20do%20not%20get%20my%20date%20fields%20as%20an%20option%20in%20the%20flow%20when%20creating%20an%20item.%20I%20only%20get%20submission%20time.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200244%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200244%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Oskar%2C%20it%20works%20just%20fine%20with%20me%20using%20the%20default%20fields%20to%20a%20SharePoint%20calendar.%20Here%20is%20my%20flow%20example%2C%20make%20sure%20your%20getting%20the%20values%2C%20then%20you%20have%20to%20just%20drop%20down%20the%20extra%20section%20to%20get%20access%20to%20the%20date%20fields.%20they%20plug%20right%20in%20and%20work%20Just%20fine!%20Also%20calendar's%20don't%20show%20in%20the%20pick%20list%20for%20the%20SharePoint%20list%2C%20you%20have%20to%20use%20enter%20custom%20value%20and%20just%20put%20in%20the%20name.%20At%20least%20I%20had%20too%2C%20it's%20an%20older%20calendar%20template.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20854px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35297iA10FDC6D988154D4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222018-06-02_16-38-01.jpg%22%20title%3D%222018-06-02_16-38-01.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35298i5DC3439EC52567FA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222018-06-02_16-38-39.jpg%22%20title%3D%222018-06-02_16-38-39.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200231%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200231%22%20slang%3D%22en-US%22%3ESorry%2C%20thought%20i%20were%20in%20the%20flow%20community.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20guide%20me%20into%20what%20you%20mean%3F%3CBR%20%2F%3EHow%20to%20do%20a%20calculated%20field%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20i%20could%20figure%20out%20how%20to%20transfer%20the%20text%20date%20that%20is%20put%20in%20to%20the%20list%20from%20forms%2C%20to%20a%20new%20date%20column%20in%20the%20list%2C%20that%20would%20solve%20everything.%3CBR%20%2F%3E%3CBR%20%2F%3EIe%20copy%20value%20from%20one%20column%20to%20another%20column.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200230%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20%26gt%3B%20Sharepoint%20list%20%26gt%3B%20View%20list%20as%20calendar.%20Can%20not%20get%20date%20fields%20to%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200230%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89819%22%20target%3D%22_blank%22%3E%40Oskar%20Kuus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhy%20not%20ask%20in%20the%20Flow%20community%3A%20I%20suppose%20there%20you%20can%20have%20a%20big%20help%3B%20however%2C%20do%20you%20have%20seen%20if%20it%20is%20possible%20to%20format%20date%20from%20Microsoft%20Forms%20with%20Workflow%20Definition%20Language%20date%20and%20time%20functions%3F%20Or%2C%20in%20SharePoint%2C%20have%20you%20tried%20to%20create%20a%20calculated%20field%20or%20try%20to%20insert%20a%20formula%20with%20DATE%20in%20th%20text%20field%20that%20you%20have%20to%20us%20as%20date%20field%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

I am trying to create a flow that works like this

1. When a post in a Microsoft Form is submitted

2. Put the inputted data from the form in a Sharepoint list (form contains two textfield and two date filed in Forms).

 

This works great with Flow.

But when i create a Calendar view on the list.

The date fields in the form answers are not recognized by flow.

I must have the fields in the list set to text fields and not date fields for the form data to go from form to sharepoint list.... but if i dont have the columns in the list set to dates i can not use those dates in the setup of the calendar view.

 

This seems like a bug.

Anyone got any idea of how to work this out?

 

13 Replies

Hello @Oskar Kuus

 

why not ask in the Flow community: I suppose there you can have a big help; however, do you have seen if it is possible to format date from Microsoft Forms with Workflow Definition Language date and time functions? Or, in SharePoint, have you tried to create a calculated field or try to insert a formula with DATE in th text field that you have to us as date field?

Sorry, thought i were in the flow community.

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. 2018-06-02_16-38-01.jpg

 

2018-06-02_16-38-39.jpg

Thats 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.
I’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.

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.

 

 

Hello @Oskar Kuus

 

could you please give us a screenshot of your list setup?

Think i got things to work.

I think the problem was that my sharepoint site had the wrong timezone... dont know how/why but i noticed it when trying to fix another problem. Then i also started all over with my flow and created all new lists. Now i can put in the dates to the calendar from the form.

 

So atm im trying to set things up... hoping it will work in the end.

 

Hello can you show me how did you resolve the problem? I am having the same problem as you before, I can't create an item in the calendar using the data from the list.

 

Hope you will respond. Thank you

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

Howdy @Oskar Kuus , 

 

I am trying to do the same thing that you where doing with forms to Calendar, but I have no clue on how to get this done. Do you think you could send me some screen shots for something to help me acomplish this? Your Flow seems to be exactly what I am trying to accomplish. 

 

Thanks, 

 

Mike T

Hi 

I've managed to work around it by adding in the highlighted information within start time and date information from the form. 

This was required due to the 'string' information needed.

Thanks 

 

I took this example and everything is working fine! Thanks ;)