Include data from Lookup Field in a Calculated Field in Modern SharePoint

Question

I used to use a SharePoint Designer Workflow to include data from a Lookup Field in a Calculated Field. With Modern SharePoint, what is the method I should use to include data from a Lookup Field in a Calculated Field or is there a completely different method I should use to combine data from a Lookup field with another Text Field in a new Field where I can display them as one data set? I cant find anything that discusses new methods using Modern SharePoint. I can only find the Workflow method from Classic SharePoint but I cant use SP Designer anymore so that wont work.&nbsp;

pamdegraffenreid · Answer

This isn't going to work with a calculated column. Any chance you can use Power Automate?

slonakerg · Answer

PamDeGraffenreid&nbsp;I have Power Automate Available to me but havent been tried using it yet.&nbsp; What I am basically trying to do is use a Full Name field from a different list (I get access to the Full Name via a Lookup Field) in a Leave-Travel Calendar I am creating so i can combine the Full Name field with the Event Type (Leave or Travel) so they can appear on the Monthly Calendar like this "John Smith - Travel (Alexandria, VA)".&nbsp; &nbsp;The Location field automatically shows on the Calendar so I only need a way to combine the Full Name and the Event Type.&nbsp; I have tried researching an easy solution knowing it should be easy in Modern SharePoint but I cant find one and I dont have time to take a full course in all of the new tools because I need to solve this ASAP.&nbsp; I hope this makes sense.

pamdegraffenreid · Answer

I understand. There isn't an out of the box way to do this - you need a workflow (Power Automate or SPD 2013), or you might be able to use JSON formatting setValue that would combine the location and lookup value [$lookupcolumn.lookupValue].

gillesv · Answer

I hope SlonakerG​ got a solution by this time, but PamDeGraffenreid​ , could you post a quick summary of the Power Automate solution to this quite known problem? (i.e."lookup values can't be used in formulas of calculated fields!") I'm using a simple [When item is crtd or mdfd]&gt;[Get item]&gt;[Update item], to just copy the lookup value in a simple text field (then, use it in my calculated field), but I'm not used to PA flows and can't figure out how I must get the value currently stored in the lookup field, update the current item's text field, and most important, not create a infinite looping flow. TIA

gillesv · Answer

Hi. Any chance that you provide an example to this common problem. I tried to just copy the lookup value to a simple text field that I could use in the formula of a calculated field. But I'm not used to it and I can't make it work with a PA workflow like [When an item is crtd or mdfd]&gt;[Get item]&gt;[Update iteml].&nbsp; I don't know how to get the value from the lookup field, and set it in the current item's text field. And, most important: avoid infinite loop. TIA

Forum Discussion

Include data from Lookup Field in a Calculated Field in Modern SharePoint

5 Replies

Resources