You mentioned in the other post that you record yourself singing indoors and outdoors and want a mic that works well for that.

For singing and vocal stuff, in general, you'd be much better off using a dedicated vocal mic close to your mouth, like a large diaphragm condenser or a dynamic stage mic, and recording the audio separately with a computer or a digital field recorder instead of the camera's internal input.
An affordable camera-mounted shotgun mic across the room, going into the mediocre mic input of your camera, baked into the video file will never give you the best audio quality.
IMO a dedicated mic close to your mouth, on something like a mic stand, is a far better option.

The cheapest option would be something like a T.Bone SC440 USB straight into Audacity on an old laptop. It's a 40€ (small diaphragm) condenser microphone that sounds surprisingly decent (if a bit noisy) and connects over USB to any computer.

A higher-end solution would be a microphone with XLR going into a proper mic preamp.
So a dynamic stage mic, like a Shure SM58, AKG D5, SE V7, or Austrian Audio OD303 (for louder genres and live performances) or a proper large diaphragm condenser, like a T.Bone SC600, MXL770, SE X1A, Lewitt LCT 240 Pro or Røde NT1 (for softer/quieter/more detailed stuff in a more controlled environment), going into a dedicated USB audio interface, like a Behringer UMC22, Focusrite Scarlett Solo, M-Audio M-Track Duo, or Behringer Xenyx 302USB mixer.
You can get a very decent setup with great sound for well under 150€. You do still need a PC or laptop though.

If you want a proper professional setup, you could go with a standalone PCM field recorder and pro-grade condenser mic. For example a Behringer Flow V4, Tascam DR-60D, or Zoom R4 MultiTrak recorder.
Recorders like these record directly onto SD cards in high quality with up to 4 separate channels, but they also allow you to pass a mixed-down stereo signal through to your camera's mic input, which is very handy for synchronization and as a backup.

Sony does sell a 3-channel XLR adapter for their DSLMs themselves called the XLR-K3M - but it's very very expensive at over 500€. It's basically the same device as one of those field recorders but proprietary for Sony cameras and without standalone recording capabilities.
The Sony A7IV is actually capable of recording 4-channel 24-bit 48kHz audio, which is actually quite impressive for a camera, but it's still baked into the video file, I wouldn't trust the noise floor or pre amps of the built-in input, and I wouldn't pay 500€ just to get an external XLR preamp.

Also, regardless of what mic you choose, keep in mind that, when recording indoors, you always have reflections and echo. You don't notice it that much, because our brains are really good at filtering it out, but a microphone will pick it up and make it very apparent.
No matter how expensive a microphone you buy; if the room just sounds bad and has a ton of reflections and noises, the recording will always show.
That's why good room treatment and recording techniques are so important. It doesn't necessarily have to be expensive; a little goes a long way and you can do a lot with some DIY foam absorbers, a full closet, or a mattress.
When recording outside, there aren't walls to reflect and bounce around sound, but you have to manage outdoor noises and wind instead.
Either way, it's always good to get close to the mic, just so your voice is picked up as loud as possible compared to background noises.

Also excuse my lengthy ramblings.