Form Date extracting data to sharepoint using flow etc.

%3CLINGO-SUB%20id%3D%22lingo-sub-239589%22%20slang%3D%22en-US%22%3EForm%20Date%20extracting%20data%20to%20sharepoint%20using%20flow%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239589%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20form%20called%20%22Report%20work%20dates%22%3C%2FP%3E%3CP%3EIn%20this%20form%20i%20use%20the%20question%20type%20%22dates%22%20so%20the%20user%20can%20pick%20a%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20i%20use%20Microsoft%20Flow%20to%20extract%20the%20data%20from%20the%20Form%20and%20us%20that%20data%20to%20input%20into%20a%20list%20in%20Sharepoint.%3C%2FP%3E%3CP%3EBut%20in%20sharepoint%20i%20must%20select%20a%20TEXT%20column%20in%20the%20list%20for%20the%20date%20to%20be%20imported%20to%20the%20list%20with%20Flow.%3C%2FP%3E%3CP%3EI%20can%20not%20make%20the%20date%20from%20Forms%20go%20into%20a%20Date%20column%20in%20sharepoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20means%20i%20can%20not%20populate%20a%20sharepoint%20calendar%20with%20a%20Form%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20sucks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-239589%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-878614%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Date%20extracting%20data%20to%20sharepoint%20using%20flow%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878614%22%20slang%3D%22en-US%22%3E%3CP%3E%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%3BJust%20wondering%20if%20you%20made%20any%20progress%20with%20this%3F%20I've%20got%20the%20same%20issue%20extracting%20the%20date%20from%20MS%20Forms%20and%20inputting%20this%20as%20a%20list%20item.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2172840%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Date%20extracting%20data%20to%20sharepoint%20using%20flow%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2172840%22%20slang%3D%22en-US%22%3E%3CP%3E%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelo%2C%20I%20have%20the%20same%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20answer%20about%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2172923%22%20slang%3D%22en-US%22%3ERe%3A%20Form%20Date%20extracting%20data%20to%20sharepoint%20using%20flow%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2172923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F981386%22%20target%3D%22_blank%22%3E%40edsonvmendes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20offer%20two%20things%20here%20that%20may%20be%20of%20help.%26nbsp%3B%20%26nbsp%3BI've%20had%20to%20transform%20the%20date%20format%20that's%20captured%20in%20Forms%20before%20so%20that%20it%20can%20be%20inserted%20into%20SharePoint%3C%2FP%3E%3COL%3E%3CLI%3EUse%20the%20ConvertTimeZone%20action%20in%20your%20Flow%20to%20convert%20the%20Flow%20captured%20date%20into%20the%20correct%20format%20(%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Ftopic%2Fconverting-time-zone-in-microsoft-power-automate-8bce2441-1859-4d76-2f51-985d9c96534d%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Edetailed%20here%3C%2FA%3E)%3C%2FLI%3E%3CLI%3EEnsure%20that%20your%20SharePoint%20DateTime%20field%20is%20set%20to%20Date%20only%3C%2FLI%3E%3C%2FOL%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

I have a form called "Report work dates"

In this form i use the question type "dates" so the user can pick a date.

 

Then i use Microsoft Flow to extract the data from the Form and us that data to input into a list in Sharepoint.

But in sharepoint i must select a TEXT column in the list for the date to be imported to the list with Flow.

I can not make the date from Forms go into a Date column in sharepoint.

 

This means i can not populate a sharepoint calendar with a Form answer.

 

This sucks!

3 Replies

@Oskar Kuus Just wondering if you made any progress with this? I've got the same issue extracting the date from MS Forms and inputting this as a list item.

@Oskar Kuus 

 

Helo, I have the same issue.

 

any answer about this?

 

@edsonvmendes 

 

I'd offer two things here that may be of help.   I've had to transform the date format that's captured in Forms before so that it can be inserted into SharePoint

  1. Use the ConvertTimeZone action in your Flow to convert the Flow captured date into the correct format (detailed here)
  2. Ensure that your SharePoint DateTime field is set to Date only

Hope that helps