microsoft lists
1571 TopicsSharePoint List Web Part - major caching issues
Hi All, I've spent a lot of time building a List based company calendar in our SharePoint Intranet Portal, and the calendar itself is working great, however I'm having no end of headaches with the List Web Part. (not just for this calendar, but all list web parts for that matter) The calendar has a Start and End field - both are Date and Time fields. A custom view is created for use with the List Web Part to embed an "upcoming week" view, this is based on a filter which checks both Start and End dates to see whether an event exists within or spans the date range from today to 7 days in the future, so it is a rolling 7 day window. This is based on a number of filter criteria which include [Today] and [Today]+6. The view also has a sort criteria to sort based on the Start (Date/Time) field. This all works fine when previewing the view within the list itself - at midnight the results update to include events from the day that is now 7 days in the future which were previously excluded. So the view itself is working fine. However the same view in a List Web part on another page suffers from a ridiculous amount of browser side (?) caching, to the point that it is basically broken and unusable. When I open the page the next day in a browser (even if the browser was closed) one of three things happens, somewhat at random: The events 7 days in the future (which just came into filter scope today) just don't appear until a forced page reload is done. The events 7 days in the future do appear but they are sorted incorrectly, appearing at the TOP when the date sort order should show them at the BOTTOM. Sometimes 2 happens but the event is shown with the Start and End Date/Time fields empty - so not only is it at the wrong end of the list it doesn't even show a date at all until the page is refreshed. Here is a picture showing the sort order being incorrect as in case 2: When these various problems happen a full CTRL-F5 browser refresh always updates the list to be complete, up to date and sorted correctly, however, if after that you click away from the page and follow a link to return to it OR press a regular F5 refresh it goes back to being incorrect! It takes many page reloads or a lot of time to pass (hours) before it finally settles down and gives the correct results every time. Then the next day the same caching problems happen again. If you go to a new browser or PC the same problems happen again, suggesting this is browser side caching not something at the servers. While the actual content of the list items update in real-time if you edit the list content in another page (which is pretty cool) the "result set" of list items (which items should or should not be seen) is heavily cached, and the sorting is unreliable. Has anyone else found a solution to this ? I have already done things like disabling offline mode for the list, (this only seems to affect caching of the actual data in the list items, not caching of filter results) etc and I cannot find a solution. The only thing I know which would probably work, as I have had to use this approach on another list is to extend the date range of the filter criteria for the view further into the future, then filter out the extra days using json code in "format view - however AFAIK you can only selectively hide rows like this if you use a custom rowFormatter, which means you have to fully re-implement the standard view including hard coding all the columns you want and it still won't look quite the same. This is a lot of work and maintenance overhead in the future to work around a caching problem that shouldn't exist in the first place. Any thoughts appreciated as a lot of time and effort has gone into building an entire calendar system around a SharePoint List, only to find that the list web part just doesn't work properly.57Views0likes0CommentsClassic SharePoint features appearing on a Modern Site
I have a modern SharePoint site, with a modern list that has never been associated with classic SharePoint features. But today, two users have experienced intermittent instances of the list appearing in the classic interface. They have not accessed this site before now so I do not believe there should be a cache issue. Does anyone know why this is happening and how it's possible when this site has no association with Classic features? They are using the same browser, same permissions across the site but sometimes the list opens in Classic mode, sometimes it opens in Modern. It also is happening in incognito mode. They are unable to use the site while in Classic Interface at all - the people pickers deny them access ("Error: Sorry, you do not have permission to query for users" and they cannot edit anything because of this error.46Views0likes0CommentsSharePoint Rule Send an Email created by Former EE fail
SP Rules created by a former employee are no longer sent. The Rule was created to email other current users when a field was modified. The Rule was not set to email the former ee, but other users. The only thing that changed is the person who created the rule is no longer with our company. Once the Rule was duplicated by a current user it started working again. Rules are sent via <email address removed for privacy reasons> so why should it matter who created the rule? I see this becoming a large problem as SharePoint Alerts retire and users are now using Rules. For business critical Rules, we've used a Service Account to create the rules to prevent failure in the future. I can certainly understand rules that are created to go to former ee to no longer work since their account is no longer active, but if it's set up to go to other users that are still active, it should remain active and not fail regardless of the status of the created by.12Views0likes1CommentSharePoint Template Gallery
Hey everyone, I'm running into an issue with the new SharePoint site page template gallery. Some of my templates are showing up consistently, while others appear intermittently — even though all the metadata is identical across them. I've been troubleshooting but can't pinpoint what's causing the inconsistency. For context: I have over 100 templates in the gallery. A template I just created is displaying fine, but one I made last week isn't showing up at all, so I don't think it's a template count issue. Any insights would be really appreciated!20Views0likes0CommentsSharePoint List button not working!
Hi all, I have a Property Key Check In/Out list and trying to include a button to auto populate the fields. Using the JSON below, but it isn't working. I've isolated the Status field and that works, but the Person and Date & Time keeps erroring. I checked and double-checked the column settings and the JSON is using the correct Internal names, and the columns are correctly set up to one person only and date and time, and not required. Copilot (you'll be surprised) is absolutely no help. I also tried replacing "null" with '' but still not working. Here's the JSON; { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "style": { "padding": "6px 12px", "border-radius": "6px", "border": "1px solid", "cursor": "pointer", "font-weight": 600, "background-color": "=if([$Status] == 'IN', '#107c10', '#d83b01')", "border-color": "=if([$Status] == 'IN', '#0b6a0b', '#be3700')", "color": "white" }, "attributes": { "title": "=if([$Status] == 'IN', 'Check this key OUT', 'Check this key IN')", "aria-label": "=if([$Status] == 'IN', 'Check this key OUT', 'Check this key IN')" }, "txtContent": "=if([$Status] == 'IN', 'Check Out', 'Check In')", "customRowAction": { "action": "setValue", "actionInput": { "Status": "=if([$Status] == 'IN', 'OUT', 'IN')", "CheckedOutByColleague": "=if([$Status] == 'IN', me, null)", "WhenCheckedOut": "=if([$Status] == 'IN', @now, null)" } } }95Views1like2CommentsMS List suddenly not displaying (or saving) multiple selections from column
Hi. Wondering if anyone has any insight into the following problem. Hopefully I will explain this clearly. I created a List around a year ago which uses a lookup column to pull names from a separate List of employees. The target column "Employees" is set to allow multiple selections, and at the time I created the List, if you selected two, or three, or however many names in this column, the resulting List item would show all of these names. Today it was brought to my attention that for some reason, only the first employee selected shows up in the List now. I've tested and verified this-- you can still select multiple names, but only the first one appears in the List item once saved. Changing the view-- table, grid, calendar, Gallery, etc. has no apparent effect. I don't know why or even when this stopped working-- could have been days or weeks ago but was just noticed. Also, not sure whether this is simply a display problem or if the new List items are now actually only saving the first of multiple entries (I suspect it's the latter but hope I'm wrong). For what it's worth, I confirmed that the column is still configured to allow multiple selections. If anyone has any insight on this problem or troubleshooting suggestions, I'd be grateful. Thanks.Solved186Views0likes6CommentsQuick steps disappear from SharePoint list
I have 4 quick steps set up for my sharepoint list. Each one executes a flow. Twice now they have disappeared. I don't see them when I go to Automate or when I go to manage quick steps. Refreshing the page didn't help. The only way I could get them back was to add a new quick step, save it. Refresh the page and go back into manage quick steps and they were all there again.53Views1like1CommentPnP Search Results Handlebars template saves but does not reflect on UI
Hi everyone, I am working with the PnP Search Results web part in SharePoint Online and facing an issue where a custom Handlebars result template saves successfully but does not reflect on the UI. I created a table-style Handlebars template with columns Document, Region, Country, Language, Status and Validation Date, one row per document. Documents are returned correctly and filters based on the same refinable properties work as expected. Debug output using JSONstringify(item) confirms that all refinable values are present. The same if-condition logic using item.RefinableStringXX works in a list-style layout, but in a table layout the template saves without errors and either does not reflect on the UI or renders rows with empty metadata columns. Inline bindings do not render unless wrapped in if blocks and even after fixing this the UI sometimes continues to show the previous layout. Managed property mappings, selected properties, indexing and library reindexing have already been verified. Has anyone experienced this behavior with PnP Search Results templates or knows if this is related to caching, result types overriding templates or a known limitation with table-style Handlebars layouts?86Views0likes1CommentTo hide the file preview section in a SharePoint Document library gallery card with JSON
Hello All, I have a SharePoint document library and I created a gallery view for it. I displayed several columns/metadata on the gallery view. I want to disable/hide the file preview section in this card. I believe this can easily be done by changing some code in JSON at the Format view Advanced. However, I don't know how to do it. I hope there is someone, in this form, could be able to help me. Thanks in advanced.71Views1like1Comment