Save data in columns from multipleline textinput

(0) Share

Report

Posted on by CP0822

Hi,

What I have is a TextInput with multiple lines like this:

Color 1

Color 2

Color 3

Color 4

Color 5

What I want to do is save each line a specific column of a collection, like:

C1	C2	C3	C4	C5
Color 1	Color 2	Color 3	Color 4	Color 5

Any ideas of how can I do this?

Thanks for your help guys.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CP0822 ,
You can do a collection using Split and the character for a line break Char(10) - I will call your field TextInput1
ClearCollect( colColors, Split( TextInput1.Text, Char(10) ) )
colColors will have all your values as separate items.

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.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CP0822 ,

Do you want to save each line data within the Multiple Line Text Input into individual columns in a collection?

Based on the needs that you mentioned, I have made a test on my side, please take a try with the following workaround:

Set the OnSelect property of the "Collect" button to following:

Collect( Collection1, { C1: Last(FirstN(Split(TextInput1.Text, Char(10)),1)).Result, C2: Last(FirstN(Split(TextInput1.Text, Char(10)),2)).Result, C3: Last(FirstN(Split(TextInput1.Text, Char(10)),3)).Result, C4: Last(FirstN(Split(TextInput1.Text, Char(10)),4)).Result, C5: Last(FirstN(Split(TextInput1.Text, Char(10)),5)).Result } )

when you press the "Collect" button, the collection1 would be populated as below:

Best regards,

Was this reply helpful? Yes No