Microsoft.SharePoint.SPFileLockException
I am building a tool to upload the data to Microsoft Sharepoint excel file. There are many users who can use the file at the same time, but it is critical for me to be able to upload the data to the particular worksheet in that specific file all the time. However it seems that when the file is used by other users I cannot do the updates to the file and I am getting this error: '{"error":{"code":"-2147018894, Microsoft.SharePoint.SPFileLockException","message":{"lang":"en-US","value":"The file XXX.xlsx is locked for shared use by email address removed for privacy reasons [membership]."}}}' Is there a way for me to force an update to the file? To remove this Lock exception?
PnP Search Results Handlebars template saves but does not reflect on UI
Hi everyone, I am working with the PnP Search Results web part in SharePoint Online and facing an issue where a custom Handlebars result template saves successfully but does not reflect on the UI. I created a table-style Handlebars template with columns Document, Region, Country, Language, Status and Validation Date, one row per document. Documents are returned correctly and filters based on the same refinable properties work as expected. Debug output using JSONstringify(item) confirms that all refinable values are present. The same if-condition logic using item.RefinableStringXX works in a list-style layout, but in a table layout the template saves without errors and either does not reflect on the UI or renders rows with empty metadata columns. Inline bindings do not render unless wrapped in if blocks and even after fixing this the UI sometimes continues to show the previous layout. Managed property mappings, selected properties, indexing and library reindexing have already been verified. Has anyone experienced this behavior with PnP Search Results templates or knows if this is related to caching, result types overriding templates or a known limitation with table-style Handlebars layouts?
Order of Server Shutdown and Restart in SharePoint Farm
Hello, I'm planing to restart my company Sharepoint 2019 farm, and i need to know if there is an order to respect in shutdown and starting the servers. The farm is composed of Two Database server in Failover cluster, App Server, Web Frontal Server, Search server and Office Online server. Thank you
Different languages in different sites
Hi, My Sharepoint sites are appearing in multi languages and it's really annoying. I have changed my account language in to Japanese once and then changed back to English. However, almost sites still appears in Japanese. Could anyone guide me away to change back to English for all. Thank you,Sharepoint - Prevent a new version each time a document is read
Hello, i am using Library in sharepoint for managing documentation using version and simultaneous collaboration on Word and Excel file. This is great. However, there is a drawback : each time someone open a document just for read it, a new version is store which is not releated to a real change. I ask users to download file an open it localy when not change is required however, errors happened and it is not easy for everyone to not forget this rule. One solution is to force checkout of the document before change (option in the library of sharepoint). In that way, a box appears at the end of the user operation for asking to checkin the new version. In this way the user will not checkin if nothing changed and prevent error. The drawback is that it prevent simultaneous editing 😞. I am looking for a way to not prevent simultaneous editing but be sure that not new version is created if not change has been made to the document or ask confirmation to the customer when a new version if about to be created in sharepoint. Is it possible ? Using power app ? How ? thank a lot for your help.
Call SharePoint Server Subscription Edition REST API via App Only Authentication
Need to call SharePoint Server Subscription Edition REST API via App Only Authentication and found below article. https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs can i do this using TokenHelper.cs as suggested in the article? Seems request tires to access ACS because of below settings in TokenHelper.cs and requests timeout since the code is executed from a Server where no access to Azure ACS. private static string GlobalEndPointPrefix = "accounts"; private static string AcsHostUrl = "accesscontrol.windows.net"; Any support on how to do this for On-Prem SharePoint is really appreciated.
