I am trying to create a data connection(data source) from Infopath 2007 to SharePoint Online. I have downloaded Infopath and using client version.
Below are the steps which I performed.
- I have added a control - Dropdown List Box
- I have created a new connection to receive data from a SharePoint List. Note: This list resides in sharepoint online.
- I have given the List Name and also columns.
- I have chosen the data source for dropdown list and selected value , display name.
Now, when I open the form in Preview mode, I see error:
Infopath contacted data source but failed to retrieve data.
The query cannot be run for the following DataObject: ABC
InfoPath cannot run the specified query.
I want to know if this connection from InfoPath 2007 to SharePoint Online is not possible.