I got it to work on a FLEX Consumption plan. I deployed the exact same zip file (using azure cli) to two functions, one one FLEX and one on normal consumption plan. On the Consumption plan it still produces the original error, module not found, while on the flex plan it deploys successfully. must be a bug