How to declare 3 conditions in if

how to declare the more conditions in if
example: if the column has blanks and other column has dates how to declare that in if condition

Hi @anjani_priya

Try this. Specify if you have more conditions:

If activity:
   Condition: String.IsNullOrEmpty(CurrentRow("columnname").ToString) And IsDate(CurrentRow("columnname").ToString)
   Then:
      // Your actions if both conditions are true
   Else:
      // Your actions if at least one condition is false

Hope it helps!!
Regards


in this condition i have to declare the null
i have condition like column a should have date and column b should have null
how to declare that in if condition

Hi @anjani_priya

Could you try this condition:

If 
CurrentRow("Acknowledgement Date").ToString.Contains(Now.ToString("MMMM")) AndAlso
               CurrentRow("Acknowledgement Date").ToString.Contains(Now.AddMonths(-1).ToString("MMMM")) AndAlso
               String.IsNullOrEmpty(CurrentRow("Vehicle Unloaded Date").ToString)
  Then:
      // Your actions if all conditions are true
   Else:
      // Your actions if at least one condition is false

Hope it helps!!

how to replace all the column values with a value by modern activity

You can use the Find/Replace Value activity to find the specific values and replace with the required values.

MicrosoftTeams-image (2)

Hope it helps!! @anjani_priya

no it just replacing only one value but i want to replace a whole column with a value

No it replace all the values. @anjani_priya

Provide your input here or create a new post and attach the input and provide what to replace.

sheet1.xlsx (38.9 KB)
i want to replace the column with ‘xyz’
i have already created a post

which column you want to replace with xyz. Are you asking about to replace all the values in the column with xyz. @anjani_priya

in name column all the values should be replaced with xyz

Okay @anjani_priya

→ Use the read range workbook activity to read the excel and store in a datatable datatype variable, let’s call it as dt_Input.
→ After read range use the assign activity to write the below expression

- Assign -> Currentrow("name") = "xyz"

→ out of for each insert the Write range workbook activity to write the dt_Input to the same excel sheet. In the properties of Write range workbook activity check the add headers option.

Check the below workflow for better understanding,

Input -

Output -

Hope it helps!!

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