Getting Rich text content from SharePoint List to Infopath.

Hi,

If you want to get the content of SharePoint List into Info Path, you can do it using Data Connections ( Data Sources).

But the problem is:

You can not get the reference to the columns of type Rich Text box ( Multiple Lines of Text (Rich Text));

Here is the solution:

1) Modify the column to Multiple of Text ( Plain).
2) Add the Data Source to the Infopath.
3) Go back to the list and change the Column type back to Rich text.

Note:- In the process of converting the column type back and forth you may miss some content in that column.

Datasource in Infopath pull the items from the view of list.

Hi,

Today when I was working with InfoPath to get the list items from SharePoint List using Data Connections (Data Sources), I observed that it is pulling only first hundred items.

Then, I changed the items limit in default view of that list to 200. Then the data source in InfoPath is pulling the first two hundred items.

So, that means it is pulling the data from the Default view.