As in the topic, I need to retrieve data from a lookup sharepoint list column that can have from zero to three selected values.
I want to create a collection from this data so that I can then create a gallery based on it.
SharepointList:
Name | Surname | Substitute |
Name1 | Surname1 | |
Name2 | Surname2 | Surname3 |
Name3 | Surname3 | |
Name4 | Surname4 | Surname1, Surname3 |
Lookup column is relative to the same Sharepoint List.
For now I could not even filter my sharepoint list to show recods with choosed substitute, but I was able to pull out all values from Substitute column into gallery (per record)
What I want to achieve:
Distinct collection of Substitute column - [Surname1, Surname3]
Filtered list of people who choosed their substitute.