How to store and rotate Azure AD Application secret using AKV

Question

Hi Team,

My use case is to register Azure AD Application and store application secret in AKV. I have AKV created and assigned necessary permission to a user1 (get,list). My Application is running Onprem and on the code, will be adding client ID + AKV URI to retrieve the secret from AKV. I enter user1 and the password to authenticate with AKV as pre-requisite#1.

Now with this, can i achieve automatic secret rotation, what additional steps needs to be configured? Is there any unseen connection between AKV secret with Application registered in AAD

If rotation is not possible, only benefit i see is secret will not be visible in the code, any other benefits am i missing