SharePoint.....365 Groups Clean Up - Unused Sites
Hello, my wonderful people! I am attempting to clean up a list of existing SharePoint sites. There are over 300 sites currently, luckily this will no longer grow since allowing users to create sites on their own has been disabled. I did an export to see all the sites from the SharePoint admin center. I was excited to see the over 50 sites had no files associated with them and they were not being used for at least the last 4-5 years. Sadly, they are Microsoft 365 groups which I understand have associated mailboxes, calendars, OneNote, etc. associated with the site. Any ideas on how to make sure I cover ALL the bases before deleting these sites/Microsoft 365 groups? Has anyone done this before? Ideas for process would be amazing!
SharePoint - Group By View Fails
Hello, We have a library that contains document sets, normal metadata and managed metadata. The library has a view that groups all the files in each document set folder by 1 managed metadata column. There are no other features applied. This view has been working absolutely fine until yesterday. Now something strange happens. When I click on one of the "group by" ___" options, I get an error message saying there is nothing found here, even though there are clearly files. If I use the little arrows to expand the "group by: ___" option, it works fine. If I use the group by tool or view on any other column, it works fine. It is only with this one managed metadata column where problems arise. This issue also occurs inconsistently. Not everyone has this problem. I thought it was a browser issue or a system update issue. But I have the same issue even after clearing my cache, making sure everything is up to date. What's going on?
Pb formating columns
Hello, I used JSON to format the columns of a list. It works fine when I'm in design mode on my list. However, when I embed this list into a web page, from a Web Part, it no longer works. The formatting is removed. Do you have any ideas on how to resolve this issue, please ? Below is the JSON code of the column : { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "attributes": { "class": "=if(@currentField == 'Divers', 'sp-field-severity--good', if(@currentField == 'Note information', 'sp-field-severity--low', if(@currentField == 'Travaux', 'sp-field-severity--warning', if(@currentField == 'Organigramme', 'sp-field-severity--severeWarning', 'sp-field-severity--blocked')))) + ' ms-fontColor-neutralSecondary'" }, "children": [ { "elmType": "span", "style": { "display": "inline-block", "padding": "0 4px" }, "attributes": { "iconName": "=if(@currentField == 'Divers', 'CheckMark', if(@currentField == 'Note information', 'Forward', if(@currentField == 'Travaux', 'Error', if(@currentField == 'Organigramme', 'Warning', 'ErrorBadge'))))" } }, { "elmType": "span", "txtContent": "@currentField" } ] } 1: Rendering the list in design mode 2: Rendering by adding the list to a web page Thank you in advance for your help. Sincerely, Fabien
SharePoint Calendar
I have established a SharePoint site aimed at creating a centralized hub for my team. Within this site, there is a section dedicated to upcoming events and a calendar. Currently, I need to manually input all events. My goal is to link this calendar so that whenever an "admin" sends out a meeting invite for group meetings, training events, etc., they can simply include the SharePoint calendar address, and the event will be automatically added to the SharePoint calendar.
How to connect SharePoint site access user details via Google Analytics data studio
Hi Experts, Good day, I would like to create new reports in Google data studio (Google Analytics), with the data source coming from SharePoint. I need to import site access user counts, including the number of views and counts. I know that we can export this data via the Microsoft 365 Compliance Center, but my client does not allow tenant access due to data privacy concerns. Could you please advise on how we can achieve this? Specifically, I need to collect SharePoint document and file access user details daily and connect this data to Google Analytics on daily basis. If you have step by step instruction details or if you have alternate way to achieve this let me know. Regards, Gokul
how to get files of a specific folder path in sharepoint using /lists graphapi
i was able to get folders of a specific folder path using /drives but in /lists it will return files also not just folders unlike /drives , i already made a python script to retrieve files from documents in sharepoint , but now i need to get files of a specific folder not the whole documents folders here is the graph api url to retrieve folders from a specific path https://graph.microsoft.com/v1.0/sites/siteId/drives/driveId/root:/General/index/images/animals:/children?$top=15 here is my python script to get files and folders using /lists async def fetch_file_details(session, url, headers): async with session.get(url, headers=headers) as response: print(f"headers {response.headers} ") return await response.json() async def get_all_images_in_library(accessToken, siteId, libraryId, batch_size=15): url = f"https://graph.microsoft.com/v1.0/sites/{siteId}/lists/{libraryId}/items?top={batch_size}" headers = { 'Authorization': f'Bearer {accessToken}', 'Accept': 'application/json', 'Prefer': 'HonorNonIndexedQueriesWarningMayFailRandomly' } async with aiohttp.ClientSession() as session: while url: async with session.get(url, headers=headers) as response: if response.status != 200: print(f"Failed to fetch: {response.status}") retry_after = response.headers.get('Retry-After') throttle_limit_percentage = response.headers.get('x-ms-throttle-limit-percentage') throttle_scope = response.headers.get('x-ms-throttle-scope') throttle_reason = response.headers.get('x-ms-throttle-reason') print(f"headers {response.headers} ") if retry_after: print(f"Retry-After: {retry_after} seconds") if throttle_limit_percentage: print(f"Throttle Limit Percentage: {throttle_limit_percentage}%") if throttle_scope: print(f"Throttle Scope: {throttle_scope}") if throttle_reason: print(f"Throttle Reason: {throttle_reason}") break data = await response.json() items = data.get('value', []) if not items: break tasks = [] for item in items: webUrl = item.get('webUrl', '') if webUrl.lower().endswith(('.jpg', '.jpeg', '.png', '.gif')): fileDetailsUrl = f"https://graph.microsoft.com/v1.0/sites/{siteId}/lists/{libraryId}/items/{item['id']}?expand=fields" task = fetch_file_details(session, fileDetailsUrl, headers) tasks.append(task) if tasks: batch_results = await asyncio.gather(*tasks) yield batch_results await asyncio.sleep(0.1) url = data.get('@odata.nextLink') my question is how can i get files and folders from a specific path using /lists ?
Handling Raw HTML Webpages
Hi there, My team is trying to figure out if this is possible with Sharepoint: We would like to create a data repository with granular search functionality with legacy data from an Access database. We've exported the database to excel and created a function in Python to parse each record (over 6000) into individual HTML pages that are comparable to a wiki in function. We have 6000+ HTML files we'd like to host, is there any way to upload them all together as individual web pages? Our understanding at the moment is that in this format, they'd have to be manually embedded into a created page. Assessing whether or not Sharepoint is capable of this or if we need to host something internally. Thanks!Password protected PDF's
I have a user who uploads password protected PDF's into a folder within a document library and then when they click on the file and enter the password the file doesn't open and they jump back to the top level of the doc library. If the user tries to open the file in the classic experience it works fine? anyone have any ideas?
