Could you please share a bit more about your scenario?
Do you want to put your PowerApps Edit form within your SP Site, and then you could submit your new record using it?
Based on the needs that you mentioned, I think PowerApps could achieve your needs. On your side, you could create a Blank app, then add a Edit form in your app, and add your data source within it, and bind your data source to this Edit form.
Then set the DefaultMode property of the Edit form to following:
Set the OnSelect property of the "Submit" button to following:
Set the OnSuccess property of the Edit form to following:
After that, embed your canvas app into your SP Site page through the following article or video resource: