In this work, novel ternary composite ZIF-67/Ag NPs/NaYF4:Yb,Er is synthesized by solvothermal method. The photocatalytic activity of the composite is evaluated by sulfadiazine (SDZ) degradation under simulated sunlight. High elimination efficiency of the composite is 95.4% in 180min with good reusability and stability. The active species (h+, ·O2 - and ·OH) are identified. The attack sites and degradation process of SDZ are deeply investigated based on theoretical calculation and liquid chromatography-mass spectrometry analysis. The upconversion mechanism study shows that favorable photocatalytic effectiveness is attributed to the full utilization of sunlight through the energy transfer upconversion process and fluorescence resonance energy transfer. Additionally, the composite is endowed with outstanding light-absorbing qualities and effective photogenerated electron-hole pair separation thanks to the localized surface plasmon resonance effect of Ag nanoparticles. This work can motivate further design of novel photocatalysts with upconversion luminescence performance, which are applied to the removal of sulphonamide antibiotics in the environment.