Error in 'Assign' activity

Help Studio
, ,
1

Hi All,

After updating to Windows compatibility, I’m getting the following error message for ‘Assign’ activity: ‘Assign name of downloaded file to variable: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.’

The error refers to the following expression that worked properly under Windows (Legacy) compatibility:
String.Join(“”, Directory.GetFiles("C:\Users\grabskik\Downloads",”*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) )

Could you please suggest what the correct expression should be?

Thank you in advance,
Kaz

2

Kindly note:

Directory.GetFiles("C:\Users\grabskik\Downloads",”*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1)

is returning a string / the fullFilePath, so the cardinality is 1 and not a collection. The usage of String.Join is not needed or bring it e.g. with { } to a collection

We saw a lot of reports of this within this setup. Ensure that not copy paste issues is occuring on the quotes and no ” or other quotes instead of "is used. Try again when the corrections were done

3

HI @kgkorespondencja

Check out this thread

Regards
Gokul

4

Directory.GetFiles(“C:\Users\grabskik\Downloads”,”*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).First()

5

Thank you for your suggestions. Please let me test them.

6

Solution provided by @Gangadhar_Athili is the solution I was looking for.

7

Thank you @Gangadhar_Athili - it works!

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.