Unanswered

Split and Concat QR Code

(0) Share

Report

Posted on by GFFA

Hello,

I have the following problem and can not come up with a solution.
I scan several QR codes in a row with an external QR code scanner. This has the following syntax:
Type(Order(Customer(Supplier(
The code could look like this:
Type1(Order1(Customer1(Supplier1(Type2(Order2(Customer2(Supplier2(Type3(Order3(Customer3(Supplier3(

I scan the QR - Code in DataCardValue46_1.

I want to split this into a collection and then merge e.g. all customers with a separator. If the customer name is repeated, I would like to have this displayed only 1x.

Can someone help me here please?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

v-bofeng-msft on at

Like (0)

Report
Hi @GFFA ,

Please try:

With( {TheCollection: With( {TheString:"Type1(Order1(Customer1(Supplier1(Type2(Order2(Customer2(Supplier2(Type3(Order3(Customer3(Supplier3("}, ForAll( Sequence(RoundDown(CountRows(Split(TheString,"("))/4,0),0,1), { Type:Index(Split(TheString,"("),Value*4+1).Value, Order:Index(Split(TheString,"("),Value*4+2).Value, Customer:Index(Split(TheString,"("),Value*4+3).Value, Supplier:Index(Split(TheString,"("),Value*4+4).Value } ) )}, ForAll( Distinct(TheCollection,Customer).Value, LookUp(TheCollection,Customer=Value) ) )

Best Regards,
Bof

Was this reply helpful? Yes No
Verified answer

GFFA 18 on at

Like (0)

Report
Hi Bof,
thank you very much for your support.
I haven't been developing PowerApps for very long and can't understand the exact function of your code.
Can i change "TheString" to: DataCardValue46_1.Text?
With( {TheCollection: With( {TheString:"Type1(Order1(Customer1(Supplier1(Type2(Order2(Customer2(Supplier2(Type3(Order3(Customer3(Supplier3("}, ForAll( Sequence(RoundDown(CountRows(Split(TheString,"("))/4,0),0,1), { Type:Index(Split(TheString,"("),Value*4+1).Value, Order:Index(Split(TheString,"("),Value*4+2).Value, Customer:Index(Split(TheString,"("),Value*4+3).Value, Supplier:Index(Split(TheString,"("),Value*4+4).Value } ) )}, ForAll( Distinct(TheCollection,Customer).Value, LookUp(TheCollection,Customer=Value) ) )
Where do I have to insert the code or how can I get my desired values out then?
The goal is to field the data in a form and then safe it in a sharepoint lists.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (1)

Report
Hi @GFFA ,

Add a button and set it's OnSelect property to

ClearCollect(
CollectionName,
With( {TheCollection: With( {TheString:DataCardValue46_1.Text}, ForAll( Sequence(RoundDown(CountRows(Split(TheString,"("))/4,0),0,1), { Type:Index(Split(TheString,"("),Value*4+1).Value, Order:Index(Split(TheString,"("),Value*4+2).Value, Customer:Index(Split(TheString,"("),Value*4+3).Value, Supplier:Index(Split(TheString,"("),Value*4+4).Value } ) )}, ForAll( Distinct(TheCollection,Customer).Value, LookUp(TheCollection,Customer=Value) ) ))

Click the button ,you will get the collection you want.

Best Regards,

Bof

Was this reply helpful? Yes No
GFFA 18 on at

Like (0)

Report

Thank you so much!

Was this reply helpful? Yes No
GFFA 18 on at

Like (0)

Report

Hello Bof,
I have another question about the code.
This removes the whole lines for duplicates. Now my application uses multiple orders from the same customer but with different types. I have now removed the lower part of your function.
Is there any way that I can use the Concat function to join all values except Duplicate?
Trying this Function did not work:
Concat(Distinct(Collectionname;Order);Order; "*")

Was this reply helpful? Yes No
niel131512 14 on at

Like (0)

Report

May i know how do you setup the external qr code?and which external qr code did you use..i wanted to try to use an external qr code but im not sure if it is compatible to use for my powerapps..

Was this reply helpful? Yes No
GFFA 18 on at

Like (0)

Report

I receive the QR code from an external company as a DataMatrix. The syntax is "Type1(Order1(Customer1(Supplier1(". I scan the QR codes into a text field and split them with a push bu

Was this reply helpful? Yes No
niel131512 14 on at

Like (0)

Report

sorry,,what i meant was how do you setup the external qr code scanner?and which qr code scanner did u use?

Was this reply helpful? Yes No