A complete picture of the reaction mechanism driving the photocatalytic reduction of CO2into formate promoted by the Zr-based porphyrinic MOF-545 in CH3CN/TEOA solutions is provided for the first time by combining experimental and computational approaches.