Forum Discussion
Include data from Lookup Field in a Calculated Field in Modern SharePoint
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 ...
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].
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]>[Get item]>[Update iteml]. 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