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?

2 Answers 2


You are using the SharePoint List item action in Flow right? For better working with fields and so one use HTTP request and create REST API get to the SharePoint list, I always using it this way.


In the dynamic contents window in Flow, select "see more" to show all of the columns.

  • Thanks for the idea. I tried, but I still don't see it. Does it matter that the field is not called "Title" Jan 11, 2019 at 22:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.