In this video, I show a simple workaround to change the Texture Coordinate Index from a material instance, so we can control which UV channel of the mesh is used!
https://dev.epicgames.com/community/learning/tutorials/446r/how-to-control-texture-coordinates-from-the-material-instance-in-unreal-engine-5