Split string into collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I want to split a string from label and store it in a collection, i also want to add indexes to splitted text.

Example:

My label("Resulting_Text"is the name of the label) looks like this "E123a E143b E156f". I want my collection to have 2 columns("Index" and "Value" are the names of the columns).

Collection should look like this:

Index Value

0 E123a

1 E143b

2 E156f

Pls help

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Fredrik_A 3,570 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Is there any reason you need a collection?

You can create records with the help of a varabile:

Was this reply helpful? Yes No
Fredrik_A 3,570 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you want a collection try looking at this thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/split-string-into-collection/td-p/764556

Was this reply helpful? Yes No
Verified answer

timl 36,774 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
@Anonymous

Here's a formula to do this:

ClearCollect( yourCollection, With( { data: Split( "E123a E143b E156f", " " ) }, AddColumns( RenameColumns( Sequence(CountRows(data)), "Value", "Index" ), "Value", Index( data, Index ).Result ) ) )

With the formula above, you would substitute the hardcoded value "E123a E143b E156f" with a reference to your label control (eg label1.Text).

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@timlyou are a life savior. Thanks!!!

Was this reply helpful? Yes No
timl 36,774 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You're welcome @Anonymous - glad to help!

Was this reply helpful? Yes No
NidjoJohnny22 288 on at

Like (0)

Report
Copy link

Link copied!

Hi @timl , I don't understand what does the last part of the AddColumns() function do?
Index( data, Index ).Result

Was this reply helpful? Yes No
timl 36,774 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@NidjoJohnny22

That's the part that retrieves the value (eg, E123a). The Split function splits the input into rows so the call to index is required to retrieve the corresponding value by ordinal number.

Was this reply helpful? Yes No
NidjoJohnny22 288 on at

Like (0)

Report
Copy link

Link copied!

@timl thank you for quick reply! I understand it now 🙂

Was this reply helpful? Yes No
rugitola 5 on at

Like (0)

Report
Copy link

Link copied!

@timl If I use your formula as-is (or changing to my label control) it presents the error:
The function 'AddColumns' has some invalid arguments
Any thoughts why this might be the case?

Was this reply helpful? Yes No
rugitola 5 on at

Like (0)

Report
Copy link

Link copied!
I replaced
).Result
with
).Value
and working perfectly now. Thanks for the solution @timl!

Was this reply helpful? Yes No