cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sam4
Resolver I
Resolver I

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

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?

 

 

Capture1.JPGCapture 2.JPG

 

Many Thanks

S

1 ACCEPTED SOLUTION

Accepted Solutions
v-zhos-msft
Solution Sage
Solution Sage

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')

1.png2.png

Please feel free post back if you need more help.

Best regards,

Zhonys

View solution in original post

2 REPLIES 2
v-zhos-msft
Solution Sage
Solution Sage

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')

1.png2.png

Please feel free post back if you need more help.

Best regards,

Zhonys

View solution in original post

Many thanks! That was what I was missing 

 

Works perfect now Smiley Happy

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,279)