Forum Discussion
Solved
Convert Excel DateTime for Create item SP List Creation
I have issue creating a new SP List from Excel with Power Automate. I can get all of the column to come over except the DateTime formatted columns, shown below. Excel Sheet Screenshot - If you ...
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 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