Importing dates from Excel into Sharepoint list

TSimsDFor other who are looking for an answer, you can use the following tip : in the "List rows prensent in a table" card, expand the advanced options and select "ISO 8601" in the date / format option.

I have had a similar issue with dates in all formats in Excel formatting to numbers in SharePoint lists. I found a simple solution. 

Did you format yours individual fields after importing but before creating the list. At this stage, SharePoint displays your fields and you have the option to change each field before creating your list. When I clicked on the relevant field it gave the option to change to date and time field. Then, after creating the list, I could remove the time option in the field drop down column settings -edit - remove time' option. However, it only displays the date in US format.  TSimsD 

TSimsD Excel stores dates as an integer of the number of days since 30 December 1899. So you need to convert that integer to a date before your flow can use the output in SharePoint.

So you will need to add Compose control.

The table in my spreadsheet has a column called Time:

In your flow you'll need to convert that column using an expression in a Compose control:

formatDateTime(addDays('1900-01-01', add(int(items('Apply_to_each')?['Time']),-2)), 'yyyy-MM-dd')

(the way I do it is to use 1900-01-01 for ease of remembering rather than 1899-12-30, then take off 2 days from the result)

You then use the output of that Compose in the relevant field in your SharePoint Create item action.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

TSimsD 

Note the example shown is a test file I'm using as the working sheet is too large to easily manipulate