On February 26, 2017, Foudy recorded the first multi-point game of his OHL career, as he scored a goal and an assist in an 8–1 win over the Guelph Storm.
On March 24, 2017, Foudy appeared in his first career OHL playoff game, as he had no points in a 4–3 overtime loss to the Windsor Spitfires.
On January 5, 2018, Foudy recorded his first career multi-goal game, scoring twice against Jake McGrath of the Sudbury Wolves in a 5–1 victory.
On November 23, 2018, Foudy recorded his first career three point game in the OHL, as he scored a goal and two assists in a 7–2 win over the Owen Sound Attack.
Later in the season, on January 25, Foudy recorded his first career four point game, as he scored a goal and three assists in a 7–0 win over the Windsor Spitfires.
On November 21, Foudy recorded his second career four point game, as he scored two goals and two assists in a 5–2 win over the Mississauga Steelheads.
Foudy played in his NHL debut against the Tampa Bay Lightning on February 10, 2020, as he was recalled by the Blue Jackets on an emergency basis.
In his second game, Foudy earned an assist on a goal scored by Boone Jenner in a 4–3 loss to the Buffalo Sabres on February 13.
Foudy scored his first career NHL goal in Game 5 of the Qualifying Round of the 2020 Stanley Cup playoffs in a 3–0 victory against the Toronto Maple Leafs.