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 AdvanceForce Office Files to Open in Desktop App (via link, from web parts.. in all cases)
I want to force Office files stored in SharePoint to open in the desktop app - NEVER in Office Online apps. I have configured the site and the Document Library but opening in the native app only seems to work when navigating to the file in the DL and clicking it directly. Web Parts seem to always open the web app, as do links copied via the "Share" or "Copy Link" options in the DL. I've made up quick video to show and tell: https://youtu.be/SvJd2_TLsmw Note - while I was making the video, I stumbled upon a workaround for when we share links internally via e-mail (and maybe I can use the same workaround when sending files in Teams.) I also fumble through trying to explain what I've been toying with as far as other workarounds.. the limitations of my technical capabilities will be apparent! I already looked at several other posts, e.g.: https://techcommunity.microsoft.com/t5/SharePoint/Creating-a-shareable-document-link-that-forces-a-document-to/m-p/296647#M24291
AutoNumbering Columns in SharePoint List
Good morning, I have a Sharepoint list used for tracking my documents. I manually number each document, but this has become challenging over the past month. Is there a way to automatically create a unique ID? I need something that starts with the two-digit year and has the document number created that year. for example, 22-205 22 for the two-digit year 205 for the document added that year. The number will also need to be reset every year. Once January first, 2023 comes, the following document created will be 23-001. Can someone assist me?Azure Functions - Part 2 - Unit and Integration Testing
A unit test usually involves writing code to test a specific function or method, using input data and expected output data. The test code then executes the function or method with the input data, compares the resulting output to the expected output, and reports any discrepancies as errors or failures. This approach allows developers to test each unit of code in isolation, ensuring that their code is modular, well-designed, and functioning as intended.
Can't Save or download Photo from Teams to iPhone Photos
If I open the share options in Teams for a jpg photo, it does not show an option to "Save" the photo. I need to save it to my iOS Photos, but cannot. Any help greatly appreciated! I am on an iPhone 11 Pro Max, running the latest iOS 13 software and the most up to date Teams app.Deploy and run a Azure OpenAI/ChatGPT app on AKS with Terraform
This article shows how to deploy an Azure Kubernetes Service(AKS) cluster and Azure OpenAI Service via Terraform and how to deploy a Terraform chatbot that authenticates against Azure OpenAI using Azure AD workload identity and calls the Chat Completion API of a ChatGPT model.Edge on Android isn't available for opening PDFs
Android 9 pie and latest version of Edge Android beta, in the file manager when I "Open with" on PDF file, Edge isn't available. I'd like the same features we have on desktop, Mac, Linux to be available on Android and IOS too. if you want the same, please send a feedback through Edge browser about this. thank you
