You can try this snippet: Kill Niagara particles after collision | Unreal engine Code Snippet
Just paste it in your stack.