0

I have a site column of type Choice named "Project" with Multiple values selection enabled.

This choice site column is used in two lists - ListA and List B

ListA is a lookup in List B. So when I select lookup value of List A in List B, selected Columns from List A should be auto populated in List B. I was able to lookup most of the fields but for field "Project" which is multi select choice, it selects only first value.

For e.g. In List A, For Item1, I have selected Choice1,Choice2,Choice3 in "Project", when I lookup Item1 in ListB, Only "Choice1" is selected.

I am using Infopath 2013, SharePoint Online.

1

I have reproduced your issue, only the first choice value will be selected.

List A:

enter image description here

List B form:

enter image description here

InfoPath rule:

enter image description here

It occurs because we can only get the first value from ":Value".

Per my research, it is difficult to set multiple values to multiple-selection list box in InfoPath form.

As a workaround, an idea, you can get the lookup value from the form on the page. Then using CSOM/JSOM to find the item from List A based on the lookup value and get Project data from the List A item. If specific choice is contained in the List A item, use JavaScript to check the checkbox on the page ( e.g. $("#checkboxId").attr('checked', true);).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.