General

Re: Retrieve Multiple Selection values from SharePoint list to Infopath Mulitple selection listbox

tony.luu1 — Mon, 26 Oct 2020 21:02:10 GMT

Great thank you Hilary, I guess I'll have to put some thought into it and see what direction the clients want to go. Thanks again!

Re: Retrieve Multiple Selection values from SharePoint list to Infopath Mulitple selection listbox

Hilary Stoupa — Wed, 21 Oct 2020 16:10:05 GMT

This depends on what you will be filtering on. So - if you are going to use equivalence, you can not query on load, and query on the change of the field that you are filtering with. Here's a simple example: You have a list with data that has a "State" column, and the values are WA, OR, ID, CA, etc. In your form, there is a field where the user selects a state. On that field, you'd add a rule to set the query field for your list secondary data source to the current field value (i.e., WA, ID, OR, CA, etc.) and then you'd run the list query. All the data returned from the list will match on State. If you don't have equivalence for your filtering - you need something more complex like State equals OR or State equals WA, then you simply have to query for all the data and use conditional formatting to determine what to display. If you are using on-prem SharePoint, you may be able to use the OData services for this as well, but SharePoint Online doesn't let us query SharePoint web services from InfoPath out of the box.

Re: Retrieve Multiple Selection values from SharePoint list to Infopath Mulitple selection listbox

tony.luu1 — Wed, 21 Oct 2020 15:18:51 GMT

Hi Hilary, Thank you for your response! What would be the best option to retrieve the data so that its filterable after when its pulled into infopath? Thanks

Re: Retrieve Multiple Selection values from SharePoint list to Infopath Mulitple selection listbox

Hilary Stoupa — Tue, 20 Oct 2020 23:31:35 GMT

Your screenshot doesn't show, unfortunately, but based on your description, this is not possible without code or third party tools. The issue is that we can't add repeating items (groups, fields) with rules in InfoPath. So we don't have any way to copy repeating data from one data source to another out of the box.

Retrieve Multiple Selection values from SharePoint list to Infopath Mulitple selection listbox

tony.luu1 — Tue, 20 Oct 2020 23:23:10 GMT

Hi Everyone,

Hoping someone can help me! I have a SharePoint list (List A) with multiple selection field, and an InfoPath 2013 form. Trying to retrieve the multiple selection values from List A, into a multiple selection listbox in InfoPath 2013. is this possible? All its doing right now is pulling all the selected values, but all into one line.