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?
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.