Update row in a data table is not working

Help Activities
1

Hi,

I am trying to update row ans its not updating the value i am passing

Attached is the screenshot. Can someone help here please?

A screenshot of a software interface displaying log messages and a flowchart diagram. (Captioned by AI)
A screenshot of a software interface displaying log messages and a flowchart diagram. (Captioned by AI)1080Ă—2340 93.8 KB

2

Hi,

Can you try to use the following expression in condition of if operator?

row.Item("Comments") isnot Nothing AndAlso not String.IsNullorEmpty(row.Item("Comments").ToString())

Regards,

3

@Krithi1,

Try using the condition like this:

If(IsDBNull(row("ColumnName")) OrElse String.IsNullOrEmpty(row("ColumnName").ToString()), "Empty column values", "Got the values")
4

@ashokkarale

I assigned this statement into a variable but its coming out as null

5

@Yoichi

I don’t see the value that I need to replace in this query. Seems like the query is checking only if the value is null?

6

@Krithi1,

That’s weird. It should return either “Empty column values” or “Got the values”. Can you share screenshot how you are using.

7

@ashokkarale

A computer screen displays a software interface with a list of recent activities, including phone and email validation entries, one of which is highlighted with a neon green arrow. (Captioned by AI)
A computer screen displays a software interface with a list of recent activities, including phone and email validation entries, one of which is highlighted with a neon green arrow. (Captioned by AI)1080Ă—2340 122 KB

8

Hello,
Write something there :

The image shows a section of code that checks if a "Comments" field is null or empty and sets it to a default message "Phone number and email exists" if it is. (Captioned by AI)
The image shows a section of code that checks if a "Comments" field is null or empty and sets it to a default message "Phone number and email exists" if it is. (Captioned by AI)655Ă—127 22.4 KB

9

@bruno40

Comments are empty right now. If I understand it right, I am trying to replace the null value with the text “phone number and email exist.” Is that not the right understanding?

10

@Krithi1,

No this will not replace the null value. The logic will only tell if the column is empty or not.

If you want to replace the null/empty/blank values with phone number and email exist. use this logic in Assign activity.

row("Comments") = If(IsDBNull(row("ColumnName")) OrElse String.IsNullOrEmpty(row("ColumnName").ToString()), "Phone number and email exist.", "")
1 Like
11

It depends on what you want :
if(condition, condition is true, condition is false)

if(String.IsNullOrEmpty(row(“Comments”).ToString), “it is empty”, “there’s something”)

12

Hi,

My intent is as the following. Can you try this?

if(row.Item("Comments") isnot Nothing AndAlso not String.IsNullorEmpty(row.Item("Comments").ToString()), row.Item("Comments").ToString(), "Both Email and Phone Number exists")

Regards,