We cannot convert the value

[Anonymous]

I'm trying use Text.Combine to concatenate the values from two columns which are both text but I get the error

"We cannot convert the value "003011" to type List.
Details:
Value=003011
Type=[Type]"

Anybody any thoughts.

Thanks in advance

[Jimmy801 · Accepted solution]

Hello @Anonymous 

Text.Combine takes a list and you are feeding it with a text-value. This is the problem. How are you referencing your two columns ? you need to have the result on row level? Then just use [Colunn1]&", " & [Column2]. 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Anonymous]

Thank you very much, that's worked for me.

[negi007]

@Anonymous  Please check if there are no null values in your dataset. It is possible that null values might be preventing you from performing the task that you are trying to achieve.