Creating an automation that separates multiple dates into corresponding records in a different table

Hi there,

In an opportunity table I have made a look up field that collects multiple delivery dates of a product into a single cell.

When a condition is changed in the Opportunity Table (to ‘opportunity won’ or ‘sale’) a record is created in the Delivery Schedule Table based on the dates from that cell In the Delivery Schedule Table. The number of records created should correspond to the number of dates from the cell in the Opportunity Table.

But no records are created when there are more than one dates.

Is there a way around this somehow?