Assistance with skip sequence if table value = null

uiautomation
activities
studio

#1

Hello,
1st would like to thank community members with your inputs I’m able to automate most of my project tasks.

Coming to my problem.

I have a sequence of 3 layers inside a each row activities which reads the data from csv and feeds into a system form.

The activites are create a new user and add a phone number as relationship but with exceptions there are records where value is null or blank. I would like to skip a sequence if the value is blank or null and follow the next sequence current flow is configured as below

  1. Read CSV
  2. Login to system
  3. Pass all value to New User Form followed By creating user relationship with Phone number and Zip code
  4. Complete and process stops

However is either of the values are blank or null i would like the 2nd or 3rd to be skipped and move to next sequence.

Thanks for your assistance in advance. I have tried tutorials but couldn’t get it correctly


#2

Hi Ankit,
You could try adding an If activity inside your For Each Row activity to check if there are blank values and skip the remaining steps if so.

Example:
If condition: ( NewUser = “” OR PhoneNumber = “” )
Then: — leave empty to skip —
Else: your sequence of steps to pass data to the user form

This will let you loop through each row and check if it is blank. If blank it will loop to the next row. If not blank it will enter the data in your new user form. Hope this helps.


#3

Hi Arthur,
Thanks for your suggestion however I have multiple steps and would like each step to be skipped using nested IF statement

Example if User = “”, Go to Owner check if value is not Null process if null skip and proceed to step 3 to check if Location is not blank.

Any suggestions will be helpful


#4

Try the below logic:

Main flow

  1. Invoke workflow 1 - Read CSV
  2. Invoke workflow 2 - Login to system
  3. Invoke workflow 3 - pass your read csv as ‘In’ argument
    For each row in the csv
    Check user not null
    Then: check if Owner is not null, Else: leave blank
    … Then: check location is not null, Else: leave blank
    … …Then: Enter the details in system, Else: leave blank

This will repeat for all rows and in case any field is empty it will not do anything.
If all present it will enter the details in system

Hope this is what you want :robot: