Not able to edit items in list due to too many versions.
I have a sharepoint list and some of the items cannot be edited because of the number of versions. I have the versioning set at 50, but some of these uneditable items somehow got up to over 10,000. Any ideas on how to resolve or how they got so high? Thanks
Microsoft Lists
Just been looking into Lists in SharePoint and find its great how you can make it look and function great, very pleasing to use. I like how you can have version history on items too and also if someone did delete the list you can restore it. But what if you want to restore if from backup, what if someone deletes a column. I use AvePoint backup and it doesn't show the list as a list when i restore. It just shows a spreadsheet. I cannot then paste the spreadsheet into an empty list because some fields like People and multiple choice do not format correctly from the spreadsheet back into a list. Is it just AvePoint or are there solutions to backup Microsoft Lists and restore them as a list. I cannot see going forward with lists if you cannot restore from backup. Thanks
Classic SharePoint list view redirecting to home page
Hello! I have an old Classic SharePoint site that I need to create a new view in a list for. I have created this view but whenever I go to open that view it redirects me to the homepage. This site was build by someone else and I believe this is by design to stop users from using admin only views....but how do I stop this for my new view? I need some users to be able to use it. When I create a personal view it does not do this redirect. Any ideas how I can stop it happening on a public view? Or will I need each of my users who need a new view to set up personal views of their own?How to grant access to SharePoint subsite with no Owners
Hello! Can someone advise how I can add a user to a SharePoint site with no Owners/Members or Admins? It is a Classic SharePoint subsite so I cannot modify any settings using the SharePoint Admin Centre so I need to find a script or a method of some sort to allow me to add a user account to the site to then be able to review it/decommission it etc.? TIA!
Microsoft 365 Purview Logs not showing Export List Events
We recently conducted an audit on our system - as we are part of a regulated industry - and had to clarify exactly which user events are captured in the Unified Audit Log. We did the usual confirmations and provided evidence of events where users add, update, delete items in SharePoint Lists and Libraries, however, we were asked specifically if events for exporting List Items to CSV or Excel were captured in the Log. We performed the usual test and waited for the events to appear in Purview, but to our suprise, there was nothing in the Log to indicate a user exporting to CSV or Excel. Can anyone confirm whether Export to CSV or Excel from a SharePoint List should be captured and is reportable in the Audit Log? This seems to be a massive oversight if these events are not auditable?
Edit a SP list column unable to enter data
Hi, I'm trying to edit some data in a column within my SP list. The column type is Choice. The issue is the is not a 'Choice' field. When created it was going to be a Choice field but when I built the Powerapp that is feeding data to this column is has become a lookup field. So in my app the user selects Division and then the wards in the division are available for selection in the Ward field. Sort(Distinct) formula used looking at another SP list SharePoint PowerApp This as caused an issue as I need to edit one some values in the Division and Ward columns in SP. Can I amend the column values to Single line of text, without losing any of the data?? If not is there away I can amend, edit the data??M365 AuditLogs do not show a CascadeDelete operation
I have a few lists in SPO that are connected (call them Parent, Child1, Child2 for example) via lookup columns. I am trying to implement a delete item action in the parent list that would delete the related items in Child1, Child2 etc., that are pointing to this. The Cascade Delete operation itself works but when I am reviewing the AuditLogs for the operation, I am only seeing a ListItemViewed operation against the item in the Parent List that I am deleting. In the browser trace, I can see us making a POST to /_api/web/lists(@a1)/GetItemById(@a2)/recycle?@a1={LISTID}&@a2={ITEMID} for this action.Accessing Page Properties as filter for a List (List Web Part or Embed Web Part, or other)
Hello... I've unsuccessfully scoured the web for an answer to this question, so I apologize if the answer is out there and I just can't get this to work. I have found a number of potential solutions that didn't seem to pan out, so I figured I'd start at the top and see if what I am is possible. Some "simplified" background (capitalized and quoted words refer to Sharepoint content entities) I have a standard set of management tools in the form of "Lists"; Action Items, Risk Management, Deliverables for example. These "Lists" contain the data for all projects in the organization. Each project has its own Sharepoint "Page" on the organization Sharepoint site. Should note these are "Teams" Site/Pages. Objective is to have a template page that can be copied when a new Project is started and limit the amount of manual configuration. Each data "List" has a common key - Project. In each list, the Project is a "Lookup" field that gets its value from a separate Project "List". I didn't want to use a "Choice" field since multiple "Lists" draw from the same set of Projects and thus limiting duplicative adding of projects when a new Project starts. What I want to do is include each "List" on a Project specific "Page" and since the lists contain data for all Projects I want to filter the list based on the Project field in the list. If I add the "List" as a "List Web Part", the only filtering capability is "Dynamic Filtering" which connects a filter field to something selected in another library or list on the page. With the "List Web Part" it seems the only solution is to have a "List View" preconfigured in the "List" specific for each Project and then the "View" can be selected in the "List Web Part" settings. This solution, although it works, is not ideal since for each new program we would have to create a new "View" in each "List" for the new Project and, after copying the template "Page" edit the "View" field of every list on the page. What I would like to do is key the filtering of the "Lists" based on the active Project "Page". I have added a Project field to the "Page Properties" and set the field to the Project name that is in the Project list to potentially use as the filter key value in filtering the "Lists". But I can't figure out how to make use of the "Page Property" in any of the web parts, whether trying to leverage json in some circumstances, or other potential solutions. I have tried various things using the "List" view formatting. The "View" filtering capability doesn't let you filter based on a "Lookup" field, but even if I did, I would still have to figure out how to reference the "Page" property that identifies the Project. I think the closest I have come is trying to use the "</> Embed Web Part". I can add this web part and set the website address to "https://....../Lists/AIList/AllItems.aspx?FilterField1=Project&FilterValue1=ProjectA" and it will populate the web part with the list filtered to only show the items associated with ProjectA. But what I want is to set the FilterValue1 to the Project "Page Property". I have seen references to page properties in various posts using @{Page.Project} (for example) or [$Page.Project] or perhaps other forms for various purposes, none of which have worked either in this "Embed Web Part" or attempts I have made in other potential solutions using json to try to control what is displayed. Sorry for the long post, but if anyone knows a way to achieve the desired effect it would be very much appreciated.
