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.'.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
User | Count |
---|---|
77 | |
18 | |
17 | |
14 | |
11 |
User | Count |
---|---|
133 | |
33 | |
31 | |
31 | |
24 |