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
Hi @tagustin2020 ,
I think you need
ThisItem.'Barcode Value' in galTools.AllItems.'Barcode Value'
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional