Screenshot of Lookup column setting I am trying to retrieve data from a list containing the lookup field. I want to check values in the lookup column list. My API is - _api/web/lists/GetByTitle('ApprovalMaster')/items?$select=Id,Comment,RowId,ApproverStatus,Modified,FormId/Id,FormId/ListName,FormId/FormName,FormId/Created,FormId/Status&$filter=(FormId/SubmitterId eq 1 and FormId/FormName eq 'SFO')&$expand=FormId
I have tried many combinations but nothing worked. It is giving results when I try with a single condition but it is not giving results combining the two conditions. Any help will be appreciated.
