Convert text to date: MS Form date entry > Convert text to Date > store in SharePoint List

[Sam4]

Hi I'm trying to configure a flow to get some responses from a MS Form and store the response in a SharePoint List.

I think there is not a major problem with the text fields but I have a "date" entry that is not accepted. 

I'm trying to convert it using "Compose" but it doesn't work... and I think I'm missing something really simple.

1. When a new response is submitted
2. Getting Response
3. Compose (Meeting Date field)
4. Compose 2: ConvertToUTC(Compose)
5. M_Date (SharePoint) --> Output Compose 2

And I got an error in the ConvertToUTC data

Any ideas?

Many Thanks

S

[v-zhos-msft · Accepted solution]

Hi Sam4,

I think you need give a <sourceTimeZone> to the convertToUtc function.

Please first take a check here: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#c...

Specially: convertToUtc('<timestamp>', '<sourceTimeZone>', '<format>'?)

I have made a flow for your scenario, please check it for a reference.

The expression is: convertToUtc(actionOutputs('Compose'),'Pacific Standard Time')

Please feel free post back if you need more help.

Best regards,

Zhonys

[Sam4]

Many thanks! That was what I was missing 

Works perfect now