microsoft lists
1547 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.1View0likes0CommentsMicrosoft 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.10Views0likes0CommentsSharePoint Template Copying
Hello Community! I am working to copy over a Site Page Template upon a list form request! Users will fill out the name of the item they're looking to create a Notice template for, and then power automate copy's the template and updates the metadata. When I update the metadata, it still shows with the name of the template page I originally copied. The following shows this happening with a template page created by copying 'CarrierNoticeTemplate' The first image shows the template titled "Test Notice", when being selected within the Page Gallery. Second image shows the template titled "Test Notice", within Site Pages. Any help would be very much appreciated.59Views0likes2CommentsAdvice 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.12Views1like0CommentsCopilot Studio - Access SharePoint List
Hi There, for a testing prupose, I want to create an agent with Copilot Studio. I want to access SharePoint List via action="Get items" from SharePoint. I selected/entered in "Inputs" section: Site Address = http:// .... List Name = Employee List Top Count = 5000 Filter Query = Dynamically The list has employee information, around 10 columns, and 150 rows. When I submit such "Who is Jasmin?" or any other similar question such "Who is Jasmin Tailor?" Overall: I am searching about existing employee and not existisng in the list, ... I get always this error message: Error Message: The connector 'SharePoint' returned an HTTP error with code 400. Error Code: ConnectorRequestFailure Conversation Id: 3c0377a0-83c1-412b-9d1a-761f8202203a Time (UTC): 2025-04-15T16:49:08.414Z First time I run this agent with this action, I was asked to connect, which worked fine. However I still get this error message. I am the creator of the agent and I am also the owner of this sharepoint list. Any idea, what am I doing wrong? Or can I somewhere check if this "Get itrems" action or other actions are temporarily not working? THANKS ! Regards, Aykut345Views0likes4CommentsHow to prevent overnight events from appearing in the "All Day" section in Lists calendar view?
Purpose I am trying to create a reservation calendar for an equipment using the calendar view in Microsoft Lists on MS Teams. Each work session lasts from several hours to several tens hours, with most sessions typically around ten to fifteen hours. What I’ve done I created a calendar view using Microsoft Lists via SharePoint and added several events. The calendar is mainly used in weekly view. Issue Events that span overnight or last more than 24 hours are displayed in the "All Day" section at the top of the calendar, rather than as vertical blocks in the main time grid. Since the purpose of this calendar is to manage equipment usage, it is not ideal that actual usage times are shown as "All Day" events and not in the time-based section of the calendar. QuestionIs there a way to adjust the formatting or settings so that all events are displayed in the main time grid, rather than in the "All Day" section? Any advice or suggestions would be greatly appreciated.18Views0likes0CommentsSharePoint Board View: Clicking an a href triggers default click action as well
I’m using SharePoint’s new board view with JSON for custom card formatting. On the card I’ve included a clickable link using `"elmType": "a"`, with an `href` and `"target": "_blank"`. The annoying thing is that if someone clicks on the link, this opens the link in a new tab, but it also triggers the default click action (which opens a form). Is there any way to avoid this from happening? Or is there a way to disable the default click action? Unfortunately `customRowAction` doesn’t support something like `"action": "none"` or `"action": "disabled"`.25Views0likes0CommentsWhy Is SharePoint’s Priority Column Free Text and Not a Choice Field?
While https://bluesite.consulting/en-us/articles/sharepoint-site-template-projecthome-review.html, I noticed something unusual in the work action tracker list—a column setting that seemed out of place. Specifically, the Priority column isn't set up as a typical choice column with selectable options. Instead, the available choices are entered as free text in a single text field (left image) I saw this years ago in the old SharePoint. where options for a choice column are defined within a text field rather than as a standard list of choices (right image). Does anyone know why this might be happening or what could be causing this behavior?Solved77Views0likes3Comments