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()-CreatedColumn 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!
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
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.
