Getting the sharepoint list in Infopath displays only the first 100 entries

Question

I am extracting a list of values ​​from a sharepoint list that works well, but my problem is that it only extracts the first 100 entries. There are currently 500 entries that should be available.

Scenario: I have two comboboxes in the form of infopath:

• List of locations
• List of areas within locations

the list of locations will filter the list of areas, but since the infopath seems to retrieve only the first 100 entries, so most locations do not show any areas because the filter is not filtered.

Answer 1

. item limit SharePoint, InfoPath.

EDIT ( , ):

, MSDN ( ), , SharePoint , - , .

, .

Answer 2

, , . , . .

, , , Excel, , . , sharepoint, Excel, "export.iqy". . :

WEB
1
http://SharepointSite/_vti_bin/owssvr.dll?XMLDATA=1&List={14C4ED2B-3050-4C47-B5F3-6333C3B0FB28}&View={8E6124E0-23F2-4BA2-86E7-96E7F36BAEC8}&RowLimit=0&RootFolder=%2fLists%2fSharepoint%20Sites

Selection={14C4ED2B-3050-4C47-B5F3-6333C3B0FB28}-{8E6124E0-23F2-4BA2-86E7-96E7F36BAEC8}
EditWebPage=
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=http://SharepointSite/_vti_bin
SharePointListView={8E6124E0-23F2-4BA2-86E7-96E7F36BAEC8}
SharePointListName={14C4ED2B-3050-4C47-B5F3-6333C3B0FB28}
RootFolder=/Lists/My list

, -

http://SharepointSite/_vti_bin/owssvr.dll?XMLDATA=1&List= {14C4ED2B-3050-4C47-B5F3-6333C3B0FB28} & View = {8E6124E0-23F2-4BA2-86E7- 96E7F36BAEC8} & RowLimit = 0 & RootFolder =% 2fLists% 2fSharepoint %20Sites

, . , XML- URL.

, , .

, Argalatyr , , .