Hello Seb,
I'm still finetuning my galleries. I thought it would be helpful to the user if they were sorted in the same order and if a checkmark would appear in the left gallery once they scanned the item. I managed to get the checkmark to show up for one scanned item, but not the other. The Visible property for the green checkmark icon in the left gallery is:
ThisItem.'Barcode Value' in galTools.Selected.'Barcode Value'
Why would it be working for the Notepad item that was scanned, but not the Envelope item?
In regard to sorting, the Items formula for the left-hand gallery is:
SortByColumns(
Filter(
'Admin Desk Tools',
StartsWith(
'TekTrace Bench ID',
txtScanBenchBarcode.Text
) && Status.Value = "Active"
),
"ToolDescription",
SortOrder.Ascending
)
The Items formula for the right-hand gallery is:
ForAll(
Distinct(
colTracking,
ThisRecord
),
Value
)
I like the Distinct gallery formula as it prevents duplicates if they accidentally scan a tool twice, but I'm having trouble adding a Sort feature to it for the Tool Description column. The internal name of the column is "ToolDescription".
Thanks in advance for your help! I'm really pleased with how the app is coming along and it is all thanks to you!
Teresa