cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mishatandon
Helper III
Helper III

Date field not getting updated from Excel online sheet to Sharepoint

Hello community,

 

How to upload data in a 'date' field from excel sheet to 'Sharepoint list'? The date format in excel sheet is dd/mm/yyyy and data type in Sharepoint is 'Date and time'

 

I am able to successfully upload data from excel to SP for everyother field basis the attached flow but facing issues with the 'Date' fieldFlow image 1.pngFlow image 2.pngFlow image 3.pngData type on sharepoint.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @Mishatandon ,

 

It is the expected behavior since the Date time in Microsoft flow would be a number value such as "43070", we need to format the value to date type with expression below:

formatDateTime(addDays('1900-01-01',add(int(items('Apply_to_each')?['Date']),-2)),'yyyy-MM-dd')

 1.png

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-alzhan-msft
Community Support
Community Support

Hi @Mishatandon ,

 

It is the expected behavior since the Date time in Microsoft flow would be a number value such as "43070", we need to format the value to date type with expression below:

formatDateTime(addDays('1900-01-01',add(int(items('Apply_to_each')?['Date']),-2)),'yyyy-MM-dd')

 1.png

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thanks Alice.

 

I am yet to test but wanted to clarify I have date in format dd/mm/yyyy, would the above formula still hold?

 

Thanks!

Also in the formula where should in put the column name - 'Date of Actual Commissioning (Date input format DD/MM/YYYY) Provided in Q1 March 2020 '  to be converted to dd/mm/yyyy type?

 

formatDateTime(addDays('1900-01-01',add(int(items('Apply_to_each')?['Date']),-2)),'yyyy-MM-dd')

@v-alzhan-msft ,

 

Getting the error:

 

Unable to process template language expressions in action 'Create_item' inputs at line '1' and column '2308': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (26,804)