The presence of hexavalent chromium water pollution is a growing global concern. Among the currently applied technologies to remove CrVI, its adsorption and photocatalytic reduction to CrIII less mobile and toxic forms are the most appealing because of their simplicity, reusability, and low energy consumption. However, little attention has been paid to bifunctional catalysts, that is, materials that can reduce CrVI to CrIII and retain both hexavalent and trivalent chromium species at the same time. In this work, the dual CrVI adsorption–reduction capacity of two iconic photoactive water-stable zirconium and titanium-based metal–organic frameworks (MOFs) has been investigated: UiO-66-NH2 and MIL-125. The bifunctionality of photoactive MOFs depends on different parameters, such as the particle size in MIL-125 or organic linker functionalization/defective positions in UiO-66 type sorbents. For instance, the presence of organic linker defects in UiO-66 has shown to be detrimental for the chromium photoreduction but beneficial for the retention of the CrIII phototransformed species. Both compounds are able to retain from 90 to 98% of the initial chromium present at acidic solutions as well as immobilize the reduced CrIII species, demonstrating the suitability of the materials for CrVI environmental remediation. In addition, it has been demonstrated that adsorption can be carried out also in a continuous flux mode through a diluted photoactive MOF/sand chromatographic column. The obtained results open the perspective to assess the bifunctional sorption and photoreduction ability of a plethora of MOF materials that have been applied for chromium capture and photoreduction purposes. In parallel, this work opens the perspective to develop specific chemical encoding strategies within MOFs to transfer this bifunctionality to other related water remediation applications.