Hello,
Welcome to Microsoft Q&A!
Yes. The sessionConnected trigger won't trigger when the system is in the hibernate/sleep power state. If you want to trigger every time when the user is login. You could try another system trigger: UserPresent Trigger. It will trigger the background when you get out of hibernating state
Thank you.