Populate a SharePoint calendar from Microsoft Forms via Flow

%3CLINGO-SUB%20id%3D%22lingo-sub-697878%22%20slang%3D%22en-US%22%3EPopulate%20a%20SharePoint%20calendar%20from%20Microsoft%20Forms%20via%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-697878%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20an%20automation%20where%20my%20users%20can%20fill%20out%20a%20Microsoft%20Form%20and%20Flow%20picks%20up%20the%20fields%20and%20puts%20them%20into%20a%20SharePoint%20calendar.%20Now%20when%20Forms%20populates%20the%20calendar%20list%2C%20it%20is%20one%20day%20early%20for%20every%20event%2C%20I%20think%20due%20to%20there%20is%20no%20time%20field%20in%20Forms.%20I'm%20trying%20to%20add%20a%20day%20to%20the%20date%20fields%20in%20Flow%20by%20using%20the%20adddays%20formula%2C%20but%20I%20don't%20know%20how.%20Can%20anyone%20help%20me%2C%20or%20think%20of%20a%20better%20solution%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%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%2F119136i0DF6F6B806CF4A4D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22forms.png%22%20title%3D%22forms.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-697878%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%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-698183%22%20slang%3D%22en-US%22%3ERe%3A%20Populate%20a%20SharePoint%20calendar%20from%20Microsoft%20Forms%20via%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698183%22%20slang%3D%22en-US%22%3EUse%20the%20date%20time%20connector%20and%20convert%20the%20utc%20time%20from%20forms%20to%20your%20timezone%20and%20then%20use%20that%20value%20in%20your%20create%20action%20%3CA%20href%3D%22https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fworking-with-dates-and-times%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fworking-with-dates-and-times%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-713989%22%20slang%3D%22en-US%22%3ERe%3A%20Populate%20a%20SharePoint%20calendar%20from%20Microsoft%20Forms%20via%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-713989%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180%22%20target%3D%22_blank%22%3E%40Alan%20Marshall%3C%2FA%3E%3C%2FP%3E%3CP%3EThanks%20Alan!%20There%20are%20multiple%20time%20zones%20of%20people%20that%20will%20be%20using%20this%20form%20-%20Pacific%20Time%20to%20Eastern%20Time.%20I'm%20not%20sure%20which%20to%20choose.%20Any%20idea%3F%20Do%20I%20choose%20the%20one%20that%20I%20am%20in%20as%20the%20admin%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-714400%22%20slang%3D%22en-US%22%3ERe%3A%20Populate%20a%20SharePoint%20calendar%20from%20Microsoft%20Forms%20via%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-714400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180%22%20target%3D%22_blank%22%3E%40Alan%20Marshall%3C%2FA%3E%3C%2FP%3E%3CP%3EActually%20your%20post%20helped%20very%20much.%20Using%20the%20blog%20article%2C%20I%20was%20able%20to%20use%20the%20Flow%20date%20time%20connector%20for%20%22Add%20to%20time%22%20to%20add%20a%20day%2C%20and%20now%20my%20process%20works%20perfectly.%20Thank%20you!%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fworking-with-dates-and-times%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fworking-with-dates-and-times%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have an automation where my users can fill out a Microsoft Form and Flow picks up the fields and puts them into a SharePoint calendar. Now when Forms populates the calendar list, it is one day early for every event, I think due to there is no time field in Forms. I'm trying to add a day to the date fields in Flow by using the adddays formula, but I don't know how. Can anyone help me, or think of a better solution?

forms.png

3 Replies
Use the date time connector and convert the utc time from forms to your timezone and then use that value in your create action https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/

@Alan Marshall

Thanks Alan! There are multiple time zones of people that will be using this form - Pacific Time to Eastern Time. I'm not sure which to choose. Any idea? Do I choose the one that I am in as the admin?

 

Thanks so much! 

@Alan Marshall

Actually your post helped very much. Using the blog article, I was able to use the Flow date time connector for "Add to time" to add a day, and now my process works perfectly. Thank you! 

https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/