Check the column values and Append values in invoke workflow

[Sathish_Kumar_S]

This invoke work flow will insert the values to DB at end of the each transaction

How to make sure when currentRow(“Attachment_Header) is empty or null – >> Do not pass any value to the in_comments argument

When currentRow(“Attachment_Header) has the value “No” not “Yes” – Then Pass the vaue as “Attachment missing”

We need to do this check for each columns ( Only one row) and Pass the value like this to in_comments argument : Attachment misising; Special commodity code used; Attachment/comment visible to supplier

[supermanPunch (Arpan)]

@Sathish_Kumar_S

How to make sure when currentRow(“Attachment_Header) is empty or null – >> Do not pass any value to the in_comments argument

When currentRow(“Attachment_Header) has the value “No” not “Yes” – Then Pass the vaue as “Attachment missing”

Hi @Sathish_Kumar_S ,

For the Highlighted Parts, we can do so as below :

If(String.IsNullOrWhitespace(CurrentRow("Attachment_Header").ToString),"",If(CurrentRow("Attachment_Header").ToString.Equals("No"),"Attachment Missing","Yes Value"))

However, Not clear on the part where the Attachment Header is Yes → What to be done ?

[Sathish_Kumar_S]

Let share my exact requirement:

Above the values available in DT. We need check following combination

Do not throw any error if currentrow(Attachment_LineItem) is empty or NULL and other columns

IF currentrow (Attachment_Header)=“No” AND IF currentrow (Attachment_LineItem)=“No”—> Vice Versa - > then only pass the value as “Attachment missing” Else Do not pass anything.

Same way we need to do this check for other columns combination