I thank the admins who have totally deleted my message without any warning and I propose it again here.
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]')
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")
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.
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021