Skip to main content

Hi,

 

I have looked all through the community and cannot find how to do this, I am sure there must be a way.

I am looking up data from a SharePoint list using the ID, easy, the user enters the ID and then the from pulls the data. 

Issue is one of my Felds in this instance is a multi person column. The data field only shows the first entry.

I want to know if there is a way that a list can be created from this and shown on the form. Ideally I would like it to create a table where I could check off who has attended the meeting but lets start off small in the beginning.

If any one can help will be really happy.

 

Cheers

Jamo

@Jamo 

I think the challenge here is that you have a 1 to many relationship between the item in the list and the 1 or more users in the person column that allows multiple selections.

I just did a quick test on a form.

I created a data source against the list in the automate settings. This just has title and staff (multi person) columns.

On the nintex start form I added a data lookup control to this data source.

It is showing the title column for Label and value.

I created an external data variable in the form to the same data source but set the condition to filter based on title from the data lookup control.

I added a label to the form and set it to display the external data / first record / staff (email)

This displays a comma seperated string of emails from the staff field.

It’s text though not a collection variable so will need to dealt with differently from a collection.

 

The other option is to normalise this into a second sharepoint list, where the second list has only 1 item per staff person. So you would create a 1:many relationship between the first list and the second list.

 

 

 


Hi @Jamo 
Did this response help answer your question?


Reply