SharePoint List calculated column formula using a Lookup column reference
Given: A SharePoint List (SPL) called Contractors with the following columns: ContractorID // Display name of the default ID column ContractorName Another SPL called Reports with the following columns: ReportID // Display name of the default ID column ReportNumber // Calculated column Contractor_ID // Lookup column referring to the ContractorID column of the Contractors SPL The calculated column, ReportNumber, would have a formula similar to: = [ReportID] & "-" & Contractor_ID Question: Does SharePoint Lists support the use of a Lookup column in the formula of a calculated column? If so, I need help on the proper syntax for the formula. (The formula above is not working) Thanks in Advance
How to hide Command bar in Sharepoint using SPFX Extension without CSS injection?
I know there are similar questions on the Internet. But none of it have the solution that I am looking for. I want to hide few action buttons (New, Edit in Grid View, Add shortcut to OneDrive, Pin to Quick Access, Share, etc.) in SharePoint Command bar using SPFX extensions. enter image description here I know it can be achieved by injecting custom CSS with display: none property. But the problem is, in case in future if Microsoft updates the html element then this solution might break. Another approach is to use JSON Formatting. But this needs to be done from SharePoint UI or by calling the SharePoint API to apply the JSON formatting. But I don't want to do this. Initially my approach was: Access the command button like const newCommand: Command = this.tryGetCommand("newComposite"); newCommand.visible = false But I am getting undefined when I access it. Is there any way to hide the command buttons from the code itself using SPFX extension.
SharePoint online document library - document properties not getting update values in word document
Hi All, We have created an application in SharePoint online. This application creates Word documents in which SharePoint list fields are merged. When creating a new item in SharePoint, the Word document shows the correct date values: 1. Create new item in SharePoint. Dates are 1/9/2025 and 2/9/2025 2. Opening the related word document shows This is correct behavior 3. Change any field through 'Edit properties'. Still the dates are 1 and 2/9/2025 4. If I open the Word document now I see that the dates have a value of 1 day less then the provided date. The category is updated correct. 5. When downloading the document the correct values are shown 6. Also when opening the document through View in browser > Edit document > Open in desktop, I see the correct values Question is: 1. Why don't we see the correct values when the Word document is directly opened in the browser? 2. Is there a possibility to open the Word document always in the Client (desktop) itself instead of directly on the browser? We already tried changing the below Advanced library settings (changed it in Open in Browser/use the server default), but this didn't gave the correct solution.
Sharepoint List Lookup question
Hi I have a Sharepoint list which uses columnn "sfg" as a look up, it then returns "sfglifecycle" for instance. I want to add a calculated column that references uses the figure that's been returned in "sfgLifecycle" and times it by ten, is this possible? if so, how do i go about doing it?
SharePoint/Word: Change in permissions turns off autosave.
Hi, We have the following issue: In a SharePoint, to which users get access based on access groups, users have Edit access to Word docs by default. When the user opens the Word file in Word desktop the AutoSave is turned on. When you change to review yourself, AutoSave is also turned on. This works correctly. However, when the permission to the document is changed to Review before sharing and the user the doc is shared with opens it, the AutoSave is turned off when opened in Word desktop. Users are able to choose Edit anyway to continue editing and then the AutoSave turns back on. My question is: is the AutoSave turned off by switching the permission to Review? If so, how can we change that this does not happen. Or is it supposed to work like that? When searching online and in the MS community I cannot find a clear answer on if it supposed to work like this. Some say Review turns the AutoSave off, others say it should not.Custom Power App Form with Sharepoint NOT opening on the side panel
Hi I saw many tutorial for this but in the tutorial the app open in the same Sharepoint page on the side panel. BUT when I click on "Detail" then "Edit All" it opens it in another browser and the sizing is really off. I checked EVERY setting and can't see what I need to change. Anyone knows? Please help.
SharePoint Power Apps Form lock the form field to only created by can edit
I'm trying to get the SharePoint Form fields to be locked for editing for everyone except for the person who created the item. the only this I can see wrong is that when I place the Created By Column in the form field it shows: i:0=.f|membership|email where I think the i:0=.f|membership| before the email address is throwing the code off: I'm using this code: If( User().Email = ThisItem.'Created By'.Email, DisplayMode.Edit, DisplayMode.View ) Currently it is locked no one can edit the fields not even the person who created the item. (Created By) Is there a way to fix the code to work?
