General

Re: I am attempting to query a Sharepoint list's row based on a drop-down selection on my Main section to populate multiple fields with the associated data

Hilary Stoupa — Wed, 09 Sep 2020 23:43:57 GMT

Perhaps try this one. You want to get the "brand" from the same data source as the initial dropdown is using for its data - so that's the main change I made. You need to right click the linked file and select save as to save the file locally. Then you can right click the saved file and select Design to open in design mode.

Re: I am attempting to query a Sharepoint list's row based on a drop-down selection on my Main section to populate multiple fields with the associated data

infopathnoobie2020 — Wed, 09 Sep 2020 22:11:34 GMT

Thanks for the reply! The "brand" drop-down is sourced from a SharePoint list I created that is 1 column and just lists each brand so that way the list can easily be added to for new brands that may be developed.

I also did not realize I was able to attach my form. I have attached it to this message :)

Thanks again for your response, this has been confusing me

Re: I am attempting to query a Sharepoint list's row based on a drop-down selection on my Main section to populate multiple fields with the associated data

Hilary Stoupa — Wed, 09 Sep 2020 19:51:59 GMT

So - your filter looks right. But what is providing the values for the "brand" drop down?

Re: I am attempting to query a Sharepoint list's row based on a drop-down selection on my Main section to populate multiple fields with the associated data

Hilary Stoupa — Wed, 09 Sep 2020 19:08:45 GMT

What would help most would be a copy of the form. :)

Re: I am attempting to query a Sharepoint list's row based on a drop-down selection on my Main section to populate multiple fields with the associated data

infopathnoobie2020 — Wed, 09 Sep 2020 18:36:51 GMT

Attached to this message is the rules screenshot

Re: I am attempting to query a Sharepoint list's row based on a drop-down selection on my Main section to populate multiple fields with the associated data

infopathnoobie2020 — Wed, 09 Sep 2020 18:36:18 GMT

Hey! And thanks for your response. I gave this a shot, but I think I'm getting confused on the rules filter data part. I just attached a screenshot with some text in red to describe the functionality. I will also reply with another screen that shows the rules.

Re: I am attempting to query a Sharepoint list's row based on a drop-down selection on my Main section to populate multiple fields with the associated data

Hilary Stoupa — Wed, 09 Sep 2020 15:58:03 GMT

Hi! So - you need to add a receive data connection to the Campaign Master List to your form. You will likely want to sort it by campaign name - that is one of the options on the screen where you select the list fields in the data connection wizard. On your dropdown field in your form, you'll add rules to set other field's values. When you select the value, it will be from your secondary Campaign Master List data connection, and you should see a "Filter data" button - click on that. You'll want to add a filter that the Campaign Name in the secondary data source is equal to the field in the main data source bound to the dropdown. It sounds so much harder than it is. :) Feel free to attach your form under the Options tab if you need a hand - you'll need to at least create the secondary data connection beforehand.

I am attempting to query a Sharepoint list's row based on a drop-down selection on my Main section to populate multiple fields with the associated data

infopathnoobie2020 — Tue, 08 Sep 2020 17:00:57 GMT

Hello all - this is my first post and I am new to Infopath (which is a requirement of this task I am trying to accomplish). I am running into trouble understanding how to query a row's values stored in a SharePoint list to populate the respective fields on a Infopath webform.

Here is an overview of the intended functionality.

I have a SharePoint list titled, "Campaign Master List" that has the following columns:

campaignID
campaignName
agencyPartner
targetLaunchDate
brand
franchise

There is existing campaign data in this table currently.

I have a drop-down menu on the Main form that uses the "Campaign Master List", campaignName values as the drop-down menus being sourced from the SharePoint list.

If a user selects an existing campaign from the drop-down menu, I would like for the respective row values for campaignID, agencyPartner, targetLaunchDate, brand and franchise to be populated based on the selected Campaign Name in the drop-down menu.

I have Googled this and read overviews about creating secondary data sources to store the queried values from, but I'm having trouble understanding how this would actually work with how unfamiliar I am with Infopath.

Can anyone help me think through this?

Thanks in advance for anyone who responds!

Thank you, :)