web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Convert text to date: ...
Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by Sam4 229

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

I have the same question (0)
  • Verified answer
    v-zhos-msft Profile Picture
    v-zhos-msft on at
    Re: Convert text to date: MS Form date entry > Convert text to Date > store in SharePo

    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#convertToUtc

    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

  • Sam4 Profile Picture
    Sam4 229 on at
    Re: Convert text to date: MS Form date entry > Convert text to Date > store in SharePo

    Many thanks! That was what I was missing 

     

    Works perfect now Smiley Happy

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans