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 the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.