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

(0) Share

Report

Posted on 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

All responses (6)

Answers (1)

WarrenBelz 148,546 Most Valuable Professional on at

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.
AshanSilva 17 on at

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
WarrenBelz 148,546 Most Valuable Professional on at

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.
AshanSilva 17 on at

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
AshanSilva 17 on at

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

WarrenBelz 148,546 Most Valuable Professional on at

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