Stuck on "Step Pending" when running a script thro...

[Temima]

I'm scratching my head here, if anyone can help!

I have an automation to update a record when a linked record is created. 

For the Record ID in the Update Record step, I'm using a linked field from the previous step, set up as follows:

It works perfectly when I run tests, on both preview and run as configured. 

But in real life, it keeps failing on "Received Invalid Inputs" and when I check, I see the Record ID isn't getting passed through.

EDITED TO ADD: I have another automation set up the same way, except the trigger is "When record updated" and it works fine. 

What am I doing wrong?

[TheTimeSavingCo]

Could you provide screenshots of the full automation as well as of the tables?  If you could provide a read-only invite link to a duplicated copy of your base with some example data that'd be easiest, troubleshooting via screenshots is quite difficult

[Temima]

Sure, here is the read-only link: https://airtable.com/invite/l?inviteId=invOgweVwSoOhh9eI&inviteToken=9ca583dfe0772878ecaea39e5a31972...

The automation in question is this: https://airtable.com/appvpJSD9xyU03Kex/wflyp7hCir8SbafKB

I ran a test on example data so you can see the successful test + unsuccessful automation run.

Your help is much appreciated!