Question if you believe in the law of attraction (the secret) =)?

[hola =)]

Hi everyone! please, I'm only interested in your answer if you are a true believer in this universal law. I would love some insight. Last year, I sent out into the universe that I'd really love to meet a guy who loved me for who I was, who I could grow close to, who was my best friend and always there for me. about 7 months later, this guy came and i was so happy! Everything fell into place perfectly, and I had no doubt in my mind that he was the one I had "wished" for, because he was everything I asked for. everything. from his personality to the way he looked and made me feel. So i told him that I liked him...and he told me he was gay. I was very confused and I still don't understand what went wrong, or what I did wrong. did I make an error when asking for what I wanted? we are the best of friends and i'm glad he came into my life regardless (love him), but i just don't understand. While in the process of asking, i had not only friendship in mind but romance, but maybe i didn't make that clear? how can i improve my manifestation next time? Any insight would be great, thanks a lot!