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
Solved! Go to 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.
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.
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')
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.'.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
41 | |
40 | |
37 | |
34 | |
30 |
User | Count |
---|---|
47 | |
37 | |
35 | |
24 | |
24 |