Export data from Forms and Import to Sharepoint Calendar with Flow?

%3CLINGO-SUB%20id%3D%22lingo-sub-251292%22%20slang%3D%22en-US%22%3EExport%20data%20from%20Forms%20and%20Import%20to%20Sharepoint%20Calendar%20with%20Flow%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251292%22%20slang%3D%22en-US%22%3E%3CP%3EHey%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20i%20use%20flow%20to%20extract%20data%20from%20a%20Microsoft%20Forms%20and%20then%20Insert%20data%20to%20a%20Sharepoint%20calednar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20form%20i%20have%201%20question%20that%20ask%20for%20a%20date.%3C%2FP%3E%3CP%3EThis%20is%20the%20date%20that%20i%20want%20to%20create%20an%20event%20in%20a%20sharepoint%20calendar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEverything%20seems%20to%20work%20great.%20But%20then%20i%20realise%20that%20the%20date%20that%20comes%20from%20Forms%20is%20just%20plain%20text.%3C%2FP%3E%3CP%3EAnd%20i%20can%20not%20import%20plain%20text%20into%20a%20date%20field%20in%20a%20sharepoint%20calendar%20(or%20sharepoint%20list).%3C%2FP%3E%3CP%3ESo%20i%20can%20not%20specify%20the%20date%20that%20the%20event%20should%20be%20created%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20to%20change%20the%20format%20of%20the%20data%20in%20flow%20and%20then%20import%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-251292%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251548%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20data%20from%20Forms%20and%20Import%20to%20Sharepoint%20Calendar%20with%20Flow%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251548%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20actually%20i%20solved%20this%20in%20a%20wierd%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20not%20take%20the%20date%20directly%20from%20forms%20and%20input%20into%20the%20calendar.%3C%2FP%3E%3CP%3EBut%20if%20i%20first%20created%20a%20list%20with%20columns%20of%20the%20data%20i%20wanted%20in%20the%20calendar.%3C%2FP%3E%3CP%3EThen%20i%20could%20move%20the%20data%20from%20the%20list%20to%20the%20calendar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20now%20my%20flow%20works%20and%20works%20like%20this%3A%3C%2FP%3E%3CP%3EWhen%20form%20is%20being%20completed%20%26gt%3B%20move%20data%20to%20list%20in%20sharepoint%20%26gt%3B%20move%20data%20to%20calendar%20i%20sharepoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnly%20downside%20now%20is%20that%20the%20date%20field%20in%20Microsoft%20Forms%20can%20not%20indicate%20Times.%3C%2FP%3E%3CP%3EAnd%20there%20is%20no%20timeselector%20in%20Forms%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%20one%20step%20closer%20to%20a%20perfect%20world%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251464%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20data%20from%20Forms%20and%20Import%20to%20Sharepoint%20Calendar%20with%20Flow%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251464%22%20slang%3D%22en-US%22%3E%3CP%3EUsually%20you%20can%20put%20your%20cursor%20in%20the%20field%20you%20want%20to%20put%20the%20date%20in%20in%20SharePoint%20then%20select%20%22See%20more%22%20from%20your%20list%20of%20available%26nbsp%3B%20Dynamic%20Content%20from%20Forms%20and%20you%20can%20put%20the%20date%20in%20anyways%20if%20it%20is%20in%20the%20right%20format.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251409%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20data%20from%20Forms%20and%20Import%20to%20Sharepoint%20Calendar%20with%20Flow%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251409%22%20slang%3D%22en-US%22%3E%3CP%3EHi%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%3EYou%20could%20use%20a%20similar%20approach%20to%20what%20we%20used%20in%20our%20other%20thread%20with%20regards%20to%20using%20an%20expression.%20I%20don't%20know%20what%20the%20format%20of%20your%20date%20is%2C%20when%20in%20string%20format%2C%20but%20I%20would%20be%20looking%20to%20use%20the%20formatDateTime%20expression%20and%20formatting%20it%20in%20the%20required%20way%20e.g.%20yyyy-MM-dd%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Hey

 

How can i use flow to extract data from a Microsoft Forms and then Insert data to a Sharepoint calednar.

 

In my form i have 1 question that ask for a date.

This is the date that i want to create an event in a sharepoint calendar.

 

Everything seems to work great. But then i realise that the date that comes from Forms is just plain text.

And i can not import plain text into a date field in a sharepoint calendar (or sharepoint list).

So i can not specify the date that the event should be created on.

 

Is there anyway to change the format of the data in flow and then import it?

3 Replies
Highlighted

Hi @Oskar Kuus

 

You could use a similar approach to what we used in our other thread with regards to using an expression. I don't know what the format of your date is, when in string format, but I would be looking to use the formatDateTime expression and formatting it in the required way e.g. yyyy-MM-dd

Highlighted

Usually you can put your cursor in the field you want to put the date in in SharePoint then select "See more" from your list of available  Dynamic Content from Forms and you can put the date in anyways if it is in the right format.  

Highlighted

Yes actually i solved this in a wierd way.

 

I could not take the date directly from forms and input into the calendar.

But if i first created a list with columns of the data i wanted in the calendar.

Then i could move the data from the list to the calendar.

 

So now my flow works and works like this:

When form is being completed > move data to list in sharepoint > move data to calendar i sharepoint.

 

Only downside now is that the date field in Microsoft Forms can not indicate Times.

And there is no timeselector in Forms :(

 

Well one step closer to a perfect world :)