Forum Discussion
Suwat_A
Feb 12, 2024Copper Contributor
SharePoint Online Search Issue for Document Library
Hi, I found many issues about SharePoint Search as below. Can anyone help to suggest what is the root cause and solution please. Thank you very much. Issues 1. Search result is not found some...
- Jul 28, 2022
Unless I'm mistaken, to get exactly what you're asking for, you're going to need Power Query or a tool like that; sadly, I'm not experienced with that.
However, I am experienced with databases and database design, and I'm questioning why you have three separate sheets for the subordinate data here. One could suffice, I believe, recognizing that column B in those sheets is redundant with the name affixed to the tab. Just let that column do the differentiating that the tab is doing.
(An aside: we often create separate pages because that's how we'd do it on paper, but the reality is that such a layout actually (often) interferes with Excel's marvelous abilities to parse such distinct entities in a single database or table, just using a column to differentiate what was originally presented as separate tabs.)
When you do that--as I've done in the demo attached--then a simple FILTER function, nested in TRANSPOSE, gives you the desired result, albeit in three separate columns, G, H and I.
DaveMehr365
Feb 15, 2024MVP
Hello Suwat_A
currently Microsoft have a known issue:
You can also try to push the crawler and reindex the library: https://learn.microsoft.com/en-us/sharepoint/crawl-site-content?WT.mc_id=DX-MVP-5004845
Best, Dave