Date field not getting updated from Excel online sheet to Sharepoint

[Mishatandon]

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

[v-alzhan-msft · Accepted solution]

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

 

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.

[Mishatandon]

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!

[Mishatandon]

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

[Mishatandon]

@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.'.