Forum Discussion
We cannot convert the value
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
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
3 Replies
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
JimmyAnonymous 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.
