I have a sharepoint list of about 40K rows and I'm trying figure out how to get the team members title information from another sharepoint list . However, it's only returning the same 100 entries everytime I run it. I've changed the top count to 5000 and turned on pagination. I'm using filter query where the employee ID's match in each list and where the role/title is empty.
User | Count |
---|---|
89 | |
40 | |
21 | |
20 | |
16 |
User | Count |
---|---|
137 | |
56 | |
46 | |
36 | |
26 |