Recent Discussions
*site* has no Primary Owner set. Please go to the site and set one of the owners as primary.
Hi, I need help with these emails that are coming. On SharePoint site there are persons who has Ownership on this site but they still get email. Do you know how to set this in sharepoint admin panel or somewhere else so they don't get these emails anymore?
How to calculate the number of business days between created date column and todays system date?
I am trying to calculate the count of business days between the SharePoint system created column and Today system date but just for business days. Initially, I created the calculated column Days Open and it worked perfect, but I do not know how to create a formula that only counts the business days. Can anyone help me with this? =TODAY()-Created
Copilot 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, Aykut
PageContext listItem.id Lag After Navigation in SPFx Web Part
Hi everyone, I'm running into an issue with an SPFx web part where this.context.pageContext.listItem.id appears to lag behind after navigating between pages using the SharePoint “Pages” tab (the left-hand nav on a SharePoint site, not a full browser reload). Here’s the behavior I’m seeing: I navigate to Page 1: listItem.id shows the correct ID for Page 1 I navigate to Page 2: listItem.id still shows the ID from Page 1 I navigate to Page 3: now it shows the ID for Page 2 This continues until I perform a full page refresh, which resets things correctly. It feels like there's a one-step delay in updating pageContext, possibly due to how SharePoint handles partial page loads or client-side routing. To try to work around this, I moved my logic from onInit() to render(), but the lag still exists intermittently. Has anyone else encountered this kind of lag with pageContext? Any guidance on best practices for detecting the current page reliably in SPFx when navigating within the SharePoint UI? Appreciate any insight — happy to share more details if helpful. Thanks!
Event Listeners Not Working After Translating SharePoint Page with SPFx Extension
Hello everyone, I'm developing a SharePoint Framework (SPFx) extension to translate SharePoint pages using a language viewer API. The extension includes a dropdown menu for language selection, and it successfully translates the page content based on the selected language. However, after the translation, all event listeners attached to elements on the page, such as the "Add New" functionality of the out-of-the-box (OOTB) list web part, stop working. Here are the steps I've taken so far: Reattached event listeners after applying translations. Despite these efforts, the issue persists. Has anyone encountered similar problems or have any suggestions on how to resolve this? Any insights or solutions would be greatly appreciated! Thank you in advance for your help!Column Validation Evaluation Changes
Hello! I'm wondering if I am going crazy, but I have seen breaking changes to a couple of client tenancies where column validation is now occurring for any item/file creation or modification event. This was not happening a month or so ago, and I've got evidence of that with files being able to be placed in a library previously, and not, now. This is because it is clearly trying to validate on column information that is not entered by the (flow) creation of the file. If I were to try to deal with this INSIDE the validation formula for all my lists, ever ... this could effectively cripple me! 😅 --- I'm not posting a problem that needs fixing, here, so please, I do not need to be asked what I have and haven't tried ... I'm simply asking if others have noted a similar thing happening.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!
Basic email attachment to sharepoint flow not working
Hey Everyone! First off, I have to preface this request by mentioned that I am a complete Flow newbie. My background is typically on the Network side of things, so messing around this this has been on an adhoc nature, with no exposure to it before. I'm working on creating a Flow, which I believe should be fairly basic. I want to monitor my inbox, for emails from a specific sender, and save attachments to a Sharepoint folder. This is my Flow configuration: This current configuration doesn't appear to be working, no attachments from the sender have been saved into the specified folder. I've verified that both my Email and Sharepoint connections are linked. When I do the test, I see the expression as false when scanning for emails, see photo below: Would anyone have any thoughts or ideas on why this wouldn't be working? any help would be appreciated! Thanks, Mike
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, FabienPnP SingleWebPartAppPage removing all page contents
I am trying to convert a SharePoint page into a single web part app page to display a PowerBi report in full screen. I have tried creating the page, converting to "article" layout, adding the embed (both the PBI specific and the generic embed) webpart then running the script to convert to a single webpart app page. When I run the script, it is converting the page but it is removing the embedded web part. Here is my code: $clientId = "XXX" $clientSecret = "XXX" $tenantId = "XXX" $scope = "https://graph.microsoft.com/.default" # Use Microsoft Graph default scope for app-only authentication Connect-PnPOnline -Url example.com -ClientId $clientId -Tenant $tenantId -Certificatepath "C:\Users\User\Example" -CertificatePassword (ConvertTo-SecureString -AsPlainText "Example" -Force) if(Get-PnPConnection) { Set-PnPPage -Identity "Example.aspx" -LayoutType singleWebPartAppPage } else { Write-Host "Connection failed. Please check your credentials and try again." Any help or advice would be greatly appreciated.
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.Date format in Sharepoint sites
Hi all, Yes another question about date formats. In our M365 tenant, all dates on our Sharepoint sites show in US format. Under Site Settings/Regional Settings I have the Locale set to English (Australia) but Sharepoint seems to ignore this. Is there actually a way to chagne the date format to DD/MM/YYYY or at least YYYY/MM/DD? thanks jWord template in sharepoint document library is not updating correctly
Hi, We are using SharePoint online document library to create document set. But If we are updating some data in SharePoint document library using edit properties but the data is not updating in word template. We are creating document set using Power Automate flow. While creating document set the data is appending properly but when I try to update SharePoint library the data is not updating in word template. Also, the date fields are not appending while creating and updating case. We are using SharePoint online document library .And in that we are creating document sets .So, we have created 3 documents in it using PowerAutomate actions .We are appending metadata to it using Microsoft word online Business. But ,now when I update something in SharePoint library so that respective field should update in templates also. We have two sites one is for dev and one is for Acceptance. So, for dev it is mapping xml data from SharePoint library to template but, that is not happening for Acceptance.Add a custom Visio template to sharepoint document library
Hello. How do I add a custom Visio template to a sharepoint document library? I tried the "add new template" option and when I click on the relevant template to add a new document of this type the browser opens with "About:blank" Help much appreciated. ThanksHow 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, GokulOnly allow the creator of the item and the user direct manager to view the submitted item
I am facing this challenge , where we want to create a custom list, with the following logic;- 1) User submit a request asking for example for for salary increase. mentioning the amount. 2) The request need to be approved by the user direct manager 3) then the manager of the user's direct manager, need to do a second approval. Now we need to force those permissions:- 1) once the form is submitted others users should not view this item, even for 1 minute, 2) so the item once submitted should only be viewed by the creator, without the ability to edit it 3) only the direct manager and later the manager of the direct manager can view it. Here what i tried and what i faced:- 1) i created a custom list, define all the columns 2) create a power apps form to submit the form. 3) create a custom permission level, to allow the user to create but without edit/delete, which is mainly a copy of the contribute, without those check-boxes:- 4) then i define a power automate flow so once the item is submitted ,to send approval email to the direct manager + grant the approval manager & submitter read on the item. where i am storing the approval status inside another list that can only be edited by the service account. this worked partially, as the item will still be visible to all users until the workflow runs. also incase the workflow fails to run the item will stay visible forever. so i tried this second approach, benefiting from Item-Level Permissions:- this will always force the item to be visible to the creator only, without the need to have a workflow. but we faced an issue , when we want the submitter's direct manager to view this item, to be able to approve or reject it. where even if we grant the direct manager full control on the item, the item will not be visible to the direct manager, since we define the above Item-Level permission. the only way to to fix this is to grant the direct manager's full control on the list, but in this case the direct manager will be able to view all items, not just the ones submitted by his team ! can we do this for example:- 1) create a custom permission level to only allow the user to submit without the ability to edit, delete, view? 2) then using a workflow to force the item permissions as we go. 3) in this case the item from the beginning will not be visible to anyone, then the workflow will do the permission modification. so if the workflow fails atleast the item will not be exposed to any one, so not sure what u need to do, and if SharePoint support a way to create a custom permission level that allow the user to create without the ability to edit,delete and even view? any advice?
Recent Blogs
- There are so many new ways to make your SharePoint sites compelling and beautiful. Meet SharePoint experts from inside and outside of Microsoft this May. Join us via this special discount at the Mic...Apr 18, 2025
- 1. Introduction The Book of Archimedes is a single PDF that contains all posts in the Microsoft Graph Data Connect for SharePoint blog. This includes 40 articles and nearly 400 pages, which...Apr 17, 2025
