Answered

Split list columns to a new collection

(0) Share

Report

Posted on by JOTAELECD

Hello,

I'm a pretty novice user in PowerApps
I have a sharepoint list with three columns (ID,Tasks,Completed)
I have two columns that contain a text string with values separated by a separator ", ". The number of these values is variable.

What I'm trying to achieve is to split the two columns and create a new collection with the split result, with as many columns as needed and thus be able to display it in a gallery.

Here is an example:

ID	Tasks	Completed
32423	My Task1,My Task2,My Task3	true,false,true

I need something like;

ID	Tasks1	Tasks1	Tasks2	Completed1	Completed2	Completed3
32423	My Task1	My Task2	My Task3	true	false	true

Remember: The number of these values is variable.

Is it possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

developerAJ 4,664 on at

Like (0)

Report

if the number of values in column is dynamic we wont be able to convert into as per you requirement. it should be static
you can define max columns limit lets say 10 task or something than you can use addcolumns() to fulfil your requiremnt .

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
You can connect with me on LinkedIn

Was this reply helpful? Yes No
JOTAELECD 11 on at

Like (0)

Report

Thank you for your answer

And what would it be like for a limited number? Because I have not managed to do it either with the instructions I have found here. I always have mistakes.

Was this reply helpful? Yes No
Verified answer

developerAJ 4,664 on at

Like (1)

Report

Use this as reference

You can use on Any Test button to check code:
ClearCollect(colTest,{ID:1,Tasks:"Task1,Task2,Task3",Completed:"true,false,true"},{ID:2,Tasks:"Task1,Task3,Task4",Completed:"true,true,true"},{ID:3,Tasks:"Task3,Task2,Task1",Completed:"true,false,true"},{ID:4,Tasks:"Task1,Task2,Task3",Completed:"false,false,true"});
ClearCollect(ColCon,AddColumns(colTest,"Tas1",First(Split(Tasks,",")).Value,"Tas2",Last(FirstN(Split(Tasks,","),2)).Value,"Tas3",Last(FirstN(Split(Tasks,","),3)).Value,"Com1",First(Split(Completed,",")).Value,"Com2",Last(FirstN(Split(Completed,","),2)).Value,"Com3",Last(FirstN(Split(Completed,","),3)).Value))

Please click Accept as solution and give it Thumbs Up if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
You can connect with me on LinkedIn

Was this reply helpful? Yes No