Answered

Multiline Text separation to rows

(0) Share

Report

Posted on by JuanGarcia9

I'm looking to be able to input multiple lines in my text box and then have them transfer to the data as separate rows, can anyone assist?

the issue I'm having is when adding multiple accounts it only adds to the local collection as on entry?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @JuanGarcia9

Splitting them into separate rows, you can do this

Add the following to a gallery control to see how it works.

Items =

Filter(

Split(TextInput1.Text, Char(10)),

Not IsBlank(Trim(Value))

)

Char(10) is the newline character and check for the start of a new line.

Not IsBlank(Trim(Value)) remove any blank lines.

Result

If you want to achieve this:

add a button and add this to it:

ClearCollect(

someCollection,

Filter(

Split(TextInput1.Text,Char(10)),

Not IsBlank(Trim(Value))

)

);

ClearCollect(

colDoIt,

ForAll(someCollection,{col1: Value, col2: TextInput2.Text, col3: TextInput3.Text})

)

Set the Items of the datatable as DoIt

Was this reply helpful? Yes No
JuanGarcia9 58 on at

Like (0)

Report

Hey Rubin,

I apologize for my ignorance I am fairly new to this, can you explain how I would add to this formula?
when I hit the transfer button, I want it to separate multiple entries in the chart to the right?

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

@JuanGarcia9

have a look at this:

Was this reply helpful? Yes No
JuanGarcia9 58 on at

Like (0)

Report

I apologize again, I want all 4 inputs to have the capability of multi entries.

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @JuanGarcia9

that all good.

Can you give an example where you have the multiple lines in those textboxes and how you then expect the output to be:

AA | BB | CC | EE

BB | BB

CC | BB

Was this reply helpful? Yes No
JuanGarcia9 58 on at

Like (0)

Report

Hey Rubin,

I'm looking to make multiple entries in the text boxes and have them transfer into separate rows;

so if each text box, account ID/BPM ID/Resp cent/Admin have multiple entries, I want them to transfer as separate rows,
formatted as below in sequential order;
A
A
B
B
C
C
D
D
also can you explain the coldoit part of the formula?

Was this reply helpful? Yes No
JuanGarcia9 58 on at

Like (0)

Report

Woops I'm sorry the format is wrong in the above response, I meant,
A B C D
A B C D

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

cool, tnx, will the boxes always have the same number of rows?

Was this reply helpful? Yes No
JuanGarcia9 58 on at

Like (0)

Report

Yes they should always have the same amount of rows

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

ok here is one way:

add a button and add this code to OnSelect:

//create temp collection to collect all of the split rows

ClearCollect(colAccountId,Filter(Split(TextInput1.Text,Char(10)), Not IsBlank(Trim(Value))));

ClearCollect(colBpmId,Filter(Split(TextInput2.Text,Char(10)), Not IsBlank(Trim(Value))));

ClearCollect(colRespCent,Filter(Split(TextInput3.Text,Char(10)), Not IsBlank(Trim(Value))));

ClearCollect(colAdmin,Filter(Split(TextInput4.Text,Char(10)), Not IsBlank(Trim(Value))));

//collect the sequence as required

ClearCollect(

colDoIt,

//now for every column lets add the text inputs data from the other ones

ForAll(

Sequence(CountRows(colAccountId)),

{

AccountId: Index(colAccountId,Value).Value,

BpmId: Index(colBpmId,Value).Value,

RespCent: Index(colRespCent,Value).Value,

Admin: Index(colAdmin,Value).Value

}

)

)

Result

Was this reply helpful? Yes No