Unanswered

Splitting string into multiple columns

(0) Share

Report

Posted on by NicoPet

Hello all,

I have an issue with splitting a string into multiple columns.

https://www.youtube.com/watch?v=sj-UDq8Iuow&t=221s for reference i basically want the same result as in this video by using the split function in PowerApps

First of i made a collection containing one column with records from DepartmentKey in the table Dim.Department

The records in the collection is displayed as; DepartmentCode||Company||Entity. What I want to achieve is extracting Department and Company and split them out into two separate columns.

Below is the code i used where, in this example right here, I am only trying to extract Department. The syntax is the same as in the linked video, however it seems the syntax since has been changed or updated, because "result" is no longer recognized by PowerApps. Instead, it want me to use "value" which at first glance seem to work but when looking at the collection table it shows table icons instead of the Department code record. Clicking at one of the records I am able to see the correct Department Code, its just that it returns these table icons for some reason.

I hope this makes sense to someone and they can solve my problem

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @NicoPet ,

Please try:

ClearCollect( colDeptSplit, AddColumns( colDeptKey, "Dept", Index(Split(DeptKey,"||"),1).Value, "Company", Index(Split(DeptKey,"||"),2).Value, "Entity", Index(Split(DeptKey,"||"),3).Value ) )

Best Regards,

Bof

Was this reply helpful? Yes No
NicoPet 29 on at

Like (0)

Report

@v-bofeng-msft

Thanks to the code you provided it correctly extracts the Department Code and splits it into a new column without showing it with these table icons. Though it does not do it for company and entity. Do you have any idea how to update the code so it also extracts the other two?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @NicoPet ,

The formula should work if the Deptkey is in 'DepartmentCode||Company||Entity' format . Could you please show me a sample?

Best Regards,

Bof

Was this reply helpful? Yes No