I have a collection of items and I need to update each item based on a lookup in two sharepoint lists.
Like this:
collection records
ID NewValue
1 BLANK
2 BLANK
3 BLANK
I need to look up each id in a sharepoint list, get a value from the first list, look up that value in another list to return my NewValue and update the NewValue field in this collection based on what is returned.
For each record in my collection
- get value 1 from sharepoint list
- use value 1 to find another value in another sharepoint list
- return second value to NewValue field in collection
I am stumped as to the best way to approach this. TX
