Unanswered

Extract unique amounts from a string of text

Like (0) Share

Report

Posted on 18 May 2023 10:46:27 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:

Connecting to Data

Mobile App

Using Apps Using Formulas

General Questions

All responses (5)

Answers (0)

timl 34,939 Super User 2025 Season 1 on 18 May 2023 at 11:36:51

Like (0)

Report
Re: Extract unique amounts from a string of text

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, "," )
CU13081633-2 on 18 May 2023 at 11:30:49

Like (0)

Report

Re: Extract unique amounts from a string of text

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 34,939 Super User 2025 Season 1 on 18 May 2023 at 11:23:16

Like (0)

Report
Re: Extract unique amounts from a string of text

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 18 May 2023 at 11:15:00

Like (0)

Report

Re: Extract unique amounts from a string of text

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 34,939 Super User 2025 Season 1 on 18 May 2023 at 11:08:23

Like (0)

Report
Re: Extract unique amounts from a string of text

@sophiatheresa74

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

Split("5000,1990,2000,588,3000", "," )