how to display 2 sharepoint lists(connected by lookup field) in a common datatable on a page using rest api

Question

question

Mahi-9844 asked Sep 17, '21 RaytheonXie-MSFT commented Oct 4, '21

how to display 2 sharepoint lists(connected by lookup field) in a common datatable on a page using rest api

i want to display 2 sharepoint lists(connected by lookup field) in a common datatable on a page using rest api. The functions for retrieving data from both the tables should be different

office-sharepoint-online sharepoint-dev

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-09-20T04:12:02.957Z

RaytheonXie-MSFT answered Sep 20, '21 RaytheonXie-MSFT commented Oct 4, '21

Hi @Mahi-9844 ,
We can retrieve all datas connected from one of the list by rest api. I created two list. Table 'CompanyTest01' has a column 'Company' look up table 'Address' with two columns : 'City' and 'State'.I tested the following code and successful retrieve all datas.
133452-sample.txt

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

sample.txt (1.2 KiB)

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RaytheonXie-MSFT · Sep 23, 2021 at 01:42 AM

Hi @Mahi-9844 ,
I am checking to see if the problem has been resolved.

0 ·

RaytheonXie-MSFT · Oct 04, 2021 at 08:48 AM

Hi @Mahi-9844 ,
If there's anything you'd like to know, don't hesitate to ask.

0 ·

question