web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to split a single-...
Power Apps
Answered

How to split a single-column text string into multiple columns

(0) ShareShare
ReportReport
Posted on by 9

Hi, basically I have a column('Answer') in a collection('QnList') that has to be uploaded onto sharepoint, but transposed into a row, with each entry under one column. In the 'Answer' collection it looks like:

    Answer

1.1_false

1.2_true

1.3_true

What I managed to work out is to concatenate the column 'Answer' separated with commas into a string, then upload this onto the SP list via a form. This leaves me with one column and one row with all the 'Answer' records concatenated into a string. On the SP List it looks something like this:

                       col1

row 1 1.1_false,1.2_true,1.3_true,1.4_false,.....

What I need help with now is to split this string into columns while remaining on the same row, which is why I do not think Split() will work in this case. Ideally what i am hoping to get is:

            col1         col2        col3         col4 

row1 1.1_false  1.2_true  1.3_true  1.4_false .....

Can this be done?

Categories:
I have the same question (0)
  • timl Profile Picture
    36,634 Super User 2026 Season 1 on at

    Hi @gloomypika 

    Would you know beforehand how many rows you want to transpose? Because if so, that would make this task easier.

  • gloomypika Profile Picture
    9 on at

    I am building 2 similar checklist apps, so every row corresponds to a question in the checklist. I am currently focusing on the shorter checklist of 19 qns/rows but the 2nd larger checklist will have about 70 qns/rows. Any suggestions?

    I am also thinking of using a addcolumn and a trim to do this.

  • Verified answer
    Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on at

    Have you tried updating the SPList with Patch() and using the Lookup() to assign the correct values to the SPColumns.

     

    Here is an example of what it might look like:

     

     

    Patch(
     SPList,
     Defaults(SPList),
     {
     SPColumnName1: LookUp(QnList, StartsWith(Answer,"1.1"),Answer),
     SPColumnName2: LookUp(QnList, StartsWith(Answer,"1.2"),Answer),
     SPColumnName3: LookUp(QnList, StartsWith(Answer,"1.3"),Answer)
     }
    )

     

     

  • gloomypika Profile Picture
    9 on at

    Now i know why knowing how many rows i have beforehand makes this easier and also, i can easily add new/remove columns should there be any changes to my checklist data, thanks!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 84

#2
WarrenBelz Profile Picture

WarrenBelz 79 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 40 Super User 2026 Season 1

Last 30 days Overall leaderboard