Using it as a secondary drive, just plug it in a working pc with os, then boot to bios, navigate to boot manager or boot sequence then boot from the working drive with os.
As you are booted to Windows, go to disk management, there is a big chance that your drive has been corrupted or in unallocated. Because it is detected in the bios, meaning it is still working.
Weird that diskpart didn't detect the drive...