lists
3197 TopicsSharepoint List not importing Excel Headers
I noticed lately that SharePoint is not importing the Excel table header names as column/internal name in SharePoint List. It was working before and I know it because I can check them in the List settings. The new list just wasn't the case. To illustrate, I'm going to use the following examples. Created table in excel (Excel O365) (format as table). I have columns, say, "Name, Address, Telephone". Create new SharePoint List by importing Excel. The internal field names created for each of the columns above are 'field_1, field_2, field_3'. Previously, the internal field names would import the header names as well. Tested a bunch of times with different column names (no spaces ,etc.), different data set and the results were all the same. They all carry the internal name 'field_1, field_2, field_3, ….' consistently. What is going on?7.1KViews1like4CommentsSharePoint Library Help Needed
I have a SharePoint Library where I would like to implement these requirements below and would appreciate your advise: Folders were created at the library level, which looks like the image below. I do not want people to be able to create any folders or upload documents or folders at the library level, but rather only when they open the folders. I have disabled folder creation and created a PowerApps form, so that users can only upload document, edit documents, view details of the documents when they open any of the folders., but I cannot seem to find the Power Apps form when I open any of the folders and try to upload a document or view a document or edit the document details. 2. I have a choice column called Fiscal Year which has options as = FY22, FY 23, FY24, FY25, FY26. By March 2026, I would like to create an automate flow which will auto create FY27 and remove FY22 from the choice, so that the choice column is always limited to only 5 years.45Views0likes1CommentGraph API 1.0 - Listing lists doesn't return all lists (todoTaskList)
Hi, first time posting here, please let me know if I should be doing something differently! I've searched throughout the internet and couldn't find a reason for this. I've got a couple of users running into a problem where the https://learn.microsoft.com/en-us/graph/api/todo-list-lists?view=graph-rest-1.0&tabs=http endpoint only returns one list (Flagged Emails), though these users have and see many other lists in the To Do desktop (macOS) app. I've confirmed in both cases it's the same user that's identified in my app/integration and in the desktop app. They can see the tasks in that list without a problem. There are no errors requesting that list, and asking via `/users/{id|userPrincipalName}/todo/lists` also returns the same response (with that one list). Is there any known situation where this could be happening? Am I missing something obvious? Is there something else I should be trying? I've got many other customers using the To Do integration without a problem. I'm aware "My Day" and a few other special lists aren't returned. Thank you so much!613Views0likes7CommentsSharePoint permission change notifications not working
Problem: Trying to get Microsoft Graph change notifications when permissions change on SharePoint/OneDrive drive items (sharing, inheritance breaks, access grants/revocations). Using Prefer: includesecuritywebhooks on subscription creation as documented subscription creates successfully, but the header appears to be silently ignored (notificationQueryOptions is always null in response, Preference-Applied header is always empty). What works: Regular content change notifications fire fine. What doesn't: Zero security notifications on any permission change. Subscription request: POST https://graph.microsoft.com/v1.0/subscriptions Prefer: includesecuritywebhooks { "changeType": "updated", "notificationUrl": "https://...", "resource": "drives/{driveId}/root", "expirationDateTime": "2026-06-12T00:00:00Z" } Permissions (all with admin consent): Files.Read.All, Files.ReadWrite.All, Sites.Read.All, Sites.FullControl.All, Directory.Read.All Already tried: Both v1.0 and /beta endpoints same result Every relevant permission combination But the official document says it should work: Link to documentation: https://learn.microsoft.com/en-us/onedrive/developer/rest-api/concepts/scan-guidance?view=odsp-graph-online#receiving-webhook-notifications-for-security-events Any working example or confirmation of current status would be extremely helpful. Happy to share more details or test specific configurations.28Views0likes0CommentsMoving Files from a Shared Drive to a SharePoint site
Hi, I've seen the moving of files from a Shared Drive to a SharePoint site can be tricky, depending on the size of the files that are to be moved. What is the best and most effective way to move folder, files. I'm not sure yet of the number of folders and size of the files that will need to be moved? Can anyone provide an advise on this, please.. Regards Chris133Views1like3CommentsCan move SharePoint list items to folders in a list, but not back to root of list with Move To
Does anybody know if this is by decision or bug..? I created a SharePoint list for inventory and created 2 folders for private items (unique permissions on folders) to hide list items at certain times of the year. I tried to move them back OUT of the folder to the root of the list, but it does not allow me to do so. See screenshot on the bottom shows Move Here button is disabled on root of list.. attached is screenshot only when in folders.. My workaround would be to create another folder called public and inherit permissions from a list, set all views to show No Folders and move from private to public, but thought I 'should' be able to move back out to root of list...Solved8.2KViews1like6CommentsColumn Visibility based on previous people column
We've setup persistent approvals for travel requests using a Power Automate flow (not the built-in workflow), so the approved status is not lost if/when the list item is edited. We have a choice column for Approval Request allowing "Draft" and "Submitted". Just need a control to prevent saving the list item as "Submitted" if there is no selection in the Approver (people) column. As you know, we can't use a people column to evaluate conditional visibility on the list form... https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide And we've tried JSON formatting with a 'helper' column to show if an approver has been assigned or not: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=if(length([$Approver]) > 0, 'Assigned', 'Unassigned')" } But this doesn't set a value in the column so cannot be used for list validation settings. To reduce complexity, we're trying to do this without using a Power Apps form and conditional visibility... but maybe it's not possible? Already found this help redirecting to Power Apps... https://techcommunity.microsoft.com/discussions/sharepoint_general/column-visibility-based-on-previous-multi-choice-column/3987360 Any alternative suggestions are welcomed. Thanks!82Views0likes1CommentSharePoint - Filter stacking
SharePoint list with a Link to Documents (hyperlink) column. When you click the link, it should open to the library where these documents are stored based on the associated ID for the record with all the documents that have that "Document ID", in this case 5550. /AllItems.aspx?FilterField1=ABC_ID&FilterValue1=5550&FilterType1=Text This field is a Hyperlink field The item opens in the library where the documents are all being stored, but is showing an additional filter value (sometimes, it will show three additional values) for example, it will show 5550, 5596, 2208 (all random each time). Is it caching old searched filters? When I go to the library and clear all filters and then filter from the All documents on the 5550, I get all my documents back no problem. I compared the URL with the broken filter to the URL from the all documents filter and they are the exact same Why would this be happening? What is breaking the filter and adding or stacking additional filters to the requested link. Any help to fix this would be appreciated.184Views1like6CommentsHow are you creatively working around the SharePoint List View Threshold
Hi community I'm looking for outside-the-box approaches to dealing with the SharePoint List View Threshold (5,000 item limit). I'm familiar with the standard guidance, indexed columns, filtered views, folders, but I'm curious how others have solved this more creatively, especially in M365/SharePoint Online environments where you can't raise the threshold from the admin side. Additionally, if you've tackled this in a healthcare, government, or other highly regulated environment where you couldn't just move to an external database easily. Would love to hear what's worked (and what's blown up) in practice. Thanks in advance!Solved192Views1like3CommentsHow to hide the Modify this view and Create View as per users available in groups
Hi All, I have classic view of SharePoint in list/libraries. I have group(for Managers). I just want want to show and hide the Create View/Modify View/Modify this view depends on users available in group. If user available in group(for Managers) then they can do anything like Create View/Modify View/Modify this view but if user is not a part of the group(for Managers) then they can not modify any Public views but the can create Personal view. Is there any way how I can achieve this functionality?176Views0likes1Comment