Lists
3152 TopicsM365 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.10Views0likes0CommentsNot 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? Thanks13Views0likes0CommentsTwo global navigation bars?
On the top of any page, I have the top navigation (Using Managed Navigation). But there is also another navigation bar directly below this one (which add a link for 'help') on some of the subsites, libraries, lists, etc. I am pulling out my hair trying to figure out where this is coming from and how to get rid of this. Can anyone help me, please?31Views1like1CommentMicrosoft 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. Thanks61Views0likes4CommentsAccessing 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.10Views0likes0CommentsRestricting View/Edit/Create of Sharepoint List items to creator only
Hi Team, I need to build a feedback Power App that can read and write to a Sharepoint Online List held within a Private team ( the HR team for example ). All users need to be able to edit their own records and their managers can update ones assigned to them BUT if they look at the list directly, they are not allowed to see other peoples records. What is the best way to achieve this level of access control..? Can it be done using SharePoint lists or does it need to be managed through Power Apps/Power Automate somehow..?28KViews0likes2CommentsMaking a FAQ using lists need help with json formatting colors
So I was following a tutorial on Youtube on how to make a FAQ list but I cant get the formatting right. There are 4 columns in this list Title, Question, Answer, Show More Basically I have it grouped by title and then grouped by question The problem is the as you can see in the screenshot below the title and question are all the same color I want them to be a different color. I have also attached the JSON I am using in formatting below. But basically I need help figuring out how to make the title in this case documentation different from the questions. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "hideSelection": true, "hideColumnHeader": true, "hideListHeader": true, "groupProps": { "headerFormatter": { "elmType": "div", "attributes": { "class": "sp-row-card" }, "style": { "color": "#333333", "background-color": "#F7F7F7", "flex-grow": "1", "display": "flex", "flex-direction": "row", "box-sizing": "border-box", "padding": "8px 12px", "border-radius": "6px", "align-items": "center", "flex-wrap": "nowrap", "overflow": "hidden", "margin": "4px 6px 6px 4px", "min-width": "max-content", "box-shadow": "0 1px 3px rgba(0,0,0,0.1)" }, "children": [ { "elmType": "img", "style": { "max-width": "28px", "max-height": "28px", "margin-top": "0", "border-radius": "3px", "margin-right": "12px" } }, { "elmType": "div", "children": [ { "elmType": "span", "style": { "padding": "4px 6px", "font-weight": "600", "font-size": "16px", "color": "#B31B24" }, "txtContent": "@group.fieldData.displayValue" } ] }, { "elmType": "div", "style": { "flex-grow": "1" }, "children": [ { "elmType": "div", "style": { "display": "flex", "flex-direction": "column", "justify-content": "center" } } ] } ] } }, "rowFormatter": { "elmType": "div", "attributes": { "class": "sp-row-pwc-bg" }, "style": { "display": "flex", "justify-content": "flex-start", "color": "#222222", "padding": "8px 16px", "border-radius": "6px", "max-width": "920px", "margin": "6px 8px 8px 60px", "background-color": "#FFFFFF", "box-shadow": "0 1px 4px rgba(0,0,0,0.08)", "align-items": "center", "flex-direction": "column" }, "children": [ { "elmType": "div", "style": { "text-align": "left", "font-weight": "600", "font-size": "16px", "color": "#E4002B", "user-select": "none" }, "txtContent": "" }, { "elmType": "div", "style": { "margin-top": "8px", "font-weight": "400", "font-size": "14px", "color": "#5A5A5A", "white-space": "pre-wrap" }, "txtContent": "[$Answer]" }, { "elmType": "button", "customRowAction": { "action": "defaultClick" }, "txtContent": "Show more", "attributes": { "class": "sp-row-button" }, "style": { "display": "=if([$ShowMore] == 'Yes', 'inline-block', 'none')", "margin-top": "10px", "color": "#FFFFFF", "background-color": "#E4002B", "border": "none", "padding": "6px 16px", "border-radius": "4px", "cursor": "pointer", "font-weight": "600", "font-size": "14px", "text-align": "center", "box-shadow": "0 2px 6px rgba(228,0,43,0.3)" } } ] } }19Views0likes0CommentsAdvice on what method of List to implement
Hello. I'm trying to implement a control of water meters readings. At first, I created a list for the equipments and one list for the readings, with a lookup column linking both lists through the equipment column in the first. But then i remembered the delegation limit. I have more than five hundred equipments and the readings must be registered in a daily basis and that data would surpass the delegation limits of five thousand rows in about two weeks. Because of that, I decided to create a list to each equipment, what would result in more than five hundred lists, but would give much more time (13 years) before the delegation limit for each equipment. But to avoid human errors on selecting the equipment, I'm failing on setting a default value for the readings lists and it made me rethink if that is really a clever idea. My question: what method should work best in this case? Or is there a better way to do it I'm not seeing? Thank you in advance!Solved94Views0likes3CommentsTo 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.13Views1like0Comments