Creating a new record automation

I have an automation to create a record in Table B when a record in Table A is updated.
The details are for when a vendor applies (their info gets dumped into Table A) then when we change the status to “approved” their record gets created in Table B. Here is my issue…

We have status updates for markets in June + August + October… if I change the status for June to approved the record is created in Table B but then the status updates for August and October are not populated.

If I do “waitlist” for June and “approved” for August and October - the record is created in Table B for this vendor and the status for June and August is populated - but then October is blank.

Basically it creates it at the first “approved” update but the rest are left out… is there a way to make sure all the values/status updates are populated when the record is created?

Screenshots of the automation I have created:


Uploading: Screen Shot 2022-02-23 at 12.20.57 PM.png…