In this Unreal Engine 5.4 tutorial, you will learn how to convert a static mesh into a fluid simulation, bake it out as a 3D Volume Texture, and sample that volume texture inside Niagara to drive particles!
https://dev.epicgames.com/community/learning/tutorials/Ebvjd/mesh-to-volume-texture-to-particles-in-unreal-engine-5-4-niagara-tutorial