Hi @Wedgels
The Default property of a gallery does not determine what items are initially shown, the Default property determines which item of those shown is initially selected (although there are some issues with this property, so it does not fully work that way).
The Items property solely determines which items are shown. Hence if the desired behaviour is for only records with ClaimNumber greater than zero be initially shown, then that needs to be what is in the Items property. You can implement this for example by using your TextSerchBox1's Default property. This property determines the initial text of the text input.
However, your gallery's current Items property is not set up to deal with that. I am also confused since "ClaimNumber" appears to be a text type field and not an integer.
Assuming it is an integer, then set the Default property of TextSearchBox1 to "" (empty string) and set the gallery's Items property to this:
SortByColumns(
If(
Len(TextSearchBox1.Text)=0, Filter([dbo].[tblJobMain]', ClaimNumber>0),
IsNumeric(TextSearchBox1.Text), Filter([dbo].[tblJobMain]', ClaimNumber=Value(TextSearchBox1.Text),
Search('[dbo].[tblJobMain]', "ContactName","ContactTelNo")
),
"ClaimNumber", If(SortDescending1, Descending, Ascending)
)
Please let me know
