Okay! Hmm. So I think what you need to do is use the “Spawn Niagara Particle system” and Parent it to the hit actor’s skeletal mesh on the impact point. Try something like this:
See if that gives you any forward movement towards your end goal and get back with us! 