All data collected in barcode reader to one datacardvalue box but with a comma after each value?

Like (0) Share

Report

Posted on 3 Jun 2024 10:44:54 by AshanSilva

Hi All,

Second time posting Hope someone can help!

I had the problem earlier with a Power App where it only populated one value in the data card. Which was solved in the following tread: Link here

Now, How can I have a comma after every value scanned in that one Data card?

Current set up is shown in the bottom image:

Kind regards,

Ash

Categories:

General Questions

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 149,646 Most Valuable Professional on 03 Jun 2024 at 12:36:17

Like (0)

Report

Re: All data collected in barcode reader to one datacardvalue box but with a comma after each value?

Hi @AshanSilva ,

I cannot see your data, but clearly the scanned codes are valid URLs and as you are storing them in Excel in a single cell (which Concat is the only way of doing), it treats them as it would any other data. Your real issue is Excel - if you put these in a Text field in SharePoint, it would be treated as normal Text.

Was this reply helpful? Yes No
AshanSilva 17 on 03 Jun 2024 at 12:03:45

Like (0)

Report

Re: All data collected in barcode reader to one datacardvalue box but with a comma after each value?

Hi Warren,
As its concat that's causing my values to group to an View Entry Link, Is there a better war for my to populate my scanned values into the data card?

Kind regards,
Ash

Was this reply helpful? Yes No
WarrenBelz 149,646 Most Valuable Professional on 03 Jun 2024 at 11:25:50

Like (0)

Report

Re: All data collected in barcode reader to one datacardvalue box but with a comma after each value?

Hi @AshanSilva ,

Maybe because they are a URL - unfortunately Excel (which is a terrible Data Source for Power Apps for many other reasons) automatically presents a valid URL in that format.

Was this reply helpful? Yes No
AshanSilva 17 on 03 Jun 2024 at 11:21:42

Like (0)

Report

Re: All data collected in barcode reader to one datacardvalue box but with a comma after each value?

Hi Warren,

Thank you for the quick response, Your solution worked but would you know my my scanned values are showing as a link? is there a way to bypass that?

Kind regards,
Ash

Was this reply helpful? Yes No
AshanSilva 17 on 03 Jun 2024 at 11:21:38

Like (0)

Report

Re: All data collected in barcode reader to one datacardvalue box but with a comma after each value?

Hi Warren,

Thank you for the quick response, Your solution worked but would you know my my scanned values are showing as a link? is there a way to bypass that?

Kind regards,
Ash

Was this reply helpful? Yes No
Verified answer

WarrenBelz 149,646 Most Valuable Professional on 03 Jun 2024 at 11:04:13

Like (0)

Report
Re: All data collected in barcode reader to one datacardvalue box but with a comma after each value?

@AshanSilva ,m

Just replace Char(10) with a comma

Concat( BarcodeReader1.Barcodes, Value, "," )

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No