Answered

Pasting Excel table into text input

(0) Share

Report

Posted on by WorkingRicardo

878

Is there an easy way to paste Excel tables from the clipboard to our apps? What I want to accomplish is for example I have this table:

If I paste into a multiline text input it pastes like this:

I need all data of every column in a different text label to have the info of each column separated by a space, as its shown in the image. so, 4 text labels, one with "1 2 3", "A B C", "I II III" and "One Two Three"

Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Gil0 128 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @WorkingRicardo,

Adding the following formula to your label's Text property should accomplish transposing your rows into columns:

With( { words: Split(Substitute(Trim(ipt_YourTextInputControl.Text), Char(10), " "), " "), numCols: 4, numRows: CountRows(Split(Substitute(Trim(ipt_YourTextInputControl.Text), Char(10), " "), " ")) / 4 }, Concat( Sequence(numCols) As colIndex, Concat( Sequence(numRows) As rowIndex, Last( FirstN( LastN(words, CountRows(words) - (rowIndex.Value)*numCols), colIndex.Value ) ).Value & " " ) & Char(10) ) )

Just make sure to replace "ipt_YourTextInputControl" to your actual input control's name.

If my response helped figure out the issue, please mark as resolved so it helps direct others.

Was this reply helpful? Yes No
WorkingRicardo 878 on at

Like
a
(0)

Report
Copy link

Link copied!

@Gil0 hey thanks for your reply :)
This works but it just realised I explained incorrectly what I needed.

I have 4 text labels, and I need that each shows a different column. So textLabelA would be 1 2 3", "A B C", "I II III" and "One Two Three".

Been trying to fiddle with the provided code to get this but can't seem to get it to work to do this.

Sorry for the inconvenience. How would I acheive this? And thanks in advance!

Was this reply helpful? Yes No
WorkingRicardo 878 on at

Like
a
(0)

Report
Copy link

Link copied!
@Gil0 hey again! I managed to get the outcome wanted with this code below :)
With( { words: Split(Substitute(Trim(DataCardValue2.Text); Char(10); " "); " "); numCols: 4; numRows: CountRows( Split(Substitute(Trim(DataCardValue2.Text); Char(10); " "); " ") ) / 4 }; Concat( Sequence(numRows) As rowIndex; Last( FirstN( LastN( words; CountRows(words) - ((rowIndex.Value - 1) * numCols) ); 1 // columna 1 ) ).Value & " " & Char(10) ) )

I'll put your post as the answer as I used that as a basis. Thanks a lot :)

Was this reply helpful? Yes No