I wanted to love this but unfortunately it isn't fit for purpose. I bought...

I wanted to love this but unfortunately it isn't fit for purpose. I bought two and both sprays are faulty. I took one on holiday and literally not a single drop would come out, I had to throw the full can away. The other dribbles out so I'm trying to get my money's worth but it's extremely frustrating.