["I didn't get a big promotion at work, I worked so hard for it.", 'Sorry to hear that, I know that you probably feel disappointed but there will be other opportunities!', 'I was,but I will try harder next time.']
Yes, and you will succeed eventually.
I didn't get the promotion at work that I worked so hard to get.