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.
And I got an error in the ConvertToUTC data
Any ideas?
Many Thanks
S
Solved! Go to 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
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
Many thanks! That was what I was missing
Works perfect now