I was wondering if anyone had experience filtering a SharePoint List using a People-Picker value. Here's where I am at:
1. I get the items from a SharePoint List.
2. I get the values from the "Owners" People-Picker, using a "Select", which places the values into an array.
3. I do a UNION on the array, to get distinct people.
4. I then loop through the distinct array and:
a) I want to get all of the records from the SharePoint List, that the Owner is associated with. This is where I'm struggling. I can't seem to figure out how to get the records.
I'm thinking that it's because in the SP List, the "Owner" field is an array within the record array. I have tried converting the record from the distinct array to an XML string and then as I loop through each of the records in SharePoint, doing a SELECT on the "Owners" field and converting it to XML, doing a Condition and looking to see if the "Owners" XML contains the value from the distinct value XML. But I can't seem to get it to work.
Does anyone have any experience doing this?
Any help would be appreciated.