Is there an idiom for disappointment caused due to last minute cancellation of plans?

A couple of days ago, my wife and I had planned a surprise visit to our friends living in a neighboring state on account of their first wedding anniversary.

But at the very last minute, we got notified by our travel operator that there was an impromptu agitation by the farmers of the neighboring state and all transport services were cancelled since the protest was turning violent.

This happened when we were about to board our bus. We'd to return to our homes (some 50 kms away from the bus station) disappointed and angry. We also had to cancel all the surprise events we'd organized for our friends which did some considerable damage to our pockets. I'm wondering if there's an idiom/expression for this scenario?

Possible usage example:

We were super excited to meet our friends during the weekend but the farmers' agitation brought all our excitement to a grinding halt. We _______________.

A phrase that I considered was high and dry but we were not stranded per se, as the meaning implies.

Is there an idiom/phrase that fits this context?

"All dressed up and nowhere to go" suitably implies that the preparations you made came to nothing. It calls to mind imagery of someone being stood up for a date, but applies more broadly (IMHO) to any circumstances where potentially costly preparations are frustrated.

From TFD

that has been postponed or has failed to materialize. (May be literal or figurative.)

Tom: I just heard that your company is closed today.
Fred: Gee, I'm all dressed up and nowhere to go.  

"The space shot was cancelled, so all the astronauts are all dressed up with nowhere to go."

Sounds to me you were crestfallen:

Dispirited and depressed; dejected.

I also kind of like deflated, which is highly metaphorical. The spirit-soul-air-breath connection goes back millennia:

Then the LORD God formed man of dust from the ground, and breathed into his nostrils the breath of life; and man became a living being [or soul] (Genesis 2:7 NASB).

Picture two people who are "pumped" for an upcoming event. Suddenly and out of nowhere they are told their plans have to be scrapped. They're no longer pumped; they're deflated. Whoosh. Out goes the spirit (or soul, air, breath).

From the same link as above, I found the following adjectives, each of which is apt in some way:

• disappointed

• depressed

• discouraged

• dejected

• despondent

• downcast

• disheartened

• disconsolate

• downhearted

• sick as a parrot (informal)