@kugiigi thankyou for your kind help. I think I've figured out why after reading so much, I found out that not all Android devices support charging and OTG at the same time, some mentioned the value of resistor on certain pins.
https://forum.xda-developers.com/t/android-tab-which-supports-otg-and-charging-at-the-same-time.3896766/
Anyway, thank you again for your help Kugiigi