Forum Discussion
Convert Excel DateTime for Create item SP List Creation
Phishdawg in your Excel list rows present in a table action you need to open the advanced options and in the dateTime Format field select ISO 8601. It will then bring the dates over in the correct format that you can use in your create item action.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Phishdawg Check if using formatDateTime function helps as given here: Power automate, copying date column from online excel to SharePoint list
Example:
formatDateTime('10/30/2023')
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs