Forum Discussion
Filtering on Calculated Columns not working in SharePoint List
I have a table where i created a calculated column for the Fiscal Year/Quarter = Example: FY2023/Q3. I used to be able to filter on this field but now when i filter on it, it provides 0 (ZERO) resu...
After several weeks of troubleshooting and escalating with Microsoft we have found that the issue is with Nucelus Sync.
I have been told by the support engineer on my case that you will need to add the following registry key to each device to disable nucleus sync until Microsoft implement a permanent fix:
[HKLM\SOFTWARE\Policies\Microsoft\OneDrive] "DisableNucleusSync" = "dword:1"
(https://learn.microsoft.com/en-us/SharePoint/lists-sync-policies)
I have been told by the support engineer on my case that you will need to add the following registry key to each device to disable nucleus sync until Microsoft implement a permanent fix:
[HKLM\SOFTWARE\Policies\Microsoft\OneDrive] "DisableNucleusSync" = "dword:1"
(https://learn.microsoft.com/en-us/SharePoint/lists-sync-policies)
Thanks for that tip. I can confirm after testing today, that it does fix the issue for me as well.
https://learn.microsoft.com/en-us/sharepoint/lists-sync-policies
According to the MS Page, its a policy that disables Syncing of Microsoft Lists in the One Drive client.
Prevent Lists sync from running on the device
By default, Lists sync is turned on for users of Microsoft Lists. If you enable this policy, Lists sync will be blocked from running on the device.
Prevent Lists sync from running on the device:
[HKLM\SOFTWARE\Policies\Microsoft\OneDrive] "DisableNucleusSync" = "dword:1"
Re-enable Lists sync on the device:
[HKLM\SOFTWARE\Policies\Microsoft\OneDrive] "DisableNucleusSync" = "dword:0"
https://learn.microsoft.com/en-us/sharepoint/lists-sync-policies
According to the MS Page, its a policy that disables Syncing of Microsoft Lists in the One Drive client.
Prevent Lists sync from running on the device
By default, Lists sync is turned on for users of Microsoft Lists. If you enable this policy, Lists sync will be blocked from running on the device.
Prevent Lists sync from running on the device:
[HKLM\SOFTWARE\Policies\Microsoft\OneDrive] "DisableNucleusSync" = "dword:1"
Re-enable Lists sync on the device:
[HKLM\SOFTWARE\Policies\Microsoft\OneDrive] "DisableNucleusSync" = "dword:0"
Setting the site to "No" for "Offline Client Availability" also appears to fix this without having to edit the registry (or if you are blocked from that).
Site Settings-->Search and offline availability
Offline Client Availability - set this to "No"
