Unanswered

Extract unique amounts from a string of text

(0) Share

Report

Posted on by CU13081633-2

Good day everyone,

I have a string of unique amount of values saved in SharePoint which are separated by a comma. I would like to get the values between each comma and place them in a separate text.

This is in one DataCard and I would like 5000 on the first line, 1990 in the second line and so on

Any assistance would be greatly appreciated.

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@sophiatheresa74

The Split function will separate those values into lines. The following will return a table:

Split("5000,1990,2000,588,3000", "," )
CU13081633-2 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried using this with the Parent.Default but it is giving an error.
These values are not always going the be the same amount.
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
If you want to set the text on a label, this is what you would use:

Concat( Split( Parent.Default, "," ), Value & Char(10) )
CU13081633-2 on at

Like
a
(0)

Report
Copy link

Link copied!

This works but I wanted each value in separate text:
and not all the time it would be 4 values, it would have 6 or 3 values
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
If you want each value in a separate control, you'd need to add a gallery control onto your card rather than separate labels. Once you add the gallery, you would then set the Items property of the gallery like so:

Split(Parent.Default, "," )