I am exploring my first adventure in bar code scanning I have set up a stock table in SQL consisting of four columns being StockID, Barcode, PartNumber and Description.
In power apps I have connected to this table and have sorted my browse gallery by part number as below:
SortByColumns(Search([@'[dbo].[ShentonStock]'], TextSearchBox1.Text, "Barcode","Description","PartNumber"), "PartNumber", If(SortDescending1, Descending, Ascending))
As this is a practical test, and use in anger for first time Monday, I would like to restrict the records to only part numbers commencing 05. So part numbers like 0506CH1288 and 0512THC234 etc, no other records at this time (but want to revert later).
Do I do this in powerapps and if so at the browse gallery level or do I do this at SQL or something else?
Solved! Go to Solution.
Thanks worked perfectly.
I tried to copy just the changed part but got tangled in brackets. Is there a better way to edit these phrases of coding?