Just did a quick test. On battery, the USB-A expansion card provides power while on and sleeping, but not while off.
While charging/plugged in, the USB-A also provides power while off (lid open or closed).
I don’t have a good way of measuring how much current it can source.