I have a canvas app linked to a Sharepoint list.
On a screen called scanner, the person hits the BarcodeScaner2 button where the onscan property is this:
If(Len(BarcodeScanner2.Value)=13,
Collect(multiScanCollect, {BarcodeValue: BarcodeScanner2.Value, BarcodeType: BarcodeScanner2.Type, Addedby: User().FullName, StartProductionTime: Text(Now(),"mm/dd/yyyy hh:mm:ss"),EndProductionTime: "0",ToteType: LookUp('Types',Title= Left(BarcodeScanner2.Value,2),Name),Hazard:"0",BuildDuration:"0"});
Set(TimerGo,true);
Navigate('Complete')
,Set(DisplayScanError,true))
The intent is they start a new scan and a timer starts. When the person hits finish, they scan the barcode again as confirmation. They are then returned to the barcodescanner screen. It displays the start time of the scan, end time, item type scanned, and barcode value.
The issue I'm having is that sometimes the screen doesn't switch and won't allow the person to hit finish. When they try again, there are now duplicate values. So my questions are: 1.) How do I prevent duplicate values and 2) Why can't they navigate to the finish screen?
Thanks.
