Constraints on the cosmological constant from flows and supernovae