I am trying to query a list with lookup column to another list, basically I have sub announcements, and announcements, I want to get all sub announcements of particular announcement, so my query looks like this:
https://domainname.sharepoint.com/sites/hr/_api/web/lists/getByTitle('Sub Announcements')/items?$select=Title,Announcements/Title&$expand=Announcements/Title&$filter=(Announcements/Title eq 'Parent Announcement1')
but am getting the error:
The field or property 'Announcements' does not exist.
Also what if the parent list has space in the name, in the expand do we put the name with spaces? for example do we put $expand= List name with space/Title ?
Thanks for the clarification.