So according to the PowerApps knowledge base the 'in' operator is delegable with SQL as a data source. So why doesn't this work:
In a gallery (search box text as number type)
Filter('fgaslogs',searchbox.text in JobNo)
It returns incomplete results and the 'in' operator is underlined in blue stating service limitation - highlighted operation is not supported by column 'JobNo'
JobNo data type in sql is int