Please improve Lookup columns. Here are a few suggestions:
- Why a list cannot have a lookup column that looks up the a lookup column in another list? Lookup columns are only usable among two lists. They should be expanded to more than that.
- We should be able to copy the values and IDs of lookup columns to calculated columns.
- A change in the value of a lookup field should trigger a flow but unfortunately, it does not do that right now.
- Without the above features it is almost impossible to link multiple SharePoint lists together and multi tier lists.
Marcelo Sauaf commented
a must to list for n-n entity relationships