VLOOPUP Activity Not Working in Current Version

Feedback Activities
, ,
1

Greetings,

While the Vloopup activity works without any error in version 2.16.0, when I update it to the current version, it does not work and receives Convert errors.
We cannot even perform simple vloopup operations.

Good work.

3

Hello @Samet_Onder ,
Try this
Identify the value type in the Excel. If it is double , keep the Vlookup variable as Double.
Otherwise simply Use the Varibale type as a generic variable type and convert it later as your requied one.

MyGenericVariable ---->Generic variable

Conversion

MyDouble=cdbl(MyGenericVariable)   ---> Double  1.223

MyString= MyGenericVariable.ToString.Trim   ---> String "Hello"

MyInteger=Cint(MyGenericVariable)    ---> Integer   2
1 Like
4

Greetings,
Thank you for your support first of all, but I wanted to report a strange situation that works without error when I make the version 2.16.0.

5

Hi @Samet_Onder ,

Would you be able to confirm which version is impacted? In the meantime, I’ve tried to repro this and just wanted to confirm if the error you are seeing is:

VLookup: StringConverter cannot convert from System.Double.

I’ll raise an issue for us to investigate this further.

Many thanks for flagging this.

Raluca

7

Hi @Samet_Onder ,

We’ve looked into this and haven’t managed to repro this again. Would you be able to share more details about this so we can investigate this further.

Thanks,
Raluca

8

Hi @Samet_Onder ,

Just wanted to check if you are able to share a sample project repro’ing this behavior to help us investigate this further.

Many thanks,
Raluca