@SnowFlake,
I notice that in your filter you compare a column against a searchable text field. Is the text in that field reset upon arriving to or leaving the screen? If so, that will cause the gallery to reset and bring itself to the top.
SortByColumns(
Filter('Job Sheet',
StartsWith(Vessel,TXTSearchbox.Text),
Or(
Status_x0020_Text="Awaiting Vessel",
Status_x0020_Text="In Progress"
),
Or(
User().Email in Surveyor.Email,
User().Email in Client_x0020_Name.Email
)
),
"Vessel",If(SortDescending1,Descending,Ascending)
)
As a best practice, I would set the User()'s information to a variable that you can reference anywhere you want.
Although the results of User() do not really change, it does need to be determined for each row in your filter.
So in the OnStart of your app, you may have a statement like this:
Set(userInfo,User())
Then for every instance of User(), you would replace it with userInfo.
That being said, I also notice your filter contains an 'in' statement. Note that the results of your filter would not be delegable at the level of the datasource, so it may not return the complete result of what you're trying to filter. Instead of using 'in', I would change the condition to equals.
Can you make these changes and let me know the results?
SortByColumns(
Filter('Job Sheet',
StartsWith(Vessel,TXTSearchbox.Text),
Or(
Status_x0020_Text="Awaiting Vessel",
Status_x0020_Text="In Progress"
),
Or(
Surveyor.Email=userInfo.Email,
Client_x0020_Name.Email=userInfo.Email
)
),
"Vessel",If(SortDescending1,Descending,Ascending)
)
