Periods of torrential rain could lead to isolated flash flooding across Metro Detroit before excessive heat and severe storm potential builds midweek.