I’ve created a Change Management System in our SharePoint Online environment that involves InfoPath forms, SharePoint Designer workflows, and three separate SharePoint lists. My question is when a user goes to create a change management request and loads the first form I’ve added a Start Date and End Date field for them to select. When I added the Date/Time column to the list it only let me select a single date and so I had to create two columns.
What I’d like to know how to do is after the user fills out the form and selects a start and end date, how can I get that date info to transfer over to the SharePoint calendar on our team site?
Is there something I need to add to the workflow of that first list in order to accomplish that?
Any help would be greatly appreciated.
Here’s a screenshot of what the first form looks like when a user creates a request.
I ended up making the start/end dates required and then added an Add Calendar field with yes/no. That way users can choose if they want the event to be added to the calendar. Thanks Anj.
What if you should try add in your workflow like “If Start Date” is blank” then that’s your email without start date/end date. Else Start Date is not empty put it in the calendar, or the other way around. You will always have a date/time like this  1/10/10001 1:00am if it is empty.Â
My only hesitation with that is I don’t want every change management request to create a calendar event. We want it to only be for maintenance windows. It’d be nice if the email would only display the start/end dates if it had information entered. If the user leaves the dates blank the workflow still works it’s just I’m trying to also have the ability for the dates to show up in the emails.
Hi Jeremy,
You should make your start/end date required. When creating the column for that, tick the “Require that this column contains information”, and because you created this column, you can’t see this options.Â
You should try the setup below in InfoPath instead:
1. Right click your date/time fields under “Fields”
2. Then properties, and tick “Cannot be blank” and click OK.
Start/Date displays 1/10/10001 1:00am  because it is null.Â
Adding a create list item calendar step did the trick thank you Anj.
My next question is If someone doesn’t enter a start/end dates how can I setup my workflow to send an email without start/end dates and then to send one based on if there is start/end dates entered.
The way I have it setup now I have an email sent out that I include Current Item Start and End Dates as part of the email reported as a string. Which works great if they enter a start/end date. But if they don’t enter a start/end date it displays in the email as 1/10/10001 1:00am for those fields.
