topic No conversion available from Text to Collection in Product Forum

No conversion available from Text to Collection

Pradeep_IDC — Thu, 21 Mar 2024 05:44:42 GMT

Internal : Failed to translate data - No conversion available from Text to Collection

Can anyone tell me how to fix this?

Re: No conversion available from Text to Collection

Daniel_Sanhueza — Thu, 21 Mar 2024 13:55:29 GMT

What if you set the new name on a variable before using that action ? Avoid sending the function in the action, instead, use a text variable with the new name

Regards

Re: No conversion available from Text to Collection

Pradeep_IDC — Thu, 21 Mar 2024 13:59:25 GMT

I tried but it won't work, Daniel.

Re: No conversion available from Text to Collection

Pradeep_IDC — Thu, 21 Mar 2024 14:00:16 GMT

Here is the flow

Re: No conversion available from Text to Collection

Daniel_Sanhueza — Thu, 21 Mar 2024 14:14:01 GMT

Uhmm thats weird. What if you hardcode the path and the new name ? Just to see if the error persist

Re: No conversion available from Text to Collection

Pradeep_IDC — Thu, 21 Mar 2024 14:37:23 GMT

If I hard code that value means it is working, but my file name is dynamic one.

Re: No conversion available from Text to Collection

Daniel_Sanhueza — Thu, 21 Mar 2024 18:11:19 GMT

Hello! Sorry for my late response. Yes, I just wanted to know if you hardcode the error persist, it isnt the case so I think there's some troubles with the collection not being initialized but this is only a guess, I tried to replicate your error following your same steps but then I realize that my Utility - File Management isnt updated so I will asume that you have the updated version from Dx, wich I couldnt download because cant login 😭 due an error that doesnt compete with this topic (Good luck chases me but I'm faster 🤣). I couldnt came to reply on this empty handed so what you can do is not use "Rename File" action, instead use this secuence of steps:

Utility - File Management:Get Files
Utility - File Management:Split Path -> To get the folder and filename
Utility - File Management:Move File -> Send [Files.Path] and on Destination Path, send the Folder+ the replace function that you have.

I tested this, and the result it the same file with the new name on the same folder.

Regards!

Re: No conversion available from Text to Collection

_Amlansahoo — Fri, 22 Mar 2024 11:48:06 GMT

This expression is wrong buddy. Please use the below one

Replace([Files.Name], ".xlsx", FormatDate(Today(), "dd.MM.yyy"))&".xlsx"