Power Platform Community Forum Thread Details

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 in a different text label to have the info of each column separated by a space, as its shown in the image.

Is this possible?

Categories:

Building Power Apps

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.