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].
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]>[Get item]>[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