Thank you for sharing additional details. Let's see if the proposed option can resolve the issue. I would prefer option 1 based on convenience if that works.
SharePoint custom forms open in a panel. RequestHide() closes that panel, and SharePoint then displays whatever page was underneath, which is the list. You cannot change that destination from inside the form. That's a SharePoint behavior, not a Power Apps limitation.
Option 1: Post-close redirect using SharePoint page navigation
Instead of fighting the form panel, wrap your list in a SharePoint page that has a custom redirect configured. Use the list's returnUrl parameter. When launching the custom form, append ?Source= to the URL so SharePoint knows where to go after the form closes.
Example:
https://site.sharepoint.com/sites/LC-MS/Lists/YourList/newform.aspx?Source=https://site.sharepoint.com/sites/LC-
RequestHide() will then close the form and SharePoint redirects to the Source URL, not the list.
Option 2: Use Launch() with LaunchTarget.New, then RequestHide()
You already tried Launch with Replace and it fails in hosted forms. Try this sequence instead:
IfError(
Patch(
YourMainList,
Defaults(YourMainList),
{Title: DataCardValue1.Text}
),
Notify("Save failed.", NotificationType.Error),
Patch(
YourDetailList,
Defaults(YourDetailList),
{RelatedID: SavedRecord.ID, Detail: DataCardValue2.Text}
)
);
Launch("https://site.sharepoint.com/sites/LC-MS", {}, LaunchTarget.New);
RequestHide()
This opens the home page in a new tab, then closes the form panel. The user lands on the home page tab. Not perfect, but it eliminates the list view entirely from their focus.
