Forum Widgets
Latest Discussions
Updating Calculated Column Automatically
Hi all, I have a calculated column that works, but only when we edit the list or settings, etc. Is there a way to set it so the calculation runs automatically without touching the list? Say daily, etc.robmateyJun 20, 2025Copper Contributor24Views0likes1CommentSharePoint Online's "Move To" feature no longer showing my sites
Some point a few weeks ago the Move To function changed. Now when you want to move a file out of a Site and into another, it doesn't let you pick from your Followed Sites, it only lets you pick from your Recent document libraries. We have many Sites and it's making it difficult to move items efficiently (if the location you're moving something to doesn't show up, you have to click around in it in another tab for it to eventually show up in Recent). Previous, it just showed all of my sites that I am a member/followed. Any idea why this might have changed? These are all stand-alone sites, no O365 connection, but they are all part of the same hub-site network. Thank you!MysticodeJun 19, 2025Copper Contributor20KViews0likes10CommentsAll day events option - Sharepoint online
Hi all, Is there a way to enable an "All Day" option in a modern SharePoint calendar? If not, is it possible to create this option manually or use an alternative method, rather than setting the event time from 12:01am to 11:59pm? Thanks in advance!AB21805Jun 19, 2025Bronze Contributor44Views0likes3CommentsInfoPath Unable to Submit the Data
Hi Team I have the InfoPath form which is connected with SharePoint list in the list i have added the new column and also i have added the new textbox in the InfoPath designer but while submitting the data the column value is not storing to the DataSource. The DataSource is giving the Main in the InfoPath designer. Can you anyone give me the solution Please find the Images. Newly Added the Column which is Sample Data. Can any one suggest me the solution Please Thank You, SaiKrishna.Issues with customRowAction
We have a library with a handful of metadata fields, including Document Status (vStatus) : Managed Metadata, default value = In Progress To Be Checked (vToBeChecked) : Yes/No, default value = No Checked (vChecked): Yes/No, default value = No 'To Be Checked' is used to filter a view that only shows items that need checking, it's not visible on the view itself - if Yes, then the document is visible for checking. When 'Checked' is toggled to Yes, a custom row action is triggered that sets 'Document Status' to Final, and sets 'To Be Checked' to No. This has been working for the last 3 years, now one user has started receiving an error that 'One or more fields have an error', the error points to the 'Document Status' field as having the problem. If I remove the line that updates the Status, everything else works as expected. I've re-created the above fields on a new site and am able to replicate the error The Site Owner account, using Edge or Chrome, normal or incognito/private receives the error SC Admin using Edge private mode it works One normal site Member has the error, another doesn't Code for 'vChecked' field { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "display": "flex", "width": "100%", "height": "100%", "align-items": "center" }, "children": [ { "elmType": "div", "style": { "display": "flex", "width": "60px", "height": "30px", "border-radius": "15px", "align-items": "center", "flex-direction": "row", "justify-content": "=if(@currentField , 'flex-end' , 'flex-start')", "cursor": "pointer" }, "customRowAction": { "action": "setValue", "actionInput": { "vChecked": "=if(@currentField , '0' , '1' )", "vToBeChecked": 0, "vStatus": "=if(@currentField,if([$vStatus] == 'Final','Final|{{ GUID }}','In Progress|{{ GUID }}'),'Final|{{ GUID }}')" } }, "attributes": { "class": "=if(@currentField , 'ms-bgColor-themePrimary' , 'ms-bgColor-neutralTertiaryAlt')" }, "children": [ { "elmType": "div", "style": { "width": "18px", "height": "18px", "margin-left": "6px", "margin-right": "6px", "border-radius": "50%" }, "attributes": { "class": "ms-bgColor-white" } } ] } ] } Code for 'vStatus' field { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(@currentField == 'Final', '#cfe7d8', if(@currentField == 'In Progress', '#fff4cc', if(@currentField == 'Internal Only', '#ccd6ec', '' )))" } } Code for 'vToBeChecked' field { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "display": "flex", "width": "100%", "height": "100%", "align-items": "center" }, "children": [ { "elmType": "div", "style": { "display": "flex", "width": "60px", "height": "30px", "border-radius": "15px", "align-items": "center", "flex-direction": "row", "justify-content": "=if(@currentField , 'flex-end' , 'flex-start')", "cursor": "pointer" }, "customRowAction": { "action": "setValue", "actionInput": { "vToBeChecked": "=if(@currentField,'0','1')", "vChecked": 0 } }, "attributes": { "class": "=if(@currentField , 'ms-bgColor-themePrimary' , 'ms-bgColor-neutralTertiaryAlt')" }, "children": [ { "elmType": "div", "style": { "width": "18px", "height": "18px", "margin-left": "6px", "margin-right": "6px", "border-radius": "50%" }, "attributes": { "class": "ms-bgColor-white" } } ] } ] } Any ideas would be appreciated. - RRobD365Jun 18, 2025Copper Contributor154Views0likes3CommentsError editing any pages in our tenant
One of my Client has a mysterious error on there tenant since sometime in July. No one in the entire tenant can edit any pages on any of the sites in SharePoint, not even if we create new sites. It's not a permission issue and it happens to Users and administrators alike. The Edit button is clickable, but as soon as you click on it, it says that you can't edit the page. We have found a workaround, where we can go into the site pages library and in Versioning settings, we specify force checkout when editing. With this setting on it works to edit pages again. I could apply this settings to alla sites in the tenant rather easy with PowerShell, but when a user creates a new site, which they do, this setting won't be applied there. So I rather have a better fix for this. When I click the edit page I get a network request to startCoAuth. The Collaboration on SharePoint pages has started rolling out in July so my guess is that this is something that could have gone wrong in this tenant when rolling out this feature. Anyone else seen this problem?MarcusEkornJun 18, 2025Copper Contributor276Views0likes1Comment30 Items only showing SharePoint List JSON Formatting. How to increase this number ?
Hi, I have formatted a list with JSON and I have found a peculiar error, no matter what I set the view item limit to, it only shows the first 30 items along with "See all" button after full scroll. How can I increase this number from 30 to 100 where group by has been placed on view ? Thanks, Pratikpratikdarak21Jun 18, 2025Iron Contributor33Views0likes0CommentsMS Lists time zone issue
Hi everyone, Currently I'm using Power Automate, to import every new MS Form response to my Lists. I know that the MS Form's "Completion time" is based on UTC +0. So I converted my "Completion time" from UTC +0 to UTC +8 (where I located) For example: Form No. 43 is completed on 5/30/22 06:41 (UTC+0), I should have successfully converted that to 5/30/22 14:41 (UTC+8) And when I did a test in Power Automate for this flow. I also observed the Output to be "5/30/22 14:41" But when I checked the Lists, it's actually showing: 05/30 9:41, with a -5 hour time gap to my output, 14:41. Below is the screenshot: I had checked my account setting and my region is in UTC+8. I would like to know why that Lists is showing my output differently. And what causes this 5 hour gap. I know maybe I can just add 5 hour to the time, but there should be a root cause for this. If you know the answer please kindly help, thank you in advance!0R1N7766Jun 18, 2025Copper Contributor1.6KViews0likes4CommentsEditing or updating URL of link file saved in Sharepoint document library
I have a modern Sharepoint document library in which I have created a lot of links to pages on external websites. I have been trying to find a way to edit/update the URL of those links without losing the metadata. There does not appear to be any way of doing this directly in Sharepoint, short of deleting the link (and all its metadata) and creating a new link I have found and tried a couple of suggested solutions online: Sync or download the link file to a local folder, edit the URL for the shortcut file in Windows, and then resync/upload to Sharepoint overwriting the original file Use PowerAutomate (Update File operation) to change the URL by updating the link file contents I have used both methods, and in both cases appear to successfully update the file content of the shortcut/link file, but the updated file doesn't work in Sharepoint. If I download the updated link file and open it on my desktop, the shortcut works perfectly, directing me to the updated URL. However, opening the updated link directly in Sharepoint takes me to the original URL. It doesn't make sense to me that the same file behaves differently depending on whether it is opened in Sharepoint or on the desktop. Can anybody explain what is going on, and how I go about fixing this?WayneKarkJun 17, 2025Copper Contributor16KViews2likes9Comments
Resources
Tags
- SharePoint Online17,938 Topics
- Document Library3,119 Topics
- Lists3,046 Topics
- Sites2,511 Topics
- admin2,201 Topics
- sharepoint server2,001 Topics
- Permissions1,934 Topics
- files1,664 Topics
- developer1,566 Topics
- microsoft lists1,505 Topics