Update collection column by column

(0) Share

Report

Posted on by Hachung

Hello,

Please help me i have totally no idea about below things...

I want to make collection updated column by column

ex) Collect column A * 20 times -> collect column B * 20 time n the same order as column A

more information, please see picture below.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni on at

Like (0)

Report

Hi @Hachung ,

Could you please share more details about your scenario? I still don't know the specific meaning of your description. You can provide a pre-post example of the collection so that we can understand it correctly.

Best regards,

Was this reply helpful? Yes No
Hachung 7 on at

Like (0)

Report

Thank you for help me..

I want to make Asset barcode scanning tool.

Each asset has Two barcodes on 1 box (Asset Number, Serial Number)
but when asset income big quantity(ex. 1,000EA), it's more easy to scanning barcode by vertical. as below picture.

I failed to coding to Collect by row(Column1 -> Column2 = Collect -> Next Row) but i don't have any solution for collecting by Column1 -> Column2.

Thank you so much 🙂

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report
Hi @Hachung ,

It's not possible to collect scanned values into different columns with one scan button. But if you have two buttons, you can use one to scan asset numbers and the other to scan serial numbers in to two collections. In the end, use a complete confirming button to combine the two collections together.

So, asset no. scanner OnScan:

Collect(colAssetNo, {AssetNo: Self.Value})

serial scanner OnScan:

Collect(colSerial, {Serial: Self.Value})

confirm button OnSelect:

ClearCollect(counter,0); Clear(Combined); ForAll(colAssetNo, Collect(counter,Last(counter).Value+1); Collect(colAssets,{ AssetNo:Last(FirstN(colAssetNo,Last(counter).Value)).AssetNo, Serial:Last(FirstN(colSerial,Last(counter).Value)).Serial })); Clear(colAssetNo);Clear(colSerial)

Best regards,

Was this reply helpful? Yes No
Hachung 7 on at

Like (0)

Report

Thank you for your kind advice! It will be perfect solution for me!

Was this reply helpful? Yes No