Control flow in Studio Web - Practice 1 - For Each and If

Learning Hub Academy Feedback
1

This course is designed so you can also learn from your fellow learners, particularly through the forum topics.

If you need help, post a question as a reply in the Forum discussion below. To increase your chances of being helped, be as descriptive as possible. Include in your comment:

  • A description of your issue: when is it happening, what activity you have trouble with.
  • A screenshot of your error.
  • You can also attach your automation project.

If you can help a fellow learner, don’t be afraid to reply and make a suggestion. Participating in the conversation helps solidify the knowledge you’ve acquired in this course.

2

Need Help: Status Check Using If Activity Not Working Properly

Hi everyone,

I’m working on Practice 1 — For Each and If in the Control Flow in Studio Web course. I’m trying to loop through rows in an Excel file and flag the ones where the Status column is blank.

I used the condition:

vb

CopyEdit

row("Status").ToString.Trim = ""

But it doesn’t seem to flag all the empty cells correctly. Some rows are being skipped even though the status is clearly blank.

3

In your if condition use: String.IsNullOrEmpty(row("Status").ToString.Trim)

If block: what you wanted to do if cell is empty.
Else: what you wanted to do if cell is non empty.

Br,
NikZ

1 Like
4

Hi @Roopa_Patel , I use the same expression and it works for me.
My expression is: CurrentRow(“Status”).ToString.Trim= “”

The image showcases a logic flow condition setup in a code editor with a paused status for a log message operation. (Captioned by AI)
The image showcases a logic flow condition setup in a code editor with a paused status for a log message operation. (Captioned by AI)566×408 15.8 KB

1 Like
5

Hi @Roopa_Patel.

Same for me:

image
image1920×1080 193 KB

Regards.

1 Like
6

First, I checked to make sure there is actually a Task ID on the row before proceeding:
If string.IsNullOrEmpty(CurrentRow.Task_ID) = false
then I checked the Status:
If string.IsNullOrEmpty(CurrentRow.Status) = true
If no status, log a message.
If no Task ID, then stop processing altogether.

Hope this helps!

7

in your condition you could try this:

image
image920×765 51.2 KB

also make sure for the action of the empty rows is default to skip so in case you edited the file and removed also the task id from some rows it will cause the issue for you.

Let me know if you need further assistance

1 Like