Continue from blank column

Hi, please help me. I want to add a condition in the attached work flow, if the field “output” is blank, then i will copy field “domain-list”.

How can i do it? Please help. thanks!

TotalVirusCheck.xaml (240.8 KB)

@Joanna2

you are using write cell to write the value in the output column

is it right?

if you want to check the value is empty or not in that column ,before writing into it ?

i want to check if the column is empty before it copy and paste into a browser to do search.

For eg, for AA and BB, there’s already a value in column2, so i would want to skip that and proceed to CC

column1 column2
AA yes
BB yes
CC

Hi @Joanna2

Read Range (Output: dtData)

For Each Row in dtData:
  --> If (Condition: String.IsNullOrEmpty(row("output").ToString) or String.IsNullOrWhiteSpace(row("output").ToString))
    --> Type Into (row("domain-list").ToString)
    --> Get Text from website (str_output)
    --> Assign (row("output") = str_output)

Hope it helps.

@Joanna2

you are already using for each excel row activity

inside use if
condition as Domain(“ColumnName”).equals(“”) then
place the activities like write cell or other

else
no need to place any activity

cheers

Hi @Joanna2

Check out this XAML file

04.10.2023_Fourm_1.xaml (8.8 KB)

Hope it will helps

Regards
Gokul