Unanswered

Barcode scan and patch data into sharepoint

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I am trying to develop app, when operator start to do an order, he will scan and the 1st scan of that particular orderno will patch data into sharepoint the order no, product, process, start.

when the job is finished for that orderno, the operator again scan the same barcode and this time it will lookup the orderno and patch the finish time for the order.

Set(
 ExistingOrder,
 LookUp('Aluminium Output', Orderno = BarcodeScanner1.Value));
If(
 IsBlank(ExistingOrder),
 Patch(
 'Aluminium Output',
 Defaults('Aluminium Output'),
 {
 Orderno:BarcodeScanner1.Value,
 Start:Now(),
 Product:Product.SelectedText.Value,
 Process:Process.SelectedText.Value,
 Operator:Operator.SelectedText.Value
 }),
 Patch('Aluminium Output',
 ExistingOrder, { Finish: Now() }))

the issue at the moment with the formula is, same order no has different process, so i am not getting any registry if i scan different process for the same order.

i am stuck now, on what formula to modify so for the 1st scan of the order it will simply make the registry with start date/time, for the second scan it will lookup the process value and if the order no & process selection matches it will patch the date/finish time for the order, if the same order has different process selection it should create a new registry .

any help is highly appreciated.

Regards.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,
Using your structure, try this
Set( ExistingOrder, LookUp( 'Aluminium Output', Orderno = BarcodeScanner1.Value ) ); If( IsBlankl(ExistingOrder.Product), Patch( 'Aluminium Output', Defaults('Aluminium Output'), { Orderno:BarcodeScanner1.Value, Start:Now(), Product:Product.SelectedText.Value, Process:Process.SelectedText.Value, Operator:Operator.SelectedText.Value } ), Patch( 'Aluminium Output', {ID:ExistingOrder.ID}, {Finish: Now()} ) )

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.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz ,

Thanks for help.

Sorry for late reply. i tried but it is only making 1st registry for an order no, but when i change the operator & process for the same orderno it is not making any registry.

because each order no has 3 process - cutting, drilling,packaging and those 3- process will be done by different or same people.

example, when i scan orderno: SP001, Name: Jhon, Product:Door,Process: Cutting.

it is making a start and finish time registry in sharepoint.

but when i change the process for same order no, it is not making registry in sharepoint
example, orderno:SP001,Name: Boris,Product:Door,Process:Drilling.

it will be very helpful if you can help me with this issue.

Thanks in advance.

Was this reply helpful? Yes No