Forum Widgets
Latest Discussions
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. - R
Error 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?
30 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, Pratik
MS 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!
Editing 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?Open internal links in a new tab
I have a list with an item linked to internal document set to open in a new tab. When I add a webpart on the home page and add this list, the above link opens in the same tab. Why is the link not behaving in the same way as when I open the list itself? How do I make the link on the home page open in a new tab?
Licensing Requirements for SharePoint Advanced Management
Please confirm Licensing Requirements for SharePoint Advanced Management? I ask because I believe there is a scenario where if I have one user account in my M365 Tenant (say this one user account was treated like a service/admin account) and this same user account was subscribed to the Monthly Copilot subscription; it could also therefore subscribe to the SharePoint Advanced Management subscription too? Afterwards, then this user account could do the SharePoint Advanced Management tasks. Sincerely, Joe Botelho
