cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

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]')
3 REPLIES 3
Highlighted
Super User II
Super User II

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

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]')



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Regular Visitor

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

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")

 

Highlighted
Super User II
Super User II

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

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.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,247)