Re: Pulling Data From Sharepoint List with Infopath 2014

Bre Huston — Tue, 23 Dec 2014 23:44:16 GMT

Hello Ben,

Welcome to the InfoPath community! The scenario you've outlined above is a cascading dropdown that relies on the value of the upc. You've started in the right direction, but just need to make a few edits o your form. I'm attaching an example for your reference. Take a look at the drop down rules. Your logic was almost correct.

Remove the condition from the rule
in the action you will set a fields value, "field2 = price" where UPC(from your main data source) = upc (from your secondary data source)

The reason the action did not work s that there were multiple upc values being compared in the condition, so if one did not match, you rule would not fire. In your action, you have to specify which of the values to use in relation to the referenced upc.

Hope that helps!
Bre

Bre Huston | Project Manager

Qdabra® Software / InfoPathDev.com / FormsQuo / 877.544.2389 main / 425.318.7843 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Pulling Data From Sharepoint List with Infopath 2014

Ben David — Sat, 20 Dec 2014 20:43:23 GMT

Dear InfopathDev Forum,

Hi! It's a pleasure to be here. I'm developing some forms for my workplace and am just starting out with InfoPath. I came across already some questions I am having difficulty finding the solution to.

I have a Sharepoint list with 6 columns currently:
ID upc name cost price

I am working on a basic InfoPath form with the following intention:
The user types in a number in the "upc" field
The "name" "cost" and "price" fields are populated with the information associated with the "upc" on my Sharepoint list.

I've been looking everywhere for a solution that works and nothing is working out. This is what I've done, and from what I've read *should* work:

Started new InfoPath form
Went to the Data tab and added a data connection "From SharePoint List" - the list name is "simpletest" - and selected the fields I'd be using
Added two textbox fields to the form (field1 and field2)
Created a rule on field2

on the condition that "field1" "is equal to" "upc" (selected from the datafields portion of the "simpletest" connection)
to perform an action "set a field's value" "field2" = "price" (selected from the datafields portion of the "simpletest" connection)

From what I can tell, this is correct. But it doesn't work. Does anyone see the holes in my methodology here? It seems pretty straightforward, so I don't know where I'm going wrong.

Thank you,
Ben

Newbie Questions

Re: Pulling Data From Sharepoint List with Infopath 2014

Pulling Data From Sharepoint List with Infopath 2014