Forum Discussion
Advice on multi-lookup column list threshold workaround
Hello, Situation: We are tagging most our data in Sharepoint with project numbers via a multi-lookup column. Now some lists start to reach the threshold limit, and you can't index multi-lookup ...
Hello,
Did you ever figured out a solution for this problem of yours. I'm having the same issue and not sure how can I use PnP JS to get around this. Please let me know if you found any possible solution.
Thanks,
Suhas
Did you ever figured out a solution for this problem of yours. I'm having the same issue and not sure how can I use PnP JS to get around this. Please let me know if you found any possible solution.
Thanks,
Suhas
Hi,
no there is no real solution. What I'm doing is using pnp-powershell scripts to aggregate and sum the data on a local server and write it back into a sepprate sp list.
Also we are using plumsail forms, this replaces the standard forms. There i can run javascript and recreate certain functionalities with pnp-js.
In the long term we are planing to move the data to a SQL Server and use PowerBI to visualize it.
no there is no real solution. What I'm doing is using pnp-powershell scripts to aggregate and sum the data on a local server and write it back into a sepprate sp list.
Also we are using plumsail forms, this replaces the standard forms. There i can run javascript and recreate certain functionalities with pnp-js.
In the long term we are planing to move the data to a SQL Server and use PowerBI to visualize it.