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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / gSheet Date Picker - F...
Power Automate
Answered

gSheet Date Picker - Flow - SharePoint new Item

(0) ShareShare
ReportReport
Posted on by

Hello

I appreciate that there is a heap of posts about date string manipulation, but I haven't found anything that work; hope someone has come up against a similar issue as the one below.

 

I have a google form which has a date picker, which populates a gSheet. The format of the date is (New Zealand) dd/MM/yyyy

I can retrieve those rows into a Flow without any issue.

When it comes to utilising that date value as a field in a New Sharepoint item, the process fails. 

 

I can see that the date format to populate a Sharepoint item needs to be yyyy-MM-dd 

The value from the gSheet is a string, not a date. 

How does one go about manipulating the date (as a string) and convert to an acceptable date format that a new Sharepoint item flow will accept.

 

Currently, I'm going into the gSheet each day, and changing the formatting of the cells I need processing. 

regards

 

Categories:
  • Verified answer
    v-duann-msft Profile Picture
    Microsoft Employee on at

    Hi @LukePWilkins 

     

    Thank you for posting.

     

    According to your description, you would like to get correct date format acceptable for sharepoint list. If any misunderstanding, please kindly let me know.

     

    Since you want to convert string to date and format it to ‘yyyy-MM-dd’. We can use compose action to achieve it. I assume your output date is 23/03/2021 as string.

     

    Here is the flow steps for your reference:

    v-duann-msft_0-1616484206356.png

     

    Related expressions in order:

    For day: first(split(outputs('output_from_Gsheet'),'/'))

    For month: first(skip(split(outputs('output_from_Gsheet'),'/'),1))

    For year: last(split(outputs('output_from_Gsheet'),'/'))

    For the whole date: formatDateTime(concat(outputs('month'),'-',outputs('day'),'-',outputs('year')),'yyyy-MM-dd')

     

    after that, I’m able to get correct date format as below:

    v-duann-msft_1-1616484206361.png

     

    Hope the content above may help you.

     

    Thanks

    Anna

  • LW-28112008-0 Profile Picture
    on at

    Thanks for this Anna, I will give it a go!

  • LW-28112008-0 Profile Picture
    on at

    You are a genius Anna! Thank you. That has worked...

     

    I have learnt something new today

     

    Thank you!!!

  • v-duann-msft Profile Picture
    Microsoft Employee on at

    Hi @LukePWilkins 

     

    Thanks for confirmation. Glad to hear it works for you. 😀

     

    Have a good day !

     

    Best wishes,

    Anna

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 292 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 128

Last 30 days Overall leaderboard