toString does not accept array types

Rajneel Sharma 1

Hi All,

Dataflows which have been working in the production environment have now started failing due to this error

(DF-FN-006 - toString does not accept array types)

This seems to be a recent change and I have quite a lot Mapping Dataflows which rely on these conversions. e.g toString(columnname)

Anyone know of a solution or workaround i can use?

Thanks

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2020-06-02T22:53:03.467+00:00

Hi @Rajneel Sharma ,

Thanks for reaching out. Could you please share some sample array type that you are trying to convert to String and expected output so that I shall try reproducing the issue?
Also please confirm if this is breaking any of your production which was working fine before?
Rajneel Sharma 1 Reputation point

2020-06-03T22:05:24.193+00:00

Hi @KranthiPakala-MSFT ,

The problem seems to have resolved itself the next day. But one example would be typecasting an array type to string in the Data preview of an Mapping Dataflow.
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2020-06-04T21:38:20.647+00:00

Hi @Rajneel Sharma ,

Glad to know that you are unblocked. It seems to be a transient issue.

In case if you notice this behavior again, I would highly to recommend to file a support ticket that way a support engineer can take deeper look into the root cause and notify the appropriate team to avoid this happening again.