Issue 1: Patch data inside a Gallery & DropDown List + Textbox Outside Gallery
I created an Barcode Reader App to Collect Multiple Barcodes and TimeStamp in one go.
I would then manually select the dropdown Fruit and Input a Free Text to upload to a SharePoint List.
Barcode # and TimeStamp gets uploaded however the Dropdown Selection is NOT uploaded.
App View
Data List
//App OnStart code
ClearCollect(MultiBarcode, Blank())
//Insert a Gallery,Title & Subtitle
MultiBarcode
//Title2 code
ThisItem.Value
//Subtitle2 code
Now()
//Insert a BarcodeReader, OnScan code
Collect(MultiBarcode,BarcodeReader1.Barcodes)
//Add link to database 'Barcode List'
//Insert a button, rename as Submit
ForAll(MultiBarcode,Patch('Barcode List',Defaults('Barcode List'),{Title:Value,TimeStamp: Now(),CompanyName: CompName1}))
Issue 2: If value exist in List then Patch Column OnLoan
I duplicated the above code (excluding the dropdown portion) to another screen.
I want to scan similar barcodes again and if barcode value already exist inside the 'Barcode List' Title Sharepoint then Update the 'Barcode List' OnLoan Column.
//Check if Barcode Scanned exist in 'Barcode List'Title, if yes then Patch OnLoan
ForAll(MultiBarcode As M, With({wItem:LookUp('Barcode List',Title=M.Value)},Patch('Barcode List',Defaults('Barcode List'),{Title:M.Value, TimeStamp:Now(), OnLoan: "Yes"})))
I tested above code it just create another entry in the list and does not update the existing entry. (last entry inside the attached table above)
