Recent Discussions
SharePoint Regional and Language settings for all sites.
How as global admin or SharePoint Admin do you change the language and regional settings for all Existing SharePoint Online sites and so that new ones have the required setting. We want en-GB. If this has to be done through a powershell connected script where MFA is enabled I need a script that will run for each site at example contosa.sharepoint.com Thanks
Different columns for folders and subfolders on SharePoint
Hello, Please i need your help on this issue Here isthe summary of what we want to achieve: Weare facing an issue with customizing columns in SharePoint. We created a subfolder named "Project" and "Project Images" within your SharePoint library. In this subfolder,weadded a custom column called "Marina Test"with specific choices. However, this column is also appearing in the parent folder and throughout the entire library, which is not what we intended. So thereforeourgoal is to have the "Marina Test" column visible only in the specific subfolder and not in the parent folder or other parts of the library. Additionally,We want the flexibility to create different custom columns in other subfolders as needed. This customization should be accessible to all users with the current permissions.
Is it possible to restrict what values a user sees in a lookup column in a Document Library
Hi Guys, Need inputs on a particular requirement that I am struggling with in SharePoint Online Document Library. Here is a Document library, where I have a column named "document department". This is a lookup column to a separate list called "Department" The list "Departments" is below. It has various departments (like Finance, Human Resources, Project Delivery etc). It has department name, department shortcode, etc. REQUIREMENT : --------------------- The requirement is that when a document is uploaded to the document library, the users would select the department from the list of departments. At present, if the user belongs to HR department, they can still see and select other departments in this column. This should NOT be the case. The user should only see the department in that dropdown list, which the user belongs to (Example, HR user should only see the HR in the dropdown, and other options should either be grayed out or not visible). How do I achieve this?
Flow to replace SharePoint site page text web part content from form entry
I wish to trigger a flow from a form and use a response value to replace the text values in a text web part in a specific page in "Site Pages". I have tried 2 options but neither of them work. I had a look at this method but I found it confusing plus I would not be able to share/email the page because of the dynamic nature of the content. I am getting a error on the final action (version 1) or having the content canvas completely removed including canvas header (version 2). TRIGGER (both options): When a MS Forms response is submitted ACTION 1 (both options): Get response details ACTION 2 (for option 1): Get Digest Token (via Send an HTTP request to Sharepoint (POST)) ACTION 3a (option 1): Update Web Part (via Send an HTTP request to Sharepoint (PATCH)) -- RESULT: Action 'Send_an_HTTP_request_to_SharePoint_-_Option_1' failed: Cannot find resource for the request webparts. clientRequestId: 093cb580-33ec-45b8-a305-f0ccd16e5405 serviceRequestId: 00616aa1-b034-4000-219c-1d33e02fd756 ACTION 3b (option 2): Update CanvasContent1 (via Send an HTTP request to Sharepoint (POST)) -- RESULT: No change to web part and page not modified.
Restrict SharePoint Online Folder/Document Sharing
Hello, I am looking for a way to restrict sharing within all of my SharePoint online sites. I want users to be able to share ONLY with people that already have existing access within the organization. I don't want them to be able to share internally with users who do not have existing access to the files. Simultaneously, they still need the capability to share externally to new and existing guest users. Is this possible? How can I do this? I have run a powershell script to remove the option to "Share with anyone in organization" but I can't seem to get rid of the option to share with "people you choose". Thanks!Multiple .onetoc2 OneNote files in SharePoint
Hello, in SharePoint library (from Microsoft Teams) I have found multiple .onetoc2 OneNote files in a different folder in the SharePoint library. Some of them are empty (cannot be opened), some of them can be opened (but they show only the structure - mirroring the structure of one SharePoint folder) and one of them contain the list and links to all OneNote files in SharePoint Library. Any idea why and how were these documents created? Kindest regards Leon
SharePoint On Premises Farm Restoration Question:
my unofficial supervisor broke the farm: I asked him to copy over a production content database to the test SQL Server we were using for the new farm I was building out. He accidentally overwrote the SharePoint 2016 Configuration database. His remedy: he used a database snapshot to restore the database to a point in time. He also may have restored the CA server to near that same point in time. Now, we have had several issues: patches that were installed show as not installed. the farm server went from "No action required" to "Needs Installation" The Search Service App won't communicate on port 808, even though it's open. The Search Service App was re-provisioned and the same symptoms persist. I believe that our issues are the result of this "restoration method" my supervisor employed. Can someone provide some concrete reasoning why the restoration method wouldn't work? I've explained that it severs the ties between the farm features and the configuraiton database. But it would be great to have a more expansive explanation.Need help pulling dates from Calendar
We have a calendar that tracks all the meetings we have with clients. Our leadership is requests that we provide them an excel spreadsheet at the beginning of each month showing all the meetings that we had with our clients the previous month. This works well but because we have many recurring meetings, those are not showing up. I have a start time and end time for the meetings. So in order to extract the data I created a field for the month and year based off the start time. Here is my example: In May 2023, we created a recurring meeting every first Monday of each month. This is showing on our Calendars correctly, but when I pull the month and year from the start date, it is pulling May 2023 for every event. I need it to pull November 2024 for the November meeting and December 2024 for the December meeting and so on. How can I show the start and end time as the real time of the meeting?Hide Personal OneDrive Results from Search
I have received complaints from users who are becoming confused when they find their own work OneDrive files in the SharePoint search results. The either worry someone else can see their confidential files, or simply don't understand the concept of checking the URL. Is there an easy way to remove these results from the default search? Additionally, are there any reasons we should not restrict these results?Syntex is not pushing content type to Hub site and associated sites
I am trying to create content type in content type hub and publish it toa hub site and siate associated to it. There are 3 different content types Custom content type from Document Content type Custom content type from Site Page Custom content type from List item Issue is all above content types are not getting pushed to Hub site and site associated to hub sites. It only worked for a custom content type created from Document content type, only for a new site joining hub after content type was published. Its been 24 hrs but I do not see this custom document content type pushed to other sites in hub. Also it is not getting pushed to Default Document and Site Page libraries. My tenant has Syntex licenses and I see option to select and push to hub sites. I have followed https://learn.microsoft.com/en-us/microsoft-365/syntex/push-content-type-to-hub Questions: Does it support site page and list based content types? Does is push content types to existing default library , Site Pages, Documents etc. How many level of hub association it supports? I have nested Hub site architectureHow to run a Python script on a SharePoint list in order to generate a PowerPoint file?
Hi everyone, I currently have a local Python script that takes a CSV file (downloaded manually from SharePoint using the "Export as CSV" button) as input, processes the data, and generates a custom PowerPoint file using on a predefined template stored in the script's folder. The process works fine locally, but I want to streamline it so users don't have to download the CSV file and script locally and manually. Instead, I'd like to: * Run the Python script directly on SharePoint. * Provide a simple button in SharePoint that users can click to trigger the script. * Have the script fetch the exported CSV file directly from SharePoint, process it, and then download the generated PowerPoint file Any advice, best practices, or examples would be greatly appreciated, thanksDate and Time entry form split into two
Hi, I've been asked to support on a site that has been in place for a few years now, and they are having some issues with the date and time column. One thing that I have noticed though that on this site, the entry for the date and time is split into two, one calendar dropdown for date and another for time, but still part of the same column on the list. Does anyone know how this is achieved, and if it can be changed to the normal view with the date and time all grouped together in one cell on the form? From what I can see there is no custom formatting in place or anything else different in the standard settings. Current view Standard view Thanks!Get all versions' check-in comments through API
I'm trying to use the REST API through Power Query to get all history check-in comments of an item. I could see all the comments from the version history but output of the API shows the lastest comment for the both two versions: I'm using a Power Query function I get from the Power BI forum and all other things it returns are correct, except the check-in comments let Source = (VersionsRelevantSharePointListName as text, VersionsRelevantSharePointLocation as text, VersionsRelevantItemID as number) => let Source = Xml.Tables(Web.Contents( "https://tenatename.sharepoint.com/sites/", [RelativePath = VersionsRelevantSharePointLocation & "/_api/web/Lists/getbytitle('" & VersionsRelevantSharePointListName & "')/items(" & Text.From(VersionsRelevantItemID) & ")/versions"] )), entry = Source{0}[entry], #"Removed Other Columns2" = Table.SelectColumns(entry,{"content"}), #"Expanded content" = Table.ExpandTableColumn(#"Removed Other Columns2", "content", {"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"}, {"content"}), #"Expanded content1" = Table.ExpandTableColumn(#"Expanded content", "content", {"properties"}, {"properties"}), #"Expanded properties" = Table.ExpandTableColumn(#"Expanded content1", "properties", {"http://schemas.microsoft.com/ado/2007/08/dataservices"}, {"properties"}) in #"Expanded properties" in Source Does this API support return all comments? Or I need to get all comments from elsewhere.
Managed metadata - bug with adding new terms?
I have a document library with managed metadata implemented. I have added Tags with terms. The term set is set to 'Open' and also to 'Allow Fill in Choices' to allow users to add their own terms if its not already there. However, when typing a new term, we get a message saying 'Please fix highlighted invalid terms before save.' This feature to allow users to type in their terms has worked for us previously on another Document Library and its now not working. Any ideas?Labelling documents to make them easier to retrieve when searching in SharePoint
I'm a bid writer for a construction company and my my memory isn't what it was. I often need to retrieve answers I've previously written and even with the excellent search functionality of SharePoint, it can take me some time to find exactly what I'm looking for. I've been researching different methods of 'tagging' documents and am unsure of the best way forward, and don't want to go down the wrong track. The tagging method in the following video looks perfect BUT it mentions that tags would only show up for me, and I have a junior bid writer who would need to use it too: https://sharepointmaven.com/a-new-way-to-tag-content-within-microsoft-365/ The Task Store option may therefore be the best solution, but it looks far more complicated than I need, and may be overkill. I've also seen Microsoft Syntax mentioned but not sure what it actually does. Each document I produce would probably have around 5 tags - client name, type of project (e.g. school), and a few on the subject matter of the response - e.g. health and safety, environment, project team. Can you please advise which of the above options would be most suitable for me, or is it another solution entirely? Thanks in advance.How to preserve colors when exporting SharePoint list data as an excel file?
I've been working with a SharePoint list that has several columns with specific color-coded formatting. When I try to export the data, I'm losing these important visual cues that help me quickly interpret the information. How can I ensure color formatting preserved when I click the "Export to Excel" button? Are there any known workarounds (i,e, via power apps or power automate)? If so, which would be best if I am exporting around ~1000 rows of data each time
Events
SharePoint Embedded December Super Session! Attention Azure and SharePoint Developers: there is a new storage option available to you that’s ideal for file and document intensive enterprise AI apps....
Online
SharePoint Embedded December Super Session: Attention Azure and SharePoint Developers: there is a new storage option available to you that’s ideal for file and document intensive enterprise AI apps....
Online
Recent Blogs
- The new forms experience in Microsoft Listsis now rolling out for Microsoft 365 work and school. Our goal is to make it easier to collect and gather information directly into your lists – sav...Dec 05, 2024
- 4 MIN READSimultaneous multi-language document translation As the daylight hours grow shorter and the temperatures drop lower, we’re here to brighten your spirits with exciting news: SharePoint and OneDrive...Dec 04, 2024
