MultiSelection option to lookup multiple values on from a lookup item on Infopath 2013

Rob2021 1

I have a multi selection field and I'm only able to pull one serial number at a time. When selecting one asset tag, I need to be able to select many asset tag and bring up many serial number in a concat manager. My Calculation

substring-after(eval(eval(Serial_x0020__x0023_[ID = concat(Camera_x0020_Assets, ";")], 'concat(., ";")'), ".."), ";") hasn't worked.

JoyZ 18,046 Reputation points

2021-07-05T06:34:02.067+00:00

@Rob2021 ,

Does this form connect to SharePoint list?

if it is true, please provide referred column types and steps in your info path form as detailed as possible.
Rob2021 1 Reputation point

2021-07-06T14:07:55.793+00:00

Yes, The form connects to a SharePoint list. The field types are a asset tag multiselect field that links to a lookup data source on SharePoint. Imported values are ID and Asset Tag,
The second field is an infopath calculated field that has the calculation above. The setup is a multi-select field where the asset tags are select and based on the asset tags selected the serial numbers will populate based on the asset tags selected. I'm able to get one serial number when one asset tag is selected. But I want to bring up several serial numbers based on the asset tag selected.
JoyZ 18,046 Reputation points

2021-07-08T06:46:28.813+00:00

@Rob2021 ,

Form your description, I customize the list form, however,how do you use the lookup data source from SharePoint in Multiple-Selection list box?

Per my test I use the single line of text field type from list:

In addition,what's the relationship between asset tag and serial number? Please feel free to reply.
Rob2021 1 Reputation point

2021-07-08T17:33:13.473+00:00

The asset tags is a separate list, called the asset list. It contains all the camera assets. On the main list where the infopath is created, there is a data connection for the camera assets. There is two data connection. One is for the asset tags and the other is for the asset items.
JoyZ 18,046 Reputation points

2021-07-09T09:08:00.693+00:00

@Rob2021 ,

How do you get one serial number when one asset tag is selected?

If you provide as many information or steps as possible，I could test it for you.
Rob2021 1 Reputation point

2021-07-12T16:45:25.393+00:00

The setup is as such. One main list, Then a second list with a look up column for the asset items that include, Asset tag, Serial number, model number and such. Then on infopath, create a form on the main list. Then add the lookup column as a multi-selection type to only show the asset tag, Make sure to have two data sources for the lookup. One for the Asset Tags and one for the Items. So Data source with ID and Tag and the other named. Asset Items that will import serial numbers and models and such. I'm able to display one serial number at time, Based on the asset tag selected, But I need to be able to have to display more than one serial number if I choose more than one asset tag.
Rob2021 1 Reputation point

2021-07-12T16:51:08.35+00:00

The calculation is entered on a calculated field.
JoyZ 18,046 Reputation points

2021-07-14T09:42:46.267+00:00

@Rob2021 ,

Thank you for your information.

Per my test I have the same result with you, currently there is no such way to meet your requirement:
Rob2021 1 Reputation point

2021-07-14T12:22:06.983+00:00

I manage to display the serial number with this formula substring-after(eval(eval(Serial_x0020_x0023[ID = concat(Camera_x0020_Assets, ";")], 'concat(., ";")'), ".."), ";") but I was not able to define the true or false statement on the filter. In other words if Tag number is true display the serial number associated with that Asset tag number.