Forum Widgets
Latest Discussions
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
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!
Word 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.
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, GokulDate 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 j
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
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
Is Sync button works fine if LVT crossed in SharePoint Online for Document Library ?
Hi, I have SharePoint Document library having more that 10k files. Is Sync button for offline usage on machine visible for more than 5k records ? Also, If yes I am not able to see this button for the library. And, another user is able to see button but its not working. Regards, Pratik DarakIssue related to "Blocked script execution in <URL>" in Embed Webpart | SharePoint Online
Hi, I have created one HTML file which having code related to Image Map element. After uploading html file to site assets library using embed code of it in the "Embed" webpart giving an error while clicking on any which has been mapped in Image Map as" Blocked script execution in <URL>. Blocked opening <URL> in a new window because the request was made in a sandboxed frame whose 'allow-popups' permission is not set". Any solution to over come this problem in SharePoint Online Embed Webpart. Regarards, Pratik
