[Solved] SharePoint workflow 'Calculated' column cannot be used as lookup.

Error: SharePoint workflow 'Calculated' cannot be used in the query filter.

Instead of preparing the unique key using a calculated column, create a workflow to concatenate the columns and update the unique key (to fetch the row later).

Similarly, use the string builder in SharePoint designer to lookup for the desired item.

This can also be used to look up more than one column in SharePoint designer.


Note: This is not the recommended way for lists with 100s of items. Instead, prepare the concatenated key in the source data(e.g. Excel) or in the InfoPath form.

[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.

SharePoint : How to use [Today] in a calculated field?

Option 1: Create a field named 'Today'. Use it in the formula. Now, delete the 'Today' field.

Option 2 (recommended): If possible, use list views instead. You can use [Today] under filter options.

Here you can compare a date field with [Today]+/-SomeNumber.

Example: Date Field1 < [Today]+100