Thanks net8floz for the reply, I managed to get a decent enough work around for the problem. I took this as an opportunity to delve into custom nodes. I made a custom SpawnPrefab node which takes in all the standard variables but allows you to setup Blackboard values dynamically. I have added the code below for completion sake.
Although I have to admit I am still confused as to why the standard flow script method doesn’t actually work. It seems to me that there may be something wrong with the Instantiate method where its not properly returning the instantiated object. Regardless, what I needed was to set Blackboard variables the moment the object is instantiated. The reason for that is because on Update the spawned bullet will check if its Target is null and destroy itself. I dont think running a method to setup the variable would of solved that minor complication.
Without any further ranting, below is my node and attached is a show of it in use.