Subset of datarow cell

[Charmaine_Matsaudza (Charmaine)]

Hi :), I need help in creating a cell by combining strings from two other cells within the same data row.Uploading: example7.png…
eg I am trying to take the last two characters from A1 and the data from A2 and concatenating them and putting the result in A3.

Thanks.

[SenzoD (Senzo Dlomo)]

@Charmaine_Matsaudza,

Try this out, and let me know if you need further assistance.

Example.zip (30.5 KB)

[Charmaine_Matsaudza (Charmaine)]

@SenzoD , Hi Senzo, thank you for your response. I am getting the below error.

[SenzoD (Senzo Dlomo)]

@Charmaine_Matsaudza Hi,

That’s strange, I just downloaded it again and tested it, works fine.

try this
close the project, Delete the project.json file and load it again, it will rebuild and restore dependencies. if that doesn’t work, just upload the .xaml file again, I will check it.

[Charmaine_Matsaudza (Charmaine)]

I had to first initialize myList like this, and now its working. Thank you so much for your help!!

MyList= new List(Of Object)

[SenzoD (Senzo Dlomo)]

Awesome, glad i could help.