Hello,
I’m sure there is another way to do this, but using the FPS template you could modify the projectile Blueprint to something like this:
The section in yellow was added and stops the projectiles movement once generating a Hit and attaches it to the Hit object.
-W