Hi, @Vaibhav Vashist ,
The approach from sadomovalex shall work if your personal site is still a SharePoint site in the same tenant. If you are talking about a non-SharePoint site, things may be a bit different. If there is a built-in connector to the service provider of your personal site in Power Automate. You can try to use the available actions to do it almost out-of-box.
If this is not your scenario, you may need to come up some workarounds, like sending an E-mail with the file to your site. Or consider about creating a custom connector to send data. This will need some code work. And all these are for SharePoint online.
For SharePoint On-Premise, besides 3rd party tools, you can use On-Premise data gateway to bridge your local data in SharePoint to several Microsoft cloud services. It provides quick and secure data connection. With it, you can still use Power Automate to handle you local data in an On-Premise SharePoint farm.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.