Forum Discussion
SharePoint Calendar populated from MS Forms
I am trying to create a flow When a form is submitted from MS Forms it will populate into a Sharepoint Calendar. I am able to create these items on the calendar the only issue I have is it is creating the event starting with the submission date. I need it to populate with the 'Date Reserved' up until 'Date Returned'.
Thank you in advance for your help!
Hi CodeMaestroJuan - do you have a requirement forcing you to use Forms rather than entering information into the destination list to begin with? Is the SharePoint Calendar/destination list a custom list or the out of the box Events list? I'm thinking that having someone enter into a List with a true time/date field will work much better than entering the data into Microsoft Forms, but will wait for more info from you.
Hi CodeMaestroJuan , everything coming from a Form is interpreted as text, which makes populating date fields in SharePoint a special case.
You need to convert the incoming Form response data to a compatible date format using an expression, e.g.
formatDateTime(outputs('Get_response_details')?['body/r2006259744d54a7b96e8339b777fg1d7'])
The long code (here beginning r2006) is the question response ID and can be found in the output of the 'Get response detail' action.
In your case you will need the IDs for both Form responses.
