Use Lookup control from List A to access the Person Field value from List B

Forms SharePoint Online
1

Hi there,

I created a list B containing a Person Field to access the co-workers in the company, I want to use the Lookup control from List A to access the Person Field in List B.

However, I can't seem to achieve that in SharePoint List, as I don't see the Person Field ( see image below) being shown when creating the Lookup Control in List A to access data in List B.

Please refer below as my List B/ NCR Recipients

undefined
When creating lookup control in List A shown below, I don't see the column "recipients" being shown.

undefined

Please advise,

2

Hello @jyou,

SharePoint doesn't support lookup to Person or Group field. But you can select fields that also need to be loaded, including Person field, in the designer with Expand and Extra Fields properties.

Specify the internal name of the field in Expand property, and to get a user display name add /Title to the internal name in the Extra Fields property.
image

Then, you can get the user name of the Person or Group column using the code:

fd.field('LookupFieldName').$on('change', function(value){
    alert(value.Recipients.Title);
});

You can find more information about properties in the documentation here:
https://plumsail.com/docs/forms-sp/designer/fields-sp.html#lookup

And in the video:

3

@mnikitina Thanks a lot for your reply :slight_smile:

1 Like