cancel
Showing results for 
Search instead for 
Did you mean: 

No conversion available from Text to Collection

Pradeep_IDC
Level 4

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

Pradeep_IDC_0-1710999859851.png

Can anyone tell me how to fix this?

 

7 REPLIES 7

Daniel_Sanhueza
Level 8

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

Daniel Sanhueza
RPA Professional Developer
Deloitte

I tried but it won't work, Daniel.

Pradeep_IDC_0-1711029606126.png

Here is the flow

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

 

Daniel Sanhueza
RPA Professional Developer
Deloitte

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

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:

  1. Utility - File Management:Get Files
  2. Utility - File Management:Split Path -> To get the folder and filename
  3. 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!

Daniel Sanhueza
RPA Professional Developer
Deloitte

_Amlansahoo
Level 11

This expression is wrong buddy. Please use the below one

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

Regards,
Amlan Sahoo