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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,242 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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
AshanSilva 17 on at

Like (0)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

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
WarrenBelz 155,242 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

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 155,242 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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