cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted

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!

Highlighted

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')

Highlighted

@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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (3,749)