Solved: Date conversion from CSV to SharePoint

Date conversion from CSV to SharePoint

Hello everyone! I'm working on a flow that aims to migrate records to a sharepoint list.

The flow follows the following steps:
1. Receive the CSV file
2. Rebuild the files with a 'Select'
3. Iterate over each record with an 'Apply to each'
4. Apply a series of filters.
5. Save the current record in a variable of type array ('registroArrayFecha').
6. Format the date1
7. Format the date2
8. Evaluate which date is larger with a condition.
9. Create item in sharepoint list and export the record.

The structure of the record saved in the variable ('registroArrayFecha') would be something like this:

[
 {
 "Resource Name": "User, Name",
 "Work Order": "17992541",
 "Work Country": "Spain",
 "Start Date": "21-2-23",
 "Created Date": "9-2-23",
 }
]

The first problem occurs in point 6, when I try to extract the value of 'Start Date' from the variable 'registroArrayFecha' and give it a format to be able to later evaluate this date in a condition.

The expression I use to give this format is the following: (This expression is inside a 'Compose')

formatDateTime(concat('20',
split(variables('registroArrayFecha')[0]['Start Date'], '-')[2], '-',
split(variables('registroArrayFecha')[0]['Start Date'], '-')[1], '-',
split(variables('registroArrayFecha')[0]['Start Date'], '-')[0]),
'dd-MM-yyyy')

The error occurs in certain records. On the one hand we have records in which the date is maintained, for example:

Correct conversion