Forum Discussion
Is Connecting multiple Sharepoint Lists Really Worth it?
GaliGonen3555 You are correct. Lookup columns only support below column types:
Single line of text
Number
Date and Time
Lookup (single value)
If you are using other column types, you have to maintain the copy of data in both lists. You can use power automate flows to copy the data from one list to another list whenever a item is created/updated in a list.
Microsoft documentation: Create list relationships by using lookup columns
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
GaliGonen3555 You are correct. Lookup columns only support below column types:
Single line of text
Number
Date and Time
Lookup (single value)
If you are using other column types, you have to maintain the copy of data in both lists. You can use power automate flows to copy the data from one list to another list whenever a item is created/updated in a list.
Microsoft documentation: Create list relationships by using lookup columns
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
GaliGonen3555 It depends on your requirements. If you are going to use the tables & data to build apps/solutions using Power platform (power apps, etc.), you should try Microsoft Dataverse tables and relationships
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.