Lookup Selected boxes: how to get "is empty" or "is not empty"

Lookup Selected boxes: how to get "is empty" or "is not empty"

Whilst using SharePoint Designer to create a workflow I needed a way to check if a lookup column value was 'blank' or 'not blank'. This is not possible with Lookup type columns, but annoyingly and confusingly it is possible with other data types.

Figure 1

SharePoint only provides two operator options on lookup columns "Equal" or "not Equals". The problem is SP Designer will not allow you to simply enter a comparison value of "" or "blank" or "null".

This trick is to convert your Lookup value into a different data type, a string variable.
 
Example: I have a List containing a column called Projects, which is a lookup to another List (of projects info).
 

Figure 2

As you can see in Figure 2: First put your lookup value into a string variable.

Then use the string in your 'if' statement. You can now check if you value 'is empty' or 'is not empty'.



How To Enable Save Functionality of infopath form In Browser

Step 1 :

      

Go to the Form Option and enable Save button by selecting Save

Step 2 :

Publish the form to desire server location.

Step 3:

After publish,Open the form in browser. Copy the url of newly published form to notepad

Step 4:

Now copy the url where you need to save the form

Step 5:

Remove “/Forms/MyItems.aspx” from above URL. So that we can get absolute path of that folder

Step 6:

Now add this(save location) url to the url of published form with preceding &SaveLocation=

Now you are completed your task successfully.

Note:Request variable in Url are:

1)     XsnLocation:  the location of .xsn file.

2)     OpenIn: where to open.

3)     SaveLocation: the save location of the form.

How to get unique number in Infopath field

Use following expression in text field value

normalize-space(

 concat(

 10/(string-length(userName())),

 substring-before(substring-after(today(), "-"), "-"),

 substring-after(substring-after(today(), "-"), "-"),

 substring-before(substring-after(now(), ":"), ":"),

 substring-after(substring-after(now(), ":"), ":")

 )

 )