Forum Discussion
Discrepancy with PNP web parts and SharePoint List
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.
- Hi David, thanks for your response. I checked the entries with the Query Tool but they did match. However, the issue was resolved after I re-created the SharePoint List and re-added the PNP web parts.
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
- eahbxecrfash3qBrass ContributorHi David, thanks for your response. I checked the entries with the Query Tool but they did match. However, the issue was resolved after I re-created the SharePoint List and re-added the PNP web parts.