How to add multiple conditions in if statement with variables

Help
1

proj
proj781×460 21 KB
location ,role are the variables extracted from excel…Thanks in advance for the help

2

Hi @syed1994,

Generic value need to convert

use .ToString()

like-->role.ToString()

row(0).ToString().Contains(role.ToString()) and row(0).ToString().Contains(location.ToString()) and row(0).ToString().Contains(billing_rate.ToString())

Regards,
Aricu

1 Like
3

row.item(0).ToString.Contains(role) AND row.item(0).ToString.Contains(location) AND row.item(0).ToString.Contains(billing_rate)

4

optim_ustv3_DOWNLOADEDv2 has thrown an exception

Source: If

Message: Value cannot be null.
Parameter name: value

Exception Type: ArgumentNullException

System.ArgumentNullException: Value cannot be null.
Parameter name: value
at UiPath.Core.Activities.ScopeActivity.OnFaulted(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.Invoke(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.FaultWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

5

Seems like one of the value is empty, can you log the values and see if you get the values you expect