Reset Gallery and Filters (Scrolling Issue)

[VictorTek]

Hi! I have a Canvas Power App with a Gallery in. The gallery is scrollable and I have 2 fields which control the filters.

I want the gallery to reset and scroll to the top and then filters to reset when I leave and then come back to the screen

On the Screen's OnVisible property, I tried:

Reset(Gallery2);
Reset(Dropdown1);
Reset(TextInput3);

I tested this when the filters were blank and the gallery was scrolled down and it worked. But when I tested it by applying the filters and then returned to the screen, the gallery was scrolled to the bottom.

I then tried to apply {} to the Default Property in the Gallery. Now I have the opposite problem. When the filters were blank and the gallery was scrolled down, the gallery remains scrolled down when I return to the screen. But when I tested it by applying the filters and then returned to the screen, the gallery was scrolled to the top and the filters reset.

For good measure I have also put the below on the OnSelect Property on the Home icon with no success

Navigate(Home); Reset(Gallery2);
Reset(Dropdown1);
Reset(TextInput3);

Can anyone help me?

[SBax]

Is the issue maybe a result of the order of your resets?

Try doing the reset(gallery2) as the third step (as opposed to first step)

[VictorTek]

@SBax  - it didn't work 😞 Here is the problem with visuals:

[SBax]

Is your gallery coming straight from the datasource or via a collection? 

[VictorTek]

Hi! Straight out of a SharePoint List data source

[adedapo · Accepted solution]

Screen.OnVisible = UpdateContext({_selectedItem: First(Your_DataSource)});
Gallery.Default = _selectedItem

[VictorTek]

Thanks but that resets the gallery to the first ID item rather than the first name in List Column 1. Here is the SharePoint list. It is worth mentioning I want the view to default to the first name alphabetically. For example the first name alphabetically is Andy, and so it should default to Andy, but next week a new name could be added (eg Adam) and then the gallery view should default automatically to Adam.

[SBax · Accepted solution]

All you need to do is add a sort by columns before your "first" and sort by first name

UpdateContext(

{_selectedItem:

First(

SortByColumns(

Your_DataSource,

Your_firstnamefield, 

SortOrder.Ascending

)

}

);

[VictorTek]

Thanks @SBax and @adedapo