What kind of Error this

Can anyone help me please?

i need a solution for the following condition:
Action is null and material id is null then result is Invalid
Action is value and material id is null then result is Material id is invalid
Action is null and material id is value then result is action id is invalid
Action is value and material id is value then result is action id is created

Main01.xaml (17.9 KB)
for references

I need this kind of outputBook1.xlsx (8.6 KB)

What should i do change? where can i mistake it?

@Abubakkar

Change expression in IF activity. Try below one:

String.IsNullOrEmpty(row(“columnName”).Tostring)

Thanks @lakshman It’s perfectly working but I need another if condition about
1.Action is value and material id is null then result is is invalid
2.Action is null and material id is value then result is id is invalid
3. Action is value and material id is value then result is action id is created

String.IsNullOrEmpty(row(“action”).Tostring) and String.IsNullOrEmpty(row(“matid”).Tostring)

is this correct condition?

If: Column ‘MaterialID’ does not belong to table .

why frequently i get this error?
Can you help me?

This condition is to check both column values empty or not.

Please check column name properly in Excel file and it is also case sensitive

1.Both column values are empty 1st condition

@Abubakkar

Oh ok then it’s correct.

Main01.xaml (18.3 KB)

for you references

Book1.xlsx (8.5 KB)

If Both columns are values How can I write condition?
[/quote]

Main01.xaml (18.2 KB)

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