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
