Allow lookup columns brought up from different list into calculated columns
Dear Microsoft, this limitation causes a huge impact in our organization - we have been trying to migrate from MS Access into Share Point due to the collaboration it brings, but the limitation of not being able to use "lookup columns" from other lists into "calculated columns" is pretty bad. It affects negatively our ability to compare and do calculation with values from different fields. The whole purpose of MS Access is to run these queries, but since MS shifted to Share Point we thought that was possible as it not. Please do what it takes to make this happen!
I appreciate your support!
Regards,
Harry
Harry Reynolds
shared this idea
18 comments
-
J Bedford
commented
Why this doesn't just function like a SQL View is beyond me.
-
Ruben Wills
commented
Definitely would like to see this as a feature. It would open up so much possibility for list functionality.
-
Rob Elliott
commented
As a workaround (or as an even a better solution) this can be achieved with Power Apps as you can have multiple data sources, do calculations on them and write the data back to the SharePoint list.
-
Anonymous
commented
This is pretty poor that what would seem to be a fairly basic aspect, such as being able to calculate based on looked up values, is not available. Do not understand why MS enabled viewing the data in a field if there is nothing you can do with
-
Carol Brown
commented
I need this ASAP. I am trying to evangelize the use of SharePoint and Forms and this is limiting my ability. Does anyone know of a work around (in the list) not with Flow but may be JavaScript etc.
Please make this available
-
Michael Tondu
commented
How is this not possible yet?? 1 trillion $ in market cap for such limited software is beyond me.
-
Kamyrion Lopez
commented
Just why does this not work? From a user perspective this is a bad miss.
-
Anonymous
commented
As mentioned of many other users I have just faced this issue as well. Really annoying when you by a choice in a column need to pick data from one of two SP lists (Lookup Columns). Any official MS status on this issue?
-
Benjamin Gilardi
commented
Allowing lookup columns in a calculated field would make views significantly more flexible and would eliminate complicated workflows.
-
Anonymous
commented
I agree - this really is a serious requirement. It's one of the main reasons I cannot move a lot of our Excel Spreadsheets to a SharePoint list
-
Anonymous
commented
RIght now we have to rely on Flow to transfer the data from lookup columns to columns we can use in calculated columns. This takes a great deal of time and makes our Sharepoint list almost unusable. What is stopping Sharepoint from allowing data in lookup columns to be used in calculation columns?
-
Starfish Health Wellbeing
commented
I REALLY need this
-
Anonymous
commented
Really, really, really could use this right now. Need to make some complicated calculations and linking between list and library and back again really, really, really could use look up to include calculated columns and multiple choice columns.
-
rtsrt
commented
Please make this available in SharePoint. It is incredibly frustrating to have to create all kinds of SP Designer Workflows to do such a simple process as copying the contents of one column into another for tools such as Power BI.
-
David
commented
Is there any update on this issue? Having to build workarounds with new columns and workflows is an unnecessary headache for everyone.
-
Bernd Holy
commented
This feature would make life much easieras the workaround would require us several runs of a flow.
It's also much more administration work to maintain all those workaround flows. -
Raymond Kilgariff
commented
Yes absolutely along with the networkdays function in calculated columns
-
JoeD
commented
I agree, this is pretty silly.
