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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / String to Date Sharepo...
Power Automate
Unanswered

String to Date Sharepoint list

(0) ShareShare
ReportReport
Posted on by 2

I have a flow that gets the items from CSV to Sharepoint. The main problem is the DATE field from CSV is in string format while the field on sharepoint is set to Date Only. Any idea on how I can fix this?

Categories:
I have the same question (0)
  • yiyingjiao Profile Picture
    Microsoft Employee on at
    Hi @yawa619 
    I used addDays method in expressions:
     
    addDays('1899-12-30', int(items('Apply_to_each')?['Birthday']),'yyyy-MM-dd')
     
    This is inside an "apply to each" loop where I went through every row in the CSV file and extracted the birthday entry which is in string format. This returns a datetime object. Here's a screenshot of the flow. Please let me know if you have any questions!

     

    Yiying Jiao

    Support Engineer

    Microsoft Power Platform

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly! Have a great day!

     
    Screenshot 2022-06-09 002438.png

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

Forum hierarchy changes are complete!

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

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#3
David_MA Profile Picture

David_MA 270 Super User 2025 Season 2

Last 30 days Overall leaderboard