Is it possible to attach details from one sharepoint list to another like vlookup in excel? For example if I type unique index in one field, all details will be import from another sharepoint list. Any ideas how to do that? Can't find any solution.
CodePudding user response：
You could use lookup column in the SharePoint list.
Reference: How to create a Lookup column in SharePoint
CodePudding user response：
Sharepoint lists are not linkable like tables in relative databases. You could write a webpart or script or something else to 'connect' them. You can use the APIs to get their contents and write a function which processes the contents. After processing you could use another API to write the results in another SharePoint List.
- GET List_1 Data
- GET List_2 Data
- Process(List_1_data, List_2_data)
- POST result to List_n