Forum Discussion
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...
jasenpeters you can't reference a lookup column in a calculated column formula. You could use a flow in Power Automate to create the ReportNumber and display that in a single line of text column.
Rob
Los Gallardos
Microsoft Power Automate Community Super User