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?
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.