I want to create a Power app splits comma separated value to new line, I have created an app also attached screenshot for the same but not sure how to use split function and where to use it?

(1) Share

Report

Posted on by ank3

My input:
1123 , 234 , 12376, 9876

My output:
ID
1123
234
12376
9876
not sure

Categories:

Building Power Apps

Capture1.PNG

Capture2.PNG

Capture3.PNG

I have the same question (0)

All responses (7)

Answers (1)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Hi @ank3 ,

If this is what you want:
Then use the following code in your Textbox where you want to display the items in different line

//Here, TextInput1 will contain 123,345.... so on values //This will be in Label or Textbox where it will go in next line Concat(Split(TextInput1.Text, ","),Value,Char(10))

Note: The spacing in your separation will also be considered in new line

Hope this helps

Was this reply helpful? Yes No
ank3 15 on at

Like (0)

Report

for saving I'm using this: (can we edit in this itself)

for patching I'm already using this: (can we edit in this itself)

this is my collection: (can we edit in this itself)

Now can you tell me which step I need to modify to split the above text

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Hi @ank3 ,

I'm confused as why you used OnStart and OnChange
But what you can do it,
//For Save Button Patch( DataInput, ThisItem, { Name: Concat(Split(txt_ID.Text, ","),Value,Char(10)) } ); Collect(Table1_1, DataInput);

Hope this helps

Was this reply helpful? Yes No
ank3 15 on at

Like (0)

Report

I basically want to add the data to new cell (every comma separated value to new cell in excel/sharepoint - attached screenshot below), and the above formula does not serve the purpose.

I'm getting error while using the above formula (attached screenshot below for reference):

Could anyone please help!!
Thanks in advance for help.

Was this reply helpful? Yes No
ank3 15 on at

Like (0)

Report

@Ethan_R could you please reply?

Was this reply helpful? Yes No
Verified answer

Ethan_009 4,838 Moderator on at

Like (2)

Report
Hi @ank3 ,

Can you try the following code?

ForAll( Split(TextInput1.Text, ","), Patch( DataInput, Defaults(DataInput), { Result: ThisRecord.Value } ) )

Hope this helps

Was this reply helpful? Yes No
ank3 15 on at

Like (1)

Report

thanks for the reply it is working now

Was this reply helpful? Yes No