Bitcoin-cli 0.19.1 Wallet not Sending from Addresses with Closest Amount?

[Bitcoin]

Bitcoin-cli 0.19.1 Wallet not Sending from Addresses with Closest Amount?

I have a weird issue that I thought was fixed a few years back with Bitcoin wallet to reduce fees. I guess not, or I am missing something...

My wallet received a transaction for the amount of 0.54530200 BTC, yet when I went and sent 0.51986042 BTC out using bitcoin-cli sendtomany to 16 outputs, the wallet used 856 inputs to send the amount that was available and cleared with at least 400+ confirmations in the first address.

The above TX cost me 0.03600705 BTC to send when it should have cost me a fraction of the amount had it used the address that contained the closest amount to the amount it's sending out...

Bitcoint-cli version 0.19.1

Any ideas what I could be doing wrong or what I could be missing?

Source: Bitcoin-cli 0.19.1 Wallet not Sending from Addresses with Closest Amount?