weak at/in the knees

idiom

: so nervous or powerfully affected that it is difficult to stand

The announcement made me weak at the knees.

She said hello to me and I went weak in the knees.