I’d suggest getting the Character world location and the Actor world location… plug both these location vectors into Find Look At Rotation node… this will give the rotation needed.
Then you can use Rinterp or a lerp and timeline or something to transition your Character from current rotation to target rotation… you might do this using Set Control Rotation or Set Actor Rotation on your Character