[Solved] SharePoint designer workflow lookup for number field is returning 0 for the blank fields.

1. One of the ways is to have a workflow variable and assign it to the lookup value. And then comparing it to 0.


2. Other way is to create a calculated text field in the list and use it instead of the number field in the workflow lookup.

Calculated text field =IF([ColumnName]=0,"-",TEXT([ColumnName],0))


=TEXT([Column],<format>) is used to avoid unwanted zeros after the decimal point. Without this, the final value for the calculated text field would look something like 123.000000000

 <format> is a number format in text format. e.g. 0; 0.0; 0.00; etc.

Multiple lookup SPD Workflow: How to filter list item based on two columns in SharePoint designer 2013 workflow?

In SharePoint designer you can lookup only one column.

So, create a calculated column in the source list and concatenate the two columns.

Calculated column (KEY) = CONCATENATE([ColumnA],[ColumnB])

Now you can perform lookup on this calculated column.

In SharePoint designer create a variable by concatenating the columns containing the data same as ColumnA and ColumnB.

As SPD doesn't have concatenate function so, you can use string builder to achieve the merged string: