Hello,
I'm trying to Patch a Collection to a SharePoint list, but all it does is write the same exact entry for whatever number of entries are in the Collection rather than looping through each individual one and recording it back correctly. Here is what the screen looks like before I press the log entries button (note the 2 entries in the lower right quadrant.
When I examine the Items property of the Collection, both entries are showing up.
It gets written back to SharePoint like this. As you can see it only appears to be picking up the first barcode value that was scanned.
Here is the OnSelect formula for the "Log Your Entries" button. I tried it without the "As item" reference as well with the same result.
ForAll(
colTracking As item,
Patch(
'Admin Scan Log',
Defaults('Admin Scan Log'),
{
'Barcode Value': lblBarcode.Text,
'Operator Email':lblEmail.Text
}
)
);
Clear(colTracking); Reset(txtScanBenchBarcode)
Here is the current OnChange property of the Step 2 text input field. The group I am making the app for wants Operators to have immediate feedback as to whether or not the tools match the bench they are working at and whether or not the calibration is past due so in a perfect world, I'd like to be able to grab the information from the "Expected Tools" gallery on the left and patch the values (using the barcode as the key) to my "Admin Scan Log". Is that possible? If so, how do I go about it?
Collect(colTracking,{'Barcode Value':Self.Text,'Operator Email':varUser.Email});Reset(Self);SetFocus(Self);
The items property of the Your Tools gallery is:
colTracking
Thanks in advance for your help!
Teresa
