Working with Niagara to learn a few things so I made a system that uses the Mesh Reproduction Sprite module to dissolve the character when they step on the trigger. This uses a Curl Noise module and a finite lifetime so it could be used in a game for a death effect.
We dissolve when we die UE5 Niagara