0

I have 3 Sharepoint lists named has list1 list2 and list3 there are 2 common fields in all the lists. I want to get the itemscount/items from all the this 3lists && filtering the data with 2columns

EX- Get count of Items/ItemCount from 3lists where Status="active" && Email="someone@gmail.com"

using SPO Rest Api

apaderno
  • 28,547
  • 16
  • 75
  • 90
Krishnareddy Chinthireddy
  • 41
  • 4

1 Answers1

1

rest api can only get items from one list at the same time. You can refer to the following url

/_api/web/lists/GetByTitle('list1')/items?$filter=(Status = 'active' and Email = 'someone@gmail.com')
RaytheonXie-MSFT
  • 571
  • 3
  • 4