The answer, sadly, is no. Jesus' name is not a magic formula to get what we want. If we ask for something that contradicts God's purpose it will not be granted, even if Jesus' name is invoked.
A good example of this principle is Paul's report that he asked God three times to take away the "thorn" in his flesh that tormented him. God did not do so. The reason Paul cites is that the thorn was given to him in order to keep him from boasting about his spiritual experiences.
7 Because of the surpassing greatness of the revelations, for this
reason, to keep me from exalting myself, there was given me a thorn in
the flesh, a messenger of Satan to torment me—to keep me from exalting
myself! 8 Concerning this I implored the Lord three times that it
might leave me. 9 And He has said to me, “My grace is sufficient for
you, for power is perfected in weakness.” Most gladly, therefore, I
will rather boast about my weaknesses, so that the power of Christ may
dwell in me. 10 Therefore I am well content with weaknesses, with
insults, with distresses, with persecutions, with difficulties, for
Christ’s sake; for when I am weak, then I am strong.
We are not told if Paul asked this in Jesus' name, but can we actually believe that if he had done so, God would have acted differently?
A similar example is the case of Jesus asking the God to take the cup of suffering from him in the Garden of Gethsemane. Again, like Paul, he asked three times (Mk. 14:41), demonstrating the ardent nature of the request. But his disciples failed three times to keep watch with him, and God did not accept Jesus' prayer. In the end, he accepted the fact that there was no way to avoid his fate within God's will.
God will not grant every imaginable request made in Jesus' name. The request has to be within the scope of his will. Even Jesus' own prayer was declined in a critical moment.
Note: there are indeed times when human beings can negotiate successfully with God. Abraham and Moses both seem to have "changed God's mind" at times. But this was because their requests did not truly contradict God's will; rather they showed themselves to be true men of God by their willingness to argue with him.