Scanned Item not allowing for edit

(0) Share

Report

Posted on by Jap11

352

Hello,

I have an asset app that allows me to scan a barcode, return the item scanned and then edit the details.

When I scan either an Asset ID or Serial Number, the item returns correctly. However, when I try edit the item, it only works if an Asset ID has been scanned and not the Serial Number.

I was wondering if anyone could spot what is causing the issue? I have added a text label to display my scanned value which does return correctly but when editing after scanning the serial number, the screen just gets stuck on 'getting data'.

This is the code I'm using, if anyone can advice what I may have done wrong or knows a solution to fix it would be massively appreciated! :)

OnScan
Set(varScannedValue, First(Self.Barcodes).Value);
Navigate(DetailScannedWindowDevice, ScreenTransition.Fade)

Item
First(
Filter(
[@'Asset Reg - Windows Devices'],
'Serial No.' = varScannedValue Or 'Asset ID' = varScannedValue
)
)

EditButton
EditForm(EditForm1_2);
Navigate(EditScannedWindowDevice, ScreenTransition.None, {varEditScannedValue: varScannedValue})

Categories:

Power Platform Build Tools

All responses (2)

Answers (1)

Jap11 352 on at

Like (0)

Report

Scanned Item not allowing for edit

Hi @WarrenBelz - your first suggestion worked, thank you very much.
Verified answer

WarrenBelz 148,546 Most Valuable Professional on at

Like (0)

Report
Scanned Item not allowing for edit

Hi Jap11

Firstly try this in the Item
LookUp( [@'Asset Reg - Windows Devices'], 'Serial No.' = varScannedValue Or 'Asset ID' = varScannedValue )

If that does not work (and this is a bit of an overkill) try
With( { _ID: LookUp( [@'Asset Reg - Windows Devices'], 'Serial No.' = varScannedValue Or 'Asset ID' = varScannedValue, ID ) }, LookUp( [@'Asset Reg - Windows Devices'], ID = _ID ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee