Hi everyone;
I want to discuss a question relate Lookup Column in Sharepoint.
Until now, we usually using Additional Column come with Lookup Column to get more information about an object. This method is great if we have only 2 Lists and One Lookup to another. But when we have more than 2 Lists, especially Lists describe a process, where Lists need to get information the List before, Additional Lookup Column may not solves that problem. Because Lookup Column and even Calculated Column doesn't support Lookup Field.
I have just received support from MSFT team to solve a problem related to this topic, via using Flow to Get Lookup ID Field to Get Value of the other Columns relates this Field. It means you can create one Lookup Column in the Source List and use Flow get any value of the Column to relate the item the Lookup Column point to.
I realize this method have pros and cons:
Pros:
- We can get value from any site, not need to be on the same site.
- This value gets is in the Number, Text, Currency,... which can be used in more purpose like calculate, lookup in another List after...
Cons:
- It takes time to set the flow. And the time to maintain it
- If the value of Item update in the Target List, it needs to be updated in the Source List. Only one Flow to getting Item doesn't solve this problem. We need one more to update these items.
Summary, I am a new user SharePoint, I want to know in the future or today when the data need to connect to display in more views of more lists,
- What we should do with Lookup columns? The main way we do.
- Each specific case for the two above methods? If you have more method, please share with me.
If I have a wrong analysis, I hope you can tell me to correct it. Thanks for the community.
