I have a large List that has properties which are just look columns to another list:
Large List: Title - string employee - Lookup Qualification - String Attached Document
Employee Table Employee Name (Title) - string phone number - string
I use SharePoint search to search the large list, and it works fine, Unless I update the Employee Name (for example they get married). The Data gets updated, but even after 1 week of waiting the search does not update the results. If I search by the New Employee name , then the search returns 0 results. If I search the old name, it returns all the results.
If I reindex the search it fixes the issue, But I dont want to have to manually force a reindex everytime an update is made.
IS there a way around this? Or can I schdule a full reindex every weekend?
I am on office 365 Sharepoint online.