SOLVED

SharePoint Online Column Calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-1774166%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20Column%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1774166%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI%20have%20created%202%20lists%20on%20my%20SharePoint%20Online%20page.%3CBR%20%2F%3EIn%20the%202nd%20list%20I%20created%20a%20LookUp%20column%20to%20a%20number%20column%20from%20the%201st%20list.%3CBR%20%2F%3ENow%20I%20want%20to%20create%20a%20calculated%20column%20in%20the%202.%20list%2C%20in%20which%20one%20column%20is%20calculated%20with%20the%20LookUp%20column.%3CBR%20%2F%3EI%20always%20get%20the%20error%20message%20that%20he%20can%20not%20find%20the%20columns.%3CBR%20%2F%3EIs%20there%20a%20workaround%20how%20to%20solve%20this%3F%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20and%20best%20regards%3CBR%20%2F%3ESilas%20Muth%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1774166%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1774438%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20Column%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1774438%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F821583%22%20target%3D%22_blank%22%3E%40Silas_Muth%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3BLookup%20columns%20are%20%3CSTRONG%3Enot%20supported%3C%2FSTRONG%3E%20in%20Calculated%20column%20formulas.%3C%2FP%3E%3CP%3E%3CSTRONG%3EWorkaround%3C%2FSTRONG%3E%3A%20You%20need%20to%20create%20a%20Power%20Automate%20flow%20(or%20designer%20workflow).%26nbsp%3B%3CSPAN%3ERun%20the%20workflow%20on%20item%20create%20and%20item%20update.%20In%20workflow%20you%20can%20update%20the%20column%20in%20list%202%20with%20the%20number%20value%20from%20your%20lookup%20column.%3C%2FSPAN%3E%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20solve%20your%20issue.%20This%20will%20help%20others%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20content%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,
I have created 2 lists on my SharePoint Online page.
In the 2nd list I created a LookUp column to a number column from the 1st list.
Now I want to create a calculated column in the 2. list, in which one column is calculated with the LookUp column.
I always get the error message that he can not find the columns.
Is there a workaround how to solve this?

Thank you very much and best regards
Silas Muth

 

1 Reply
Highlighted
Best Response confirmed by Silas_Muth (New Contributor)
Solution

@Silas_Muth , Lookup columns are not supported in Calculated column formulas.

Workaround: You need to create a Power Automate flow (or designer workflow). Run the workflow on item create and item update. In workflow you can update the column in list 2 with the number value from your lookup column.


Please click Mark as Best Response if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it Like.