Yes, in scratchpad. You can basically just re-create the exact same logic that you are doing in the shader to dissolve the mesh, but in Niagara. Niagara can also sample textures etc. If you need specific help about it, post your dissolve shader logic here and we can rebuild it in Niagara together
Another method you could try, is using the GBuffer. This will make it view dependent however.
I have done this here:
