Forum Discussion
CodeMaestroJuan
Jan 11, 2024Copper Contributor
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 creatin...
Jon_Lake
Jan 12, 2024Brass Contributor
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.