if someone sends you a Microsoft Teams chat or @ mention on teams they get an automated reply for out of office, vacation etc.
Please, please, please add triggers for updates to google sheets. Please. Please. Don't make me leave this wonderful world of power automate because of this key missing piece.
I think MS had it at one time but removed it. As an earlier comment points out, a trigger/flow is shown at 17 seconds into this Microsoft promo video from 2016.