Connect a Form to a SharePoint Calendar accurately using Flow

%3CLINGO-SUB%20id%3D%22lingo-sub-697842%22%20slang%3D%22en-US%22%3EConnect%20a%20Form%20to%20a%20SharePoint%20Calendar%20accurately%20using%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-697842%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20automation%20where%20my%20users%20can%20fill%20out%20a%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%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F119125iB27DC96CE586C08E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22forms.png%22%20title%3D%22forms.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-697842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

I have an automation where my users can fill out a 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

 

0 Replies