Split and Concat QR Code

Like (0) Share

Report

Posted on 14 Jun 2023 07:47:13 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?

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (8)

Answers (2)

niel131512 14 on 31 Aug 2023 at 08:26:53

Like (0)

Report

Re: Split and Concat QR Code

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
GFFA 18 on 31 Aug 2023 at 08:18:20

Like (0)

Report

Re: Split and Concat QR Code

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 14 Aug 2023 at 10:36:56

Like (0)

Report

Re: Split and Concat QR Code

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 21 Jun 2023 at 09:22:46

Like (0)

Report

Re: Split and Concat QR Code

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
GFFA 18 on 14 Jun 2023 at 11:30:44

Like (0)

Report

Re: Split and Concat QR Code

Thank you so much!

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on 14 Jun 2023 at 08:45:32

Like (1)

Report
Re: Split and Concat QR Code

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
Verified answer

GFFA 18 on 14 Jun 2023 at 08:41:19

Like (0)

Report
Re: Split and Concat QR Code

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
v-bofeng-msft on 14 Jun 2023 at 08:04:14

Like (0)

Report
Re: Split and Concat QR Code

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