Sunroof no power? Have you tested for voltage at the switch in dash or connector at motor in trunk?

Easiest fix, hopefully, is the replace the fuse for the sunroof with a known good or new one. Make sure you polish/rough up the seat for the fuse on the fuse box with some fine emery cloth for good contact.

I have a spare motor if it turns out you need one.

Plenty of posts here for troubleshooting tips.

__________________
83 300d - 390k