General

Re: Populate a form's field with a SharePoint list field's text using "query using a data connection" rule

AlexK — Fri, 08 Mar 2013 21:24:32 GMT

Strangely, dragging the control for the Append changes text field shows no control at all when I actually open the form. Possibly because there is no text inside yet? I would think at least it would show a text area that is empty.

Re: Populate a form's field with a SharePoint list field's text using "query using a data connection" rule

AlexK — Fri, 08 Mar 2013 20:38:00 GMT

Ok, an update: I was able to get it working using Rules to set my form's field to the SP field, but it only works for if the SP text fields is NOT "Append Changes to Existing Text"-enabled. I did not think to just drag the data connection's field into the form, so I tried that with a text field that had "Append Changes to Existing Text" enabled but nothing shows. I think I have read that this should work with an "Append Changes to Existing Text" field as well, so there must be something I'm missing.

Re: Populate a form's field with a SharePoint list field's text using "query using a data connection" rule

Hilary Stoupa — Fri, 08 Mar 2013 19:58:14 GMT

Hi -

You have a secondary data connection to your SharePoint list? You can drag the field from the data source task pane onto the form. Or you could use a calculated value to display the value - am I not understanding the question?

Re: Populate a form's field with a SharePoint list field's text using "query using a data connection" rule

AlexK — Fri, 08 Mar 2013 19:48:29 GMT

Thanks. I already have the Query set up, and I am doing a rule with action to set the field's value. But, I am doing it on the Form Load control, not the text box itself. Does that make a difference? Sorry, I have limited Espanol skills :(

Re: Populate a form's field with a SharePoint list field's text using "query using a data connection" rule

jricorod — Thu, 07 Mar 2013 08:44:34 GMT

Hi AlexK,

I had a similar problem.

You have to do a Query Data Conection to that SP. Then you have to go to properties of the text box and Set Value of the colum in the SPlist. To Set the field you have to put a condition. What field of the list you want? If you don´t put any condition, Infopath automatically Set Value of the first item, and always the first.

Do you understand Spanish? In Spanish I could explain better.

Keep in contact. Regards

Re: Populate a form's field with a SharePoint list field's text using "query using a data connection" rule

AlexK — Wed, 06 Mar 2013 21:56:26 GMT

I thought I had figured it out, but it's still not working. I tried creating a rule and found the option to "set a field's value" on "Form Load", so I set my form's field to be the queried data under the data source dropdown. When I open the form in the browser from the Sharepoint list, nothing shows up. It doesn't show even if I open with InfoPath either. It seems to be partially working because if I pre-populate my form field with any text, and load the form again, that text is not showing either, so the rule seems to be trying to load something into the form, just nothing is showing.

Populate a form's field with a SharePoint list field's text using "query using a data connection" rule

AlexK — Wed, 06 Mar 2013 19:10:43 GMT

I would like to show in a text box on my form the contents of a SharePoint field when the form is opened, kind of like a lookup. I found some brief documentation on this here but it does not tell me how to actually put the contents of the field onto the form for display. Assuming I am querying "field1" from my SP list, I set up my data connection fine and make a rule to "query" the data, but now I don't see any way to use the queried field1 to show on my form. What am I missing?