Some of the older models work while charging. For example the MG7790 or MG7750/49 (not to be confused with the new version 7910/49).
The reason I know this is because I recently bought one from amazon specifically because I want it to work while plugged in but they sent me one that doesn't (MG7770). I sent it back and now waiting for the correct one to be delivered.
The controller that I'm using (Vader 3 pro) solves this for me. It uses the Xbox layout and also has a switch mode.
The trick is that in the switch mode, the face buttons are bound to their Xbox counterpart (e.g. A is B, X is Y, etc..) which makes following screen prompts much easier.