It is a pity for me that I could not have the opportunity

"It's a pity for me" sounds self-absorbed and sympathy-seeking. Better to use "I regret missing the opportunity to..." which better conveys the sense of respect I imagine you wish to convey.