I have created a site lookup column (with 2 additional columns) on my parent site. I'm using this site lookup column on a list in a child site to populate location. I have created a Flow to send an email when a new item is created in the child's list. I want to include the location in the body of the email, but it is not available in the dynamic content sections of Flow. I have already checked that I am not using the Location (linked to item) at the parent level and beyond. Does anyone know how to get this type of information from SharePoint to be available in Flow?