Related item - Form Field Multiple Lookup

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
User avatar
TonyDuke
Posts: 71
Joined: Mon Sep 11, 2017

17 Oct 2017

Good Morning,

I have a display form for a contact with a related items viewer to show all related addresses.
In the Contact Item there is a multiple Select Lookup Column for Related Addresses and I have selected an address in there (see Capture 3)
Capture 3.PNG
Capture 3.PNG (1.85 KiB) Viewed 1419 times
However despite setting this up in the Data Source Editor as the Form Field (see Capture 1)
Capture 1.PNG
Capture 1.PNG (15.04 KiB) Viewed 1419 times
, the related items viewer on the display form displays no items (see Capture 2).
Capture 2.PNG
Capture 2.PNG (10.34 KiB) Viewed 1419 times
What am I doing wrong?

Thanks

User avatar
Nikita Kurguzov
Posts: 889
Joined: Mon Jul 03, 2017

17 Oct 2017

Hello, Tony!
First of all, this filtering is not dynamic and is only applied when you open the form, so if you change fields later, it will not change the Related Items control. The fields also must match if you want them to filter correctly like this. Since you are using Multiple Lookup, it will likely not work. If I understand it right, you want Related Items to show items that contain at least one from selected items in the Lookup, right?

You can experiment with dynamic filtering, it uses hashes to filter content of Related Items. Not very easy to use, but gives much more control over what is displayed in Related Items at any given point. With the right JavaScript, you can implement filtering by each selected item in the Multiple Lookup field.

But you can always just change to Single Lookup and it should work just fine, as long as you don't need filtering to be dynamic, otherwise use the article I've linked. It's basic functionality is not too hard to implement, but some advanced situations can be quite challenging.
Cheers

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 4 guests