Microsoft Lists Tutorial: How to Connect Data Between Lists with Lookup Columns (2023)

Is there a way to lookup an image for product category

Thank you for the very clear explanation. Super helpful! Question: I was hoping to use the values from one SharePoint lookup in a formula. However it seems like SharePoint lists doesn't allow you to use formulas with lookup columns. Is there a workaround for that? Surprising that would be a limitation. Admittedly I'm new to SharePoint lists and may not know how. Either way thanks for this super helpful video.

Hi,

Thank you for this. Quick question, when the look up is done, and you 'edit in grid view' which then gives you the drop down options for what you want to copy over to this list...

Cant that be skipped and ensure its all done automatically? Where a new row is populated in list two, when a new row is added in list 1?

Hope that makes sense

would love to lookup active directory based on email addresses and populate columns with AD information i.e. department, home office, etc.

Thanks! Through the customer list we cannot click on a link taking us to the orders for that specific customer right? I mean directly using lists. I know we can do through powerapps etc but native lists the two way connection is not possible or?

Is there a way for us to filter certain product for a certain Customer?
For example, product shown for customer A will be for 1,2 and 3, and for customer B the product shown will be 4,5 and 6.

thank you for great tutorial. why some of column in Customer name List does not appear. for example internal account. Please assist me