Thanks for the response, I was playing with Program mode and Shutter mode when taking shots of my son. I guess what I need to do is set the aperture and shutter on manual and see how it looks. When I'm trying to use manual since I have a prime lens i get sufficient light. But noticed at this indoor place my aperture was maxed at 1.8.
I think the best answer to your question is that you surely want to use camera A or camera M mode with flash indoors.
Modes S or P are the worst choices for flash indoors. These can work, but mode S indoors in dim light will simply always be forced to use the maximum widest aperture, every time.
Camera P mode has some quirks with indoor flash (ISO and maximum aperture).
However, camera P mode is very good with fill flash outdoors in bright sun, because it understands needs of both bright ambient and of flash.
But indoors with flash, surely you want to use camera A mode or camera M mode (with flash). Flash power is about aperture, and both of these modes allow you to directly set the aperture for flash, like to f/5 or whatever you deem best.
Indoors, the ambient is dim (which is why we need flash) and the insignificant ambient exposure is typically "don't care". So camera M mode works as well as camera A mode then (flash indoors, when ambient is dim and don't care).
Some flash rules which may not be automatically obvious at first.
All flash pictures are affected by both flash exposure and by ambient exposure. Ambient might be weak or strong, but always should be considered.
The camera exposure meter only reads and shows and sets the ambient exposure. Flash metering has its own metering system, which invisible to us. The flash power level simply has to use whatever ambient settings it discovers are in effect, regardless of why those settings were chosen. When ambient level is insignificant, we can use settings better suited for the flash instead (specifically aperture in camera A or M modes).
Shutter speed does not affect flash exposure, shutter speed only affects ambient exposure. Camera A mode (with flash indoors) likely always will be 1/60 second shutter speed, which is a Minimum shutter speed. But we can set any value of shutter speed with camera M mode. Otherwise, A and M modes can set same aperture for flash power.
TTL flash is fully automatic in any camera mode, including camera mode M. The way we control automatic TTL flash exposure is Flash Compensation.