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.