Add multiple lookup column to SharePoint 2010 list InfoPath 2010 form

This SharePoint InfoPath tutorial, we will discuss how to add multiple lookup columns in SharePoint list InfoPath form. We will see also, how to solve the error, This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by Administrator.

Sharepoint has a limitation that you cannot implement more than 8 lookup columns in a form. If you put more than 8 lookup column then you will get the error message as:

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by Administrator.

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by Administrator.

This you can solve by increasing the limit in SharePoint central administration.

Here is another solution without any change in central administration by following the below steps:

Open list views customized form, then add the dropdown list from the control task pane.

Then in the drop-down dialog box select as below and provide your list name column name.

This view cannot be displayed because the number of lookup and workflow status columns

Now add a textbox and assign the value of drop-down list into the textbox.

Click on the dropdownlist-> right click -> Change binding -> from main data source select the textbox -> Ok

Delete the textbox from the form.

Now create a data connection from the list where you want to retrieve into the drop-down list.

Now right click on the dropdown list -> choose drop-down list properties and fill up the dialog box as below.

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by Administrator.

In the data source select the data connection you created above.

Now click on Ok.

Now delete the dropdown list from the right side column to prevent it promoted in the SharePoint list.

Follow the same step for each drop-down list.

You may like following InfoPath tutorials:

I hope this article was helpful in how to add multiple lookup columns to SharePoint 2010 list InfoPath 2010 form.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>