Forum Discussion
Include data from Lookup Field in a Calculated Field in Modern SharePoint
PamDeGraffenreid I have Power Automate Available to me but havent been tried using it yet. 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)". The Location field automatically shows on the Calendar so I only need a way to combine the Full Name and the Event Type. 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. I hope this makes sense.
- 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
