Mar 01 2024 10:46 AM
I have a PNP filter and PNP search results web parts set up to use a SharePoint list as the source.
After doing a bulk update to the list, the PNP web parts now have discrepancies with a few of the columns in the list. The options highlighted in yellow in the screenshot below are not supposed to be there, and do not show up if I filter the same column in the SharePoint list:
All items in the list needed updated and since at the time, the list had over 5k items, all items were deleted and then added back in by importing data from a CSV file into the SharePoint List. I used Reza Dorrani's solution which can be found here: https://www.youtube.com/watch?v=b3aQf17ptAs
All of the columns in the list are site columns and have been mapped to a refinablestring in the search schema.
I've tried re-indexing the list after importing the CSV data and manually re-adding the items that had the discrepancies but that didn't help. I am completely stumped as to why the PNP no longer matches the SharePoint list.
Mar 04 2024 05:39 AM
Hello @eahbxecrfash3q
it looks like the re-index is not ready yet.
You can also check the incorrect entries with tools to see if the value is still in the index: https://microsoft-search.github.io/pnp-modern-search/using-query-tools-to-verify-issues/
Best, Dave
Mar 07 2024 06:46 AM
SolutionMar 07 2024 06:46 AM
Solution