cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yawa619
Regular Visitor

String to Date Sharepoint list

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?

1 REPLY 1
yiyingjiao
Microsoft
Microsoft

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,796)