Answered

converting one column table to multiple columns table

(0) Share

Report

Posted on by data25

I have a table which has one column named "id/name/age" and some rows ,"1/xxx/23", "2/yyy/33", "3/zzz/55"....

I'm trying converting this table to new table which has three columns, "id", "name", "age". I guess I should use Split(), AddColumns().

Do you have any idea?

Categories:

General Questions

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

timl 35,811 Super User 2025 Season 2 on at

Like (1)

Report
Re: converting one column table to multiple columns table

Hi @data25

My inclination would be to split the data at the data source level. Perhaps you use a data source that supports computed columns?

Failing that, here's the syntax you would use that incorporates the AddColumns and Split functions.

AddColumns(myDataSource, "ID", First(Split(IdNameAgeColumn, "/")).Result, "Name", Last(FirstN(Split(IdNameAgeColumn, "/").Result, 2)).Result, "Age", Last(FirstN(Split(IdNameAgeColumn, "/").Result, 3)).Result )

Hope that helps.

Was this reply helpful? Yes No
data25 5 on at

Like (0)

Report

Re: converting one column table to multiple columns table

Thank you very much for your answer ! It works as expected !
I always use Google Sheet as datasource, but in case this I faced 6 columns limitation, so I concatenate multiple columns in Google Sheet before powerapps, and then split 6 columns again.
That's why I'd like to know this.
Thank you!

Was this reply helpful? Yes No
timl 35,811 Super User 2025 Season 2 on at

Like (0)

Report

Re: converting one column table to multiple columns table

Thanks for clarifying the Google Sheet data source. I'm very glad the formula works for you.

Was this reply helpful? Yes No
CP0822 66 on at

Like (2)

Report

Re: converting one column table to multiple columns table

Hi,

I'm trying to do something very similar. I have one textinput where the user paste a data from Excel.

I want to save this information in a collection with multiple columns, this is my code right now

Collect(
TestColl;
Split(
Substitute(TextInput3.Text;Char(9);"/");
Char(10)
)
);;AddColumns(TestColl;"Fase";First(Split(Result;"/").Result).Result;"Done"; Last(FirstN(Split(Result; "/").Result; 2)).Result)

This is what I'm getting right now, any ideas?

Was this reply helpful? Yes No