Having problem with Power apps-

Question

Hello Everyone.I have made a barcode scanner with power apps and linked into a share point list. After scanning a barcode it automatically saves it to my list. However from the scanned string I wanna extract some values and want that it automatically does that after scanning. For example: My scanned barcode is like 0938193330291S02939. and I wanna extract and save 330291S and save automatically to my share point list. So after scanning it do everything automatically. Its urgent, any help would be appreciated!

Answer 1

Its just saving me the barcode after scanning and not the extracting the values and saving it. Any idea?

Answer 2

You can modify the ExtractedValue field in your formula like this:

Collect( colScannedItems, { ScannedItem: First(BarcodeReader1.Barcodes). Value, ExtractedValue: Mid(First(BarcodeReader1.Barcodes). Value, 18, 7), Who: User(). FullName, When: Now() } );

Answer 3

Thankyou for your reply.

I am using this with OnScan property:

Collect(

colScannedItems,

{

ScannedItem: First(BarcodeReader1.Barcodes).Value,

ExtractedValue:Mid(First(BarcodeReader1.Barcodes).Value,25,7),

Who: User().FullName,

When: Now()

}

);

I wanna extract values from 18-24 and save it, my 24th value is an Alphabet and my 18th and 19th value is always 01.

How should I change it?

Answer 4

Hi

I'm AnnaThomas and I'd happily help you with your question. In this Forum, we are Microsoft consumers just like yourself.

You can try this

In your Power Apps app, select the control that displays the scanned barcode value.

In the formula bar, enter a formula that uses the Mid function to extract the desired part of the scanned barcode. For example, if you want to extract characters 9 through 15 from the scanned barcode, you could use a formula like this: Mid(BarcodeScanner1.Value, 9, 7).

Use the Patch function to update your SharePoint list with the extracted value. For example: Patch(SharePointList, Defaults(SharePointList), {Title: Mid(BarcodeScanner1.Value, 9, 7)}).

This will extract characters 9 through 15 from the scanned barcode and save them to a new item in your SharePoint list with the extracted value in the “Title” field.

I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

Best Regards,

AnnaThomas

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.