Browser Forms

Re: Query data from SharePoint list. What type of data connection should i use?

Hilary Stoupa — Fri, 13 Jul 2012 14:56:31 GMT

Hey, great! glad you got it working!

I love the query fields in ShP 2010 / IP 2010.

Re: Query data from SharePoint list. What type of data connection should i use?

Matt63119 — Fri, 13 Jul 2012 13:45:44 GMT

Got it. The data connection had to be upgradded to 2010 version. Changed the form type to web browser form, then upgraded data connections and relinked fields.

Re: Query data from SharePoint list. What type of data connection should i use?

Matt63119 — Fri, 13 Jul 2012 13:33:27 GMT

I created a new form and it worked. I need to get the old form working. The old form was created in IP 2007. It appears the option when you set the field equal to a field in SP its missing the queryFields option the only thing available is dataFields.

Re: Query data from SharePoint list. What type of data connection should i use?

Matt63119 — Fri, 13 Jul 2012 12:41:52 GMT

Hilary-
Thank you for your quick reply. Yes, I am using both SP 2010 and IP 2010. I cannot seem to get this to function correctly. I am getting an error message that states "Some rules were not applied. The parameter is incorrect.".

Here is what I have and what I did.

3 Controls:1.Ticker Input textbox 2.Find Button 3.Full fund dropdown

On the Find button control I created a rule to sets the value of the ticker input textbox equal to the ticker field in SP. On the same find button I queried the SP list.

I then set the full fund dropdown equal to the full fund name in SharePoint.

I receive the error message when I click the find button.

Re: Query data from SharePoint list. What type of data connection should i use?

Hilary Stoupa — Thu, 12 Jul 2012 21:09:32 GMT

I really really hope you are using IP 2010 & ShP 2010? Are you? If so, you can just add a data connection to the list, but don't automatically query on load. Then you can set the query field to the value you want to search for and run the query in form rules.

Query data from SharePoint list. What type of data connection should i use?

Matt63119 — Thu, 12 Jul 2012 20:45:21 GMT

Can someone assist me in figuring out what type of data connection I need.

In a SharePoint list I have about 10,000 stock tickers in one column and there full name in another. I want to query the list by ticker to pull back one fund name in a Browser enabled Infopath Form. Example; Search: CSCO Result: Cisco Systems