Refreshing a subpage without being redirected to the first parent's subpage

[Flag]

I thank the admins who have totally deleted my message without any warning and I propose it again here.

The problem I open the thread is that if I update the content with the Refresh key on a subpage of the list, the application takes me back to the subpage of the first parent.

I have an app that derives all the content from a single table in a database.
Then create a list by grouping by category (a column of the db that contains the category of the item in the row), and accordingly if I select a category it shows me the list of rows of the db with that category.
Just in this sublist if I press the Refresh button, I find myself in the sublist of the first parent category, thus forcing me to go back and reselect the category I was interested in.

The Refresh key executes the command: Refresh('[dbo].[ Table]')

[Jeff_Thorpe]

When you say you have a sub list based on a category does that mean you have a Gallery or DataTable in PowerApps that is being filtered by the category? If so, what is the formula for the Items property of the Gallery or DataTable? Also when a refresh is executed is Refresh('[dbo].[ Table]')

[Flag]

It's a Gallery and the formula that generate it is:

GroupBy(SortByColumns(Search('[dbo].[Table]'; TextSearchBox2.Text; "Category"); "Category"; If(SortDescending1; SortOrder.Descending; SortOrder.Ascending));"Category";"Category")

[Jeff_Thorpe]

I understand the issue now. The selected item in the gallery changes to the first item when the gallery updates because of of an item being added or a manual refresh. This is being caused by the GroupBy function because it has to rebuild the table. I am sorry but I don't have a solution for you other than removing the GroupBy.